Today I finished a white paper on configuring Oracle drivers for Microsoft BI applications (like Integration Services, Analysis Services and Reporting Services). I've configured these environments quite often, but like so many things my brain has a hard time remembering all the nuances every time.
So to help myself--and hopefully some others as well--I put all the basics down on paper. Beyond being a "white paper", this one has complete configuration instructions (with screen shots) to install, configure and test Oracle drivers in a 64-bit environment.
Please feel free to download the full document as a PDF. Hope this helps!
From the white-paper intro:
Summary: This white paper describes the procedures needed to configure Oracle database drivers for use in Microsoft BI services (SSIS, SSRS, SSAS and BIDS) in a 64-bit Windows Server 2008 R2 environment.
This article covers the selection and configuration of Oracle database drivers, including detailed configuration procedures.
Specific coverage is given to configuration requirements for scenarios where BIDS is installed and used on 64-bit SSIS servers.
This document includes configuration procedures for both the 64-bit and 32-bit versions of the Oracle Provider for OLEDB and the Microsoft Connector for Oracle by Attunity.
While the primary target for this document is SQL Server 2008 R2, the techniques and discussion also apply to SQL Server 2008 and SQL Server 2005 product versions.