在 Visual Studio 2017 中安装 Oracle Attunity 驱动程序 [英] Install Oracle Attunity Drivers in Visual Studio 2017

问题描述

我正在尝试为您的 SSIS(提取/转换)层的未来环境进行演示安装.为此，我需要 Oracle Attunity 驱动程序.

我已经安装:

1. Visual Studio 15.9.7
2. SQL Server 数据工具 15.1.61901.24070
3. SQL Server 管理工作室 17.9.1
4. Windows Server 2019 Standard 10.0(内部版本 17763:) 上的 Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - 14.0.2002.14 (X64) 企业评估版(64 位)

根据

这会导致以下问题:

1. 那些是合适的 Attunity 驱动程序吗?
2. 我要检查一下吗?
3. 如果没有，我该如何安装正确的驱动程序?

解决方案

解决方案

我终于想通了:Attunity 驱动程序仅适用于 VS2017 15.8.0 不 15.8.1 及更高版本的 SSDT.可以加载以前版本的 SSDT

您可以通过查看添加连接管理器"对话框来仔细检查这一点 - 如果这指向您的 attunity-insallation 文件夹，那么您是正确的.

有趣的是，这些驱动程序似乎覆盖了我在初始帖子中看到的正常"Oracle 驱动程序.

请注意，Visual Studio 的关于部分"中的数字不会与安装包的版本进行比较.SSDT-Tools (15.8.0) 的工作版本在 VS 中表示如下:

参考资料

SQL Server Data Tools (SSDT) 的更新日志 [15.8.1 &15.8.2] 指出:

<块引用>

适用于 Visual Studio 2017 (15.8.2) 的 SSDT 不支持设计包含 Oracle/Teradata 源/目标的包.将 SSDT 用于 Visual Studio 2017 (15.8).

来源:https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt?view=sql-server-2017

感谢 这个家伙导致这个讨论 放弃.

I am trying to make a demo install for the future environment of your SSIS (Extraction / Transformation) layer. For this to be successful I need the Oracle Attunity Drivers.

I have installed:

1. Visual Studio 15.9.7
2. SQL Server Data Tools 15.1.61901.24070
3. SQL Server Management Studio 17.9.1
4. Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - 14.0.2002.14 (X64) Enterprise Evaluation Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763:)

Accordint to Documentation I need Version 5.0 of said Attunity Oracle Drivers. Problem is, if I install these nothing in Visual Studio changes.

There are already some oracle source/destinations (maybe they come trough the oracle software I needed to install on the machine to enable data connections) but I am pretty sure that they are installed with visual studio, hence they are not Attunity "special" Drivers.

Screenshot Oracle SourceDestination

This leads to the following Questions:

1. Are those the proper Attunity Drivers?
2. Ho do I check this?
3. If not, how do I install the proper drivers?

解决方案

Solution

I finally figured it out: Attunity Drivers only Work on SSDT for VS2017 15.8.0 NOT 15.8.1 and later. Previous versions of SSDT can be loaded here.

(Be prepared to use a browser with the same language as your installation since you can not change language on the page (way to go microsoft..) and installing German (for example) SSDT on English Visual Studio will be refused.)

Explanation

To end my initial confusion: It is only Oracle by Attunity if there is a red O in the top left of the Tool.

You can double check this by looking at the "add connection manager" dialogue - if this points to your attunity-insallation folder you are correct.

Funny enough, this drivers seem to overwrite to "normal" Oracle Drivers I have been seeing in the inital post.

Be aware that the Numbers in the "About Section" of Visual Studio do not compare to the Version of the Installation Package. The working Versions of SSDT-Tools (15.8.0) are represented in VS as follows:

References

The Changelog for SQL Server Data Tools (SSDT) [15.8.1 & 15.8.2] states:

SSDT for Visual Studio 2017 (15.8.2) doesn't support designing packages that contain Oracle/Teradata source/destination. Use SSDT for Visual Studio 2017 (15.8).

Source: https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt?view=sql-server-2017

Thanks to this guy leading to this discuission giving it away.

这篇关于在 Visual Studio 2017 中安装 Oracle Attunity 驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！