question

MuditGupta-1718 avatar image
0 Votes"
MuditGupta-1718 asked Monalv-msft commented

Attunity driver for SQL2016, SSDT 15.1.6, Windows 2016

Hi
I am trying to install attunity connector for oracle.

I have installed 11g Oracle 32 bit and 64 bit clients on the server. My oracle connection is working.
I have SQL Server 2016 SP2, SSIS version 15.0 , SSDT 15.1.6 on Windows 2016.

I installed Attunity v4.0. But I am not seeing MSORA drivers in SSDT.

Are Attunity drivers compatible with Windows 2016? Am I using correct SSDT version ?

Thanks!

sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

Hi Mudit Gupta,

Please download and install Microsoft Connectors **v5.0** for Oracle and Teradata.

19720-attunity-v50.png
Best Regards,
Mona



If the response is helpful, please click "Accept Answer" and upvote it.



attunity-v50.png (66.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Mudit Gupta,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

MsOra is old and deprecated, don't use it, better use origin Oracle data provider.

SSDT/Visual Studio is a 32 bit application, so you also have to install ODAC in 32 bit.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.