Oracle Driver configuration for SSIS, SSRS and SSAS in a 64-bit Environment

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.

Read more...