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

sbxr — Mon, 23 Jul 2018 10:20:29 GMT

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?

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

Anonymous — Mon, 23 Jul 2018 11:15:38 GMT

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

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

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

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