Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

General availability of Microsoft Connector for Oracle

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
May 25, 2020

Microsoft Connector for Oracle is now generally available. 

 

Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages designed with Attunity Oracle Connector can run with Microsoft Connector for Oracle without any changes. The following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:

  • Since SQL Server 2019 CU1
  • SQL Server Data Tools (SSDT)  15.9.3 or later for Visual Studio 2017
  • SQL Server Data Tools (SSDT) for Visual Studio 2019

 

To install the connector for Oracle database, download and run the installer from the latest version of Microsoft connector for Oracle. Then follow the directions in the installation wizard. 

 

Design new SSIS packages

Open SSDT 15.9.3 or later, Oracle components can be found in SSIS Toolbox, under Common Category.

 

And in Connection Managers, Oracle connection manager is displayed with type “ORACLE”.

Microsoft Connector for Oracle provides similar user experience with Attunity Oracle Connector. User can design new packages based on previous experience.

 

Execute packages targeting SQL Server 2019

Existing SSIS packages which have been designed with Attunity Oracle Connector will be automatically upgraded to use Microsoft Connector for Oracle. The icons will be changed as well.

 

Execute package targeting Pre-SQL Server 2019

If the project is targeting Pre-SQL Server 2019, corresponding Attunity Oracle Connector and Oracle client are required to be installed on the SSDT machine for package execution.

 

Attunity Oracle Connector download links:

 

Please refer to this page for more detail usage.

Updated May 25, 2020
Version 1.0
  • ykhabins's avatar
    ykhabins
    Brass Contributor
    Dec 04, 2020

    Hello,

     

    Is it possible to execute Oracle package in SSIS Execute SQL Task via Microsoft Oracle Connector?

  • ykhabins's avatar
    ykhabins
    Brass Contributor
    Jan 25, 2021

    Chunhua,

     

    The existing Oracle Destination functionality is just for INSERT operations.

    What is missing is that SSIS Execute SQL Task is not supported for Oracle Connector connections. This will allow to execute direct UPDATE, or call Oracle modules or procedures.

     

    As of today, such attempt to execute SSIS Execute SQL Task gives an error, saying that you are not licensed for that, and contact DataDirect company  to buy a license.

     

     

    Please add such functionality.

  • frugecn's avatar
    frugecn
    Copper Contributor
    Sep 28, 2021

    glennpok, yes you have to install them on the server itself.  That is where it is running from when you deploy to the catalog.

  • Chunhua's avatar
    Chunhua
    Icon for Microsoft rankMicrosoft
    Oct 28, 2021

    Gerald_AI Thank you for sharing us the feedbacks here.

    LDAP support is in backlog, but not prioritized yet.

    For the issues, would you create a support ticket for engineer to look into?  

     

  • MakingEasyLookHard's avatar
    MakingEasyLookHard
    Brass Contributor
    Jul 13, 2023

    We really need some sort of timeline on when LDAP will work with these connectors. We have an extensive ETL solution utilizing the Attunity drivers in 2016 and this is preventing us from upgrading. We scrapped our 2019 upgrade thinking surely this functionality would be restored by 2022 but now we find it still isnt there.  It's going to take a huge effort for us to circumvent this connection type and our vendor only supports LDAP connectivity so we would like to know the timeline to know if it is worth waiting or figuring out an alternative. This is so frustrating.

  • EdPearson's avatar
    EdPearson
    Copper Contributor
    May 25, 2020

    For Synapse you'd be able to use Polybase for Oracle connection. 

  • EMorgoch's avatar
    EMorgoch
    Copper Contributor
    May 26, 2020

    Does this setup only work with SSIS on SQL Server 2019, or can we use the updated SSDT with the Attunity connectors if SSIS is running on a previous version (in my case SSIS on SQL Server 2012). I haven't been able to update my SSDT since v15.8.0 because of the Attunity connectors.

  • Chunhua's avatar
    Chunhua
    Icon for Microsoft rankMicrosoft
    May 26, 2020

    EMorgoch If the project is targeting Pre-SQL Server 2019, works for Attunity connectors as before