microsoft for oracle,Microsoft Connector for Oracle

Microsoft Connector for OracleMicrosoft Connector for Oracle

08/14/2019

本文内容

适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory

使用 Microsoft Connector for Oracle，可以从 SSIS 包内的 Oracle 数据源中导出数据，并向其中加载数据。Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.

版本支持Version support

Microsoft Connector for Oracle 支持以下 Microsoft SQL Server 产品：The following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:

SQL Server 2019 CU1 及更高版本Since SQL Server 2019 CU1

适用于 Visual Studio 2017 的 SQL Server Data Tools (SSDT) 15.9.3 或更高版本SQL Server Data Tools (SSDT) 15.9.3 or later for Visual Studio 2017

适用于 Visual Studio 2019 的 Microsoft SQL Server Data Tools (SSDT)Microsoft SQL Server Data Tools (SSDT) for Visual Studio 2019

支持以下 Oracle Database 版本的数据源：The following Oracle database versions of data source are supported:

Oracle 10.xOracle 10.x

Oracle 11.xOracle 11.x

Oracle 12cOracle 12c

Oracle 18c(不支持 Windows 身份验证)Oracle 18c (without Windows Authentication support)

Oracle 19c(不支持 Windows 身份验证)Oracle 19c (without Windows Authentication support)

所有操作系统和平台都支持 Oracle Database。The Oracle database is supported on all operating systems and platforms.

备注

在 SQL Server 2019 中，Microsoft Connector for Oracle Database 不需要 Oracle 客户端。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.

安装连接器后，必须重启 SQL Server Integration Services，才能确保 Oracle 源和目标正常运行。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.

要执行面向 SQL Server 2017 及更低版本的 SSIS 包，除了 Microsoft Connector for Oracle，还需要安装 Oracle 客户端以及 Microsoft Connector for Oracle by Attunity，相应版本可见以下链接 ：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

视图不会在 Oracle 源“表或视图的名称”下列出。Views are not listed under Oracle source Name of the table or the view. 要解决此问题，请使用 SQL 命令并执行 select * from view，或在高级编辑器中将视图名称设置为属性 [Oracle Source].[TableName]。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

要从 SQL Server 中删除 Microsoft Connector for Oracle Database，可以运行卸载向导。You can run uninstall wizard to remove Microsoft Connector for Oracle database from SQL Server.

后续步骤Next steps