How can I use talend to extract data from Oracle and import the data into a MSSQL database

Question

We currently have around 100 Oracle tables that needs to be extracted daily and imported in a MSSQL Database. I am testing talend and if talend can make that happen, we could start using talend for other needs as well.

each table has different table structure, we have created different subjob with corresponding schema, for example: tOracleInput_1--tmap--tMSSQLOutput_1 (migrate table1) Is there a way to export the data for all tables at the same time in the same job?

Comments

Hi, @Umesh,

I would suggest you go through this: https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/VkhNtZi1Cvzb2zyybc6MEw

---

I do not want to create multiple subjob. Is there a way to export the data for all tables at the same time in the one job?

---

Hi, @There,

Regarding your above query, you need to follow multiple steps So I suggest you go through this: https://help.talend.com/reader/6lpaT_M~MEVrltFQcrPe4g/rsZpqQr8vgNyAVHfPmm7XA

I hope this helps!!!