5

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.

ds_practicioner
  • 733
  • 8
  • 20
  • What kind of license do you have for SQL 2017? The connectors will only work if you have Enterprise or Developer. – digital.aaron Feb 14 '19 at 22:18
  • Installed architecture x64 or x86 or Both?? – Sebin Thomas Feb 15 '19 at 06:39
  • I tried both Developer and Enterprise editions, also tried x64 only and both installs. Of the 8 possible combinations of Win10/Win2016, SQL Ent/Dev and x64/Both I have tried 7 of them with exactly the same result. I have also uninstalled/reinstalled VS 2017/Attunity to see if the order of install might have something to do with it, but no luck. Altogether I have probably tried 10-12 different combinations with the same result. – ds_practicioner Feb 16 '19 at 02:31

1 Answers1

6

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.

engil
  • 349
  • 2
  • 13