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.
Solved! Go to Solution.
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.
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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks