how to speedup data transfer between two databases?

AGurau1639681093 — Fri, 15 Nov 2024 22:53:39 GMT

Hi, I am a newbie to Talend, so I apologies if my questions are too simple.

I am trying to transfer data from Oracle tables into SQL Server tables.

I am attaching this image. Running it locally it takes about 2 minutes for 23k records. We have a table of approximately 3 millions records.

I know it's possible to copy large quantity of data, so maybe I'm not using the right components?

Your input is highly appreciated.

Thanks.

Adriana

Re: how to speedup data transfer between two databases?

ppatel — Tue, 07 Jun 2022 09:19:00 GMT

Hello,

Could you please have a look at it?

https://community.talend.com/s/feed/0D53p00007vCoFFCA0

Best regards

Pooja Patel