Install Oracle Attunity Drivers in Visual Studio 2017

Question

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?

Answer 1

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://learn.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.