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

0 votes
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?
Nov 4, 2020 in Talend by umesh
• 150 points
425 views

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!!!

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Talend

0 votes
1 answer
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,500 points
2,670 views
0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,500 points
4,754 views
+1 vote
1 answer
0 votes
2 answers

Read Data from Rest API's through Talend and store it in Oracle

Hi, @Abhishek, Regarding your query, I would suggest ...READ MORE

answered Oct 15, 2020 in Talend by Gitika
• 65,930 points
1,211 views
0 votes
1 answer

how to add data to existing file and how to use LIST properly ??

Hi, @Aminegac yes, in the output file there's ...READ MORE

answered Dec 4, 2020 in Talend by Gitika
• 65,930 points
227 views
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,500 points
766 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,500 points
1,848 views
+1 vote
1 answer