Microsoft Connectors for Oracle and Teradata by Attunity (SQL Server 2008)
Hello Everyone,
One of my previous blogs, referred to the Issue of working with an Oracle DB Source,
Two major Issues are presented when facing an Oracle Data source:
1. How to handle a 64bit environment
2. The Lack of Support within the OLEDB Provider for the case of Oracle Numeric type,
When precision is undeclared.
While the first Issue, was addressed successfully (Setting up Both 32bit and 64bit Oracle ODP provider).
The Issue of the numeric type, was poorly solved using either Oracle 11g provider (which conflicts with WSS or MOSS),
Or by doing casting within the SQL Queries.The Following Provider offers better compatibility to the BIDev,
It solves the need to tackle the environment settings for running the 32bit provider using VS, while processing a x64 task.
The Provider Could be downloaded from the Following Link:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en
Pre-requests:
The following Microsoft SQL Server products are supported by the SSIS components for Oracle:
| • |
Microsoft SQL Server 2008 |
| • |
Microsoft Business Intelligence Development Studio for SQL Server 2008 |
These versions are supported on the following operating systems and platforms:
• |
Windows XP 32-bit (x86) and 64-bit (x64) |
| • |
Windows Vista 32-bit (x86) and 64-bit (x64) |
| • |
Windows Server 2003 32-bit (x86), 64-bit (x64), and 64-bit Itanium (IA64) |
| • |
Windows Server 2008 32-bit (x86), 64-bit (x64), and 64-bit Itanium (IA64) |
The Microsoft SSIS components for Oracle support the following Oracle database versions:
| • |
Oracle 9.2.0.4 and higher |
To work with the Microsoft Oracle Connector by Attunity you must install the Oracle client software version 10.x or 11.x, on the computer with SSIS. (On 64bit systems a 32bit + 64bit Oracle Connecters are needed). Have Fun,
Eran