VS 2015 Shell中缺少针对Oledb的Oracle提供程序

问题描述

我正在迁移到SSIS 2016版本.我正在尝试在连接中将Oracle提供程序用于Oledb.

I am migrating to SSIS 2016 version. I am trying to use the Oracle provider for Oledb in connections.

但是，此选项不显示.我已经安装了Oracle客户端12.2，并且能够执行UDL文件测试，在其中可以看到Oracle提供程序并能够测试连接.

However, this option does not show. I have installed the Oracle client 12.2 and I am able to do UDL file testing, where in I can see the Oracle provider and able to test connection.

但是当我在VS 2015中尝试时，该选项未显示.

But when I try in VS 2015, the option is not shown.

此处描述了此问题- https://jorgklein.com/2011/06/02/ssis-connect-to-oracle-on-a-64-bit-machine-updated-for- ssis-2008-r2/，在此基础上，我安装了64位客户端.但是，当尝试使用连接管理器时，未显示oracle提供程序.

The issue is described here - https://jorgklein.com/2011/06/02/ssis-connect-to-oracle-on-a-64-bit-machine-updated-for-ssis-2008-r2/ and based on this I have installed the 64 bit client . But when trying to use the connection manager, the oracle provider is not shown.

该如何解决?

推荐答案

从SSIS连接到Oracle的推荐方法是使用Attunity连接器，该连接器可确保高性能且易于使用.如果选择使用Oracle Provider for OLEDB，则应下载Oracle数据访问组件(ODAC)和Oracle Visual Studio工具.

在此答案中，我将提供有关如何从SSIS连接到Oracle的详细信息，并且会提供一些指向您问题的解决方案的链接

有很多方法可以从SSIS连接到oracle:

There are many way to connect to oracle from SSIS:

这是Oracle数据访问组件(ODAC)的一部分

Which is a part of the Oracle Data Access Components (ODAC)

• Oracle-Visual Studio工具
• 32位Oracle数据访问组件(ODAC)和NuGet下载
• 用于OLEDB的Oracle Provider

• Oracle - Visual Studio Tools
• 32-bit Oracle Data Access Components (ODAC) and NuGet Downloads
• Oracle Provider for OLEDB

以下链接包含类似的问题:

The following link contains a similar issue:

• 未在SSIS中列出的Oracle OLE DB提供程序

这是Microsoft数据访问组件(MDAC)的一部分

Which is a part from Microsoft Data Access Components (MDAC)

• Oracle的Microsoft OLE DB提供程序概述
• Microsoft OLE DB Provider for Oracle Overview
• Microsoft连接器用于Oracle和Teradata by Attunity for Integration Services(SSIS)
• Microsoft Attunity连接器
• Microsoft Connectors for Oracle and Teradata by Attunity for Integration Services (SSIS)
• Microsoft Connectors by Attunity
• Attunity的Oracle SSIS连接器与OLE DB性能的Oracle提供程序
• Oracle客户端数据提供者VS OLEDB的Oracle提供者
• SSIS Connectors for Oracle by Attunity vs Oracle provider for OLE DB performances
• Oracle Client DataProvider VS Oracle Provider for OLEDB
• 在SSIS中从Oracle导入 (从Oracle客户端安装到数据导入)
• Microsoft OLE DB Provider for Oracle(MSDAORA)for 64 bit?
• 带有Oracle连接器的SSIS
• Importing From Oracle In SSIS (from Oracle client installation to data import)
• Microsoft OLE DB Provider for Oracle (MSDAORA) for 64 bit?
• SSIS with Oracle Connectors

这篇关于VS 2015 Shell中缺少针对Oledb的Oracle提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！