https://community.qlik.com/t5/Talend-Studio/Disable-foreign-keys-constraint-before-executing-batch/m-p/2198168#M1609 Hello,<BR />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.<BR />Basically I would like in my Talend job to:<BR />- call a custom sql query on my database<BR />- import my CSV file in the table<BR />- call a custom sql query to reenable the foreign keys on my database<BR />Is there a tComponent that is best for this ?<BR />Thanks<BR />Gilles Sat, 16 Nov 2024 14:24:46 GMT _AnonymousUser 2024-11-16T14:24:46Z https://community.qlik.com/t5/Talend-Studio/Disable-foreign-keys-constraint-before-executing-batch/m-p/2198168#M1609 Hello,<BR />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.<BR />Basically I would like in my Talend job to:<BR />- call a custom sql query on my database<BR />- import my CSV file in the table<BR />- call a custom sql query to reenable the foreign keys on my database<BR />Is there a tComponent that is best for this ?<BR />Thanks<BR />Gilles Sat, 16 Nov 2024 14:24:46 GMT https://community.qlik.com/t5/Talend-Studio/Disable-foreign-keys-constraint-before-executing-batch/m-p/2198168#M1609 _AnonymousUser 2024-11-16T14:24:46Z https://community.qlik.com/t5/Talend-Studio/Disable-foreign-keys-constraint-before-executing-batch/m-p/2198169#M1610 Hello, <BR />You can use tMySQLRow<BR />Regards, Mon, 31 Mar 2008 18:21:57 GMT https://community.qlik.com/t5/Talend-Studio/Disable-foreign-keys-constraint-before-executing-batch/m-p/2198169#M1610 Anonymous 2008-03-31T18:21:57Z