topic Re: Import the data with different schema from ExcelFile to mysql table in Talend Studio

Import the data with different schema from ExcelFile to mysql table

hami1 — Wed, 07 Sep 2016 11:09:57 GMT

Hi Guys,
I came across the same kind of requirement where we need to import the data from ExcelFile to mysql table. But here the Schema is different in both the sheet's. How can I capture these Dynamically changed schema's in the Talend and load the right amount of data in the table.

Thanks,
Hameed S.

Re: Import the data with different schema from ExcelFile to mysql table

Anonymous — Thu, 08 Sep 2016 05:16:07 GMT

Hello Hameed
The dynamic schema feature is only available in Talend Enterprise Subscription product, for more information, please read How to process changing data structure?
Assuming you have multiple excel files and each file has different schema, a simple job looks like:
tFileList--iterate--tFileInputExcel--main--tMysqlOutput
on tFileInputExcel, just need to define one column with dynamic data type.
on tMysqlOutput, set the table name as current file name, each file will be loaded to corresponding table in database.

Regards
Shong

Re: Import the data with different schema from ExcelFile to mysql table

hami1 — Thu, 08 Sep 2016 05:54:08 GMT

Thanks Shong for your quick reply,
Here am using Talend Open Studio 5.5.0 Version, Is there any way that I can handle this scenario in Talend Open Studio.

Re: Import the data with different schema from ExcelFile to mysql table

Anonymous — Thu, 08 Sep 2016 09:29:45 GMT

Hello
Unable to achieve it in a single subjob with community edition, you have to create several subjobs to map each schema.
Regards
Shong