Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Disable foreign keys constraint before executing batch

Hello,
I would like to know how to execute a custom sql query in my Talend job on my MySQL database before importing batch data with Talend.
Basically I would like in my Talend job to:
- call a custom sql query on my database
- import my CSV file in the table
- call a custom sql query to reenable the foreign keys on my database
Is there a tComponent that is best for this ?
Thanks
Gilles
Labels (3)
1 Reply
Anonymous
Not applicable

Hello,
You can use tMySQLRow
Regards,