Oracle Connector For SSIS

2023-11-22T15:43:58.6466667+00:00

We are migrating our SQL Server to 2021. We currently use the Antiunity driver which can no longer be used with latest version of SQL and SSIS.

When we tried to use the "Microsoft Connector for Oracle" the source spooling is very slow and not on par to the Antiunity driver's performance.

Kindly advise if there any known issues related to the performance using "Microsoft Connector for Oracle" with Oracle 19C

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
515 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,726 Reputation points
    2023-11-22T16:26:15.3533333+00:00

    Hi @Rajagopalan, Ganesh : Functions Technology,

    We are migrating our SQL Server to 2021

    You are probably using SQL Server 2022.

    "Microsoft Connector for Oracle" is very performant.

    Behind the scenes Microsoft is using one of the best ODBC drivers on the planet that Microsoft licensed from a reputable vendor. You can see it in the Control Panel => Administrative Tools => ODBC Data Sources

    0 comments No comments

  2. ZoeHui-MSFT 35,381 Reputation points
    2023-11-23T08:21:27.1166667+00:00

    Hi @Rajagopalan, Ganesh : Functions Technology,

    You may also raise the issue to SSIS project team which will help to check if there is performance issue.

    SQL Server Integration Services Projects 2022

    And like Yitzhak said, you may use ODBC for a try.

    Regards,

    Zoe Hui


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

    0 comments No comments