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

Question

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.

Answer 1

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.

Answer 2

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.