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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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,