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

Six Stars

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

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?

Employee

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

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.

 

image.png

 

 

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