Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

[resolved] tMysqlBulkExec component

Highlighted
One Star

[resolved] tMysqlBulkExec component

Hi All,
I have to load text files from Amazon server to Aurora DB. For this we are using tMysqlBulkExec component, which directly fetches files form server and load in DB as we don't have to perform any transformation.
But I am not able to find any option to exclude header row while loading data from .txt file to DB in this component.
Please help. Smiley Happy

Accepted Solutions
Highlighted
Seventeen Stars

Re: [resolved] tMysqlBulkExec component

I have taken a look into the description of the import command and there is a useful option to skip lines at the start.
I will create an update to this component but meanwhile you can build the import command for yourself and  run it in a tMysqlRow component.
Here the description:
http://dev.mysql.com/doc/refman/5.7/en/load-data.html

View solution in original post


All Replies
Highlighted
Seventeen Stars

Re: [resolved] tMysqlBulkExec component

The problem here is not Talend, the problem here is the bulk loaded from MySQL. This bulk loaded simple does not expect a header row.
Talend has no chance to avoid that problem. Simply take care your file has no header row or remove it!
Highlighted
One Star

Re: [resolved] tMysqlBulkExec component

Thanks jlolling, but these files will be provided to us and we have to load them instantly in DB. So we can't process them, there can be a way in component to avoid header rows.
Highlighted
Seventeen Stars

Re: [resolved] tMysqlBulkExec component

I have taken a look into the description of the import command and there is a useful option to skip lines at the start.
I will create an update to this component but meanwhile you can build the import command for yourself and  run it in a tMysqlRow component.
Here the description:
http://dev.mysql.com/doc/refman/5.7/en/load-data.html

View solution in original post

Highlighted
One Star

Re: [resolved] tMysqlBulkExec component

Thanks! and please let me know when you will be done with component update.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog