Attunity connector for SQL Server 2019 Standard Edition

SANDEEP TADISHETTY 41 Reputation points
2022-09-20T20:16:27.38+00:00

Hi,

I installed both 32-bit and 64- bit versions of Attunity Oracle connector from Microsoft website but still do not see connectors in my Visual Studio 2019. Please let me know the process since I am trying to extract data from Oracle 19c source to SQL Server 2019 and it is very slow with OLEDB Source connection from Oracle.

Versions and Editions:

OS: Windows Server 2022 Standard Edition

SQL Server: SQL Server 2019 Standard Edition (15.0.4249.2)

Visual Studio: Visual Studio Enterprise 2019 ( 16.11.18)

Oracle Source Database: Oracle 19c

Note: I have also installed Oracle 32 bit and Oracle 64 bit admin client.

https://www.microsoft.com/en-us/download/details.aspx?id=58228

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,468 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,551 Reputation points
    2022-09-21T01:53:34.483+00:00

    Hi @SANDEEP TADISHETTY ,

    Please note that SQL Server Integration Services Projects 4. versions* are not support Oracle connector yet.

    Please try to use version3.16: https://ssis.gallerycdn.vsassets.io/extensions/ssis/sqlserverintegrationservicesprojects/3.16/1645603822968/Microsoft.DataTools.IntegrationServices.exe

    Don't forget to re-start VS after you installed the Microsoft Connector for Oracle.

    The oracle source and oracle destination will appear in common component.

    243156-image.png

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


1 additional answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,201 Reputation points
    2022-09-20T21:17:35.63+00:00

    Hi @SANDEEP TADISHETTY ,

    Microsoft has very performant Microsoft Oracle Connector for SSIS.
    It will work on SSIS run-time server with SQL Server 2019 Enterprise Edition only.
    SQL Server 2019 with SSIS, Standard Edition will not work for such setup.