Data export

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
Thirteen Stars

Re: Data export

in Open source no other option.

Manohar B

All Replies
Thirteen 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
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

Thirteen Stars

Re: Data export

in Open source no other option.

Manohar B
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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.