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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.