Data export

Highlighted
Four Stars

Data export

Hello:

 

I am new to Talend & catching up to the speed.

Source - Oracle

Target - Postgresql

 

From 150 tables of Oracle database, i want to export  40 tables data  to target\destination database in Postgres. I have Schema & Tables on both the sides of database (Source & Target), so only data transfer.

 

I need help what is needed to do required configuration to ETL all data to Postgres.

Any help is greatly appreciated.

 

Thank you in advance.

Jugal


Accepted Solutions
Forteen Stars

Re: Data export

in Open source no other option.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Forteen Stars

Re: Data export

since you need to create a each job for each table if you are using open source .

if you are using enterprise edition then ,you can use a singale job to load all tables using dynamic schema option.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Data export

That will be big pain for 40 tables. do we have any work around or custom component that i can use?

Thanks again for your help.

Jugal

Forteen Stars

Re: Data export

in Open source no other option.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Moderator

Re: Data export

Hello,

Talend provides user with a free trial version of Data Integration product. You can download it from website https://info.talend.com/trial-talend-data-integration.html?type=productspage freely with dynamic schema feature.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Data export

Thank yo Sabrina for your reply.

 

if it was one time, i can understand. this will be daily task and will not help me.

 

Again, thank you for your help & reply.

Thanks

Jugal

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now