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

Seven 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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download