Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

General availability of Microsoft Connector for Oracle

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
May 25, 2020
Microsoft Connector for Oracle is now generally available.    Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages desig...
Updated May 25, 2020
Version 1.0
jahill's avatar
jahill
Copper Contributor
Mar 21, 2022

Posted originally to a wrong blog

 

I'm trying to figure out if and what Affinity connector to use. We had previously not been able to get it work on SQL Server 14 on Windows Server 2012 R2. We have upgraded to SQL Server 14 We are just upgrading our SQL Server. Currently our plan is to upgrade to SQL Server 2016. So our system will be

  • Windows Server 2012 R2
  • SQL Server 2016
  • Visual Studio 2017 with SSIS Version 14.0.3002.68
  • Oracle 19c.

The requirements for Microsoft Connectors v4.0 for Oracle say  Supported Oracle databases : Oracle 10.x; Oracle 11.x; Oracle 12c. Not sure if that just means it's not supported by Microsoft or that it will not work period with Oracle 19c. The OLE DB Source/destination are so much slower than the oracle ones and we would like to take advantage of the oracle destination/source ones.

 

Can this be done or do we have to wait and upgrade to SQL Server 2019?