Faster way to data load from oracle to SQL server without Attunity 5.0

Lodha, Nimisha M 0 Reputation points
2024-06-28T15:51:19.4233333+00:00

Hello,

I am in the process of upgrading SSIS packages from 2015 to 2022 using VS 2022. we are having performance issues with data load from oracle to SQL and vice versa. we were using Attunity 4.0 with previous version of VS 2015 and that was a big help when it comes to large amount of data load.

Unfortunately, that is no longer supporting VS 2022 and SQL Server 2019. Currently I am using OLEDB source to do data transfer but that is extremely slow.

Can anyone please suggest any other tools or extensions which can boost performance in VS when it comes to data transfer from oracle to SQL.

Thank you all in advance.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
66 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,726 Reputation points
    2024-06-28T17:21:47.2+00:00

    Hi @Lodha, Nimisha M,

    You can use Microsoft Connector for Oracle. It is a replacement for Attunity.

    Check it out here: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connector?view=sql-server-ver16

    Behind the scenes, Microsoft is using Progress DataDirect Oracle Wire Protocol ODBC driver. One of the best on the market.

    0 comments No comments

  2. ZoeHui-MSFT 35,381 Reputation points
    2024-07-01T02:11:55.0066667+00:00

    Hi @Lodha, Nimisha M

    Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.

    Check Oracle Connection Manager

    Regards,

    Zoe Hui


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

    0 comments No comments