Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

How To Extract Data From Multiple Tables at a time.

Highlighted
One Star

How To Extract Data From Multiple Tables at a time.

Hi,
I have 100 Tables.i need to extract the data from 100 different  tables at once.
and these tables has no join condition,need to extract all columns from tables.
1.Need to Extract from 100 tables from one instance.
2.Need to Load the data into another instance for same tables.
Example:we have 100 tables in Instance A,need to exract these tables data at once and insert into Instance B.
Can Some one  Please Suggest the approach.
Thank You.
Highlighted
Moderator

Re: How To Extract Data From Multiple Tables at a time.

 Do your 100 tables have same stucture? If not, with Talend Open Studio, you have to create many subjobs for mapping table by table in one job, because each table has different table structure, you have to create different subjob with corresponding schema, for example:
t<DB>Input_1--main--tMySqlOutput_1  (migrate table1)
   |
onsubjobok
   |
t<DB>Input_2--main--tMySqlOutput_2 (migrate table2)
   |
onsubjobok
   |
...other subjobs for other tables...
In Talend subscription version, you only need to create one subjob for all tables due to the 'dynamic schema' feature.
Here is a KB document about:TalendHelpCenter:How to process changing data structure?
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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog