Microsoft Connector for Oracle is now generally available.
Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages designed with Attunity Oracle Connector can run with Microsoft Connector for Oracle without any changes. The following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:
To install the connector for Oracle database, download and run the installer from the latest version of Microsoft connector for Oracle. Then follow the directions in the installation wizard.
Open SSDT 15.9.3 or later, Oracle components can be found in SSIS Toolbox, under Common Category.
And in Connection Managers, Oracle connection manager is displayed with type “ORACLE”.
Microsoft Connector for Oracle provides similar user experience with Attunity Oracle Connector. User can design new packages based on previous experience.
Existing SSIS packages which have been designed with Attunity Oracle Connector will be automatically upgraded to use Microsoft Connector for Oracle. The icons will be changed as well.
If the project is targeting Pre-SQL Server 2019, corresponding Attunity Oracle Connector and Oracle client are required to be installed on the SSDT machine for package execution.
Attunity Oracle Connector download links:
Please refer to this page for more detail usage.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.