Excel having 3 sheets , pull other two sheets in first sheet and load into mysql db

[sbxr]

Hi All,

I am having Excel file with  3 sheets in it with same schema i want to  pull other two sheets data  in first sheet and load into mysql db ... the data load is 1 gb. also please suggest me which components to use to load into mysql...? can we use bulkload?

[Anonymous]

Hi,

     Bulkload  will be a good idea in this case to move data to database. To read data from multiple sheets of same schema, you need to add the sheet names of all 3 tabs in the input component.

Also increase the value of custom flush buffer size in Advanced settings of in tDBOutputBulkExec so that less number of commits will happen at DB level.

Please mark as acceptable solution if the reply has solved your query. It will enrich our Talend community.

Warm Regards,

Nikhil Thampi