topic Re: Extract Data from Oracle Db in Talend Studio

Extract Data from Oracle Db

Anonymous — Tue, 10 Oct 2017 07:36:42 GMT

Hi Team

My DB is located at Client Location

I have designed a Talend Job in my local to extract data from sql db to flatfile .lts a direct mapping.

when i started my execution my data transfer rate is 40 rows per sec.

i have data of 10 million records in source,

can you please suggest me how can i increase my data transfer rate.

Thanks

Deepthi

Re: Extract Data from Oracle Db

TRF — Tue, 10 Oct 2017 08:01:29 GMT

Hi,

If you have good transfer rate locally, it is probably due to a limited network bandwidth.

The simpler is to export your job as an autonomous job, then transfer it to your client platform and execute it locally on this platform.

You will then have to compress the result (maybe included in the job) and get the archive using a ftp transfer when finished (or push the result to your ftp server automatically from the job).

Hope this helps.