Rediger

Microsoft Connector for Oracle

  • Artikkel
  • 2 minutter å lese

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.

Version support

The following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:

  • Since SQL Server 2019 CU1
  • SQL Server Data Tools (SSDT) 15.9.3 or later for Visual Studio 2017
  • Microsoft SQL Server Data Tools (SSDT) for Visual Studio 2019

The following Oracle database versions of data source are supported:

  • Oracle 10.x
  • Oracle 11.x
  • Oracle 12c
  • Oracle 18c (without Windows Authentication support)
  • Oracle 19c (without Windows Authentication support)

The Oracle database is supported on all operating systems and platforms.

Note

Oracle client is not required for Microsoft Connector for Oracle database in SQL Server 2019.

Installation

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.

After you install the Connector, you must restart the SQL Server Integration Service to be sure that the Oracle source and destination can work correctly.

To execute SSIS package targeting SQL Server 2017 and below, in addition to Microsoft Connector for Oracle, you will need to install Oracle client and Microsoft Connector for Oracle by Attunity with corresponding version from below links:

Limitations and known issues

  • Views are not listed under Oracle source Name of the table or the view. As work-around, use the SQL command and do a select * from view, or set view name to property [Oracle Source].[TableName] in Advanced Editor.

Uninstallation

You can run uninstall wizard to remove Microsoft Connector for Oracle database from SQL Server.

Next steps