Dibaca dalam bahasa Inggeris Edit

Kongsi melalui

Microsoft Connector for Oracle

  • Artikel

Applies to: SQL Server

Penting

Microsoft Connector for Oracle is deprecated now. Details refer to the announcement.

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
  • Microsoft SQL Server 2022
  • SQL Server Integration Services Projects for Visual Studio 2019
  • SQL Server Integration Services Projects for Visual Studio 2022

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.

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.

Visual Studio expects the x86 version of the connector to be installed on the machine being used to develop SSIS packages. By default, packages in the SSIS catalog run in 64-bit mode and therefore use the x64 version, but they can be configured to run in 32-bit mode. To accommodate both modes, you'll need to install both the 32-bit and 64-bit versions of the connector.

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.

Nota

To design packages with SQL Server Integration Services Projects, you'll need to install the appropriate connector for both the target and the latest SQL Server version.

For example, if you upgrade to Visual Studio 2022 but deploy to SQL Server Integration Services 2019, you need to install MicrosoftSSISOracleConnector-SQL22 and MicrosoftSSISOracleConnector-SQL19.

To execute SSIS packages targeting SQL Server 2019 and above, you don't need to install an Oracle client to use the Microsoft Connector for Oracle. To execute SSIS packages targeting SQL Server 2017 and below, in addition to Microsoft Connector for Oracle, you'll need to install an Oracle client and Microsoft Connector for Oracle by Attunity with the corresponding version from below links:

Limitations and known issues

  • Views aren't 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.
  • The Microsoft Connector for Oracle can only be used by implementing an Oracle Source or Oracle Destination in a data flow task. It isn't available for other SSIS tasks, including Execute SQL tasks.

Uninstallation

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

Next steps