Install Oracle Attunity Drivers in Visual Studio 2017

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.

Are those the proper Attunity Drivers?

What i can tell you is that the those are third party components, they are not installed with Visual Studio or SSDT. Also, on the other hand the Attunity Oracle components name are the same (Oracle Source , and Oracle Destination).

But i think that the Oracle Attunity components have different icons:

Click on the component and read the description at the bottom of the SSIS toolbox it may helps.

References:

• Setup Of Oracle Attunity Connectors
• MICROSOFT CONNECTORS BY ATTUNITY

Ho do I check this?

Check that the components dll are found inside the following directories:

32-bit

C:\Program Files (x86)\Microsoft SQL Server\<sql version>\DTS\PipelineComponents\
C:\Program Files (x86)\Microsoft SQL Server\<sql version>\DTS\Connections\

64-bit

C:\Program Files\Microsoft SQL Server\<sql version>\DTS\PipelineComponents\
C:\Program Files\Microsoft SQL Server\<sql version>\DTS\Connections\

I think that reading the following article should help: (it is for another third party components but it will give you some insights)

• No components in SSIS toolbox

If not, how do I install the proper drivers?

You can download Attunity drivers from the link below:

• Microsoft Connectors v5.0 for Oracle and Teradata

To choose the appropriate Attunity drivers, you can refer tho the following link:

• Microsoft Connectors for Oracle and Teradata by Attunity for Integration Services (SSIS)