Extract Data from Oracle Db

Six Stars

Extract Data from Oracle Db

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

Fifteen Stars TRF
Fifteen Stars

Re: Extract Data from Oracle Db

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.


TRF

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch