Attunity driver for SQL2016, SSDT 15.1.6, Windows 2016

Mudit Gupta 61 Reputation points
2020-08-21T12:46:15.9+00:00

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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,857 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,571 questions
No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,686 Reputation points
    2020-08-24T06:09:08.94+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. Olaf Helper 25,901 Reputation points
    2020-08-24T11:07:35.917+00:00

    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.

    No comments