Microsoft Connector for Oracle - missing in the list of SSIS Connection Manager after installation

PhilZ 1 Reputation point
2022-08-25T22:57:41.427+00:00

Hi,

Trying to figure out how to see and use Microsoft Connector for Oracle for SSIS package (dtsx).

currently using

VS 2019 Enterprise IDE along with SSDT.

I have download the latest Microsoft Connector for Oracle from details.aspx

Did install and reinstall many times, but did not see anything.

![235016-image.png]3

235066-image.png

What am I missing?

thanks,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,655 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,941 Reputation points
    2022-08-26T00:15:48.997+00:00

    Hi @PhilZ ,

    I recently answered a similar question.
    Check it out here: Microsoft SSIS Connector to Oracle - doesn't work with Visual Studio 2019

    UPDATE
    One of the huge benefits of the Microsoft SSIS Connector to Oracle, it doesn't require Oracle Client installation at all. It comes with its own Oracle ODBC driver. One of the best from the perspective of performance.
    Please see below.

    235362-odbc-microsoft-oracle-driver.png

    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 32,506 Reputation points
    2022-08-26T01:22:54.303+00:00

    Hi @PhilZ

    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
    Microsoft SQL Server Data Tools (SSDT) for Visual Studio 2019

    The following Oracle database versions of data source are supported:

    Oracle 10.x
    Oracle 11.x
    Oracle 12c
    Oracle 18c (without Windows Authentication support)
    Oracle 19c (without Windows Authentication support)
    The Oracle database is supported on all operating systems and platforms.

    After you install the Connector, you must restart the SQL Server Integration Service to be sure that the Oracle source and destination can work correctly.

    In addition, the oracle connection could be use named as Oracle source and destination.
    235026-untitled.png

    Reference: oracle-connector

    Regards,

    Zoe Hui


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

    0 comments No comments

  3. PhilZ 1 Reputation point
    2022-08-26T16:42:06.673+00:00

    Thanks @Yitzhak Khabinsky and @ZoeHui-MSFT for the help.

    yes it worked this time.

    Some couple of questions...

    1. I have tried to connect using TNS Name and connection failed.

    235280-image.png

    using other driver, connection succeeded..

    235302-image.png

    And I am seeing different Oracle in SSIS toolbox... Is this correct or expected?

    235289-image.png

    1. I have seen during my google search about EZ connect ... do you have a sample how to add it on existing tnsnames.ora file?

    Update - I think I got it.... Please ignore this part.

    1. Do you have any suggestions on Oracle driver/provider which is not obsolete and best in terms of performance?

    What is your opinion about the ODP.NET vs Microsoft Connector for Oracle.?

    Thanks.