ssisattunity

Attunity connectors are not showing in SSIS for VS 2017, SQL Server 2017


I have seen this post for VS 2015 but not VS 2017.

I have tested Visual Studio 2017 SSDT - both Enterprise and Professional, and SQL Server 2017. I followed the post here and tried installing the Attunity Connectors for Oracle both V5 (found here) like they recommended (didn't work) and V4 (here) as was recommended here (still didn't work). I am still not seeing it in SSIS. Is there yet another recommended way to get the connector to show up in SSIS or is there a process to add them manually to VS 2017? TIA

Note as a further edit, tried this on Windows 2016 server, Windows 10, SQL Server Enterprise and Developer Editions.


Solution

  • You didn't mention the version of SSDT you have installed, but you are likely running into a known issue with the most recent versions, specifically 15.8.1 and higher do not appear to support the Attunity drivers.

    Ref: https://social.msdn.microsoft.com/Forums/en-US/d0d45473-eea6-4d19-a708-25ceb79bf920/ssdt-for-visual-studio-2017-1590-and-oracle-connector-requirements?forum=ssdt

    The short answer appears to be that you will need to install 15.8.0 or prior SSDT versions in order to take advantage of the Attunity connectors.