How to bulk tables map in talend open studio bigdata

[Bharath12]

Hi All,

My Source is SQL server with 1000 tables and my target is maria db with 1000 tables. I need to migrate data from mssql server to maria db. it's like 1-1 mapping.

Is there any advanced options in talend open studio to do bulk map like schema to schema instead of manually map table by table?

Thanks in advance.

[Anonymous]

Hello,

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:

tMSSQLInput_1--main--tDBOutput_1 (migrate table1)

  |

onsubjobok

  |

tOracleInput_2--main--tOracleOutput_2 (migrate table2)

  |

onsubjobok

  |

...other subjobs for other tables...

With talend subscription solution, here is a dynamic schema feature which allows you to design schema with an unknown column structure (unknown name and number of columns).

Here is a KB article about: https://community.talend.com/s/article/How-to-process-changing-data-structure-ExK7j

Let us know if it helps.

Best regards

Sabrina