topic Pre/post hooks in Qlik Talend Data Integration pipelines in Data Movement & Streaming https://community.qlik.com/t5/Data-Movement-Streaming/Pre-post-hooks-in-Qlik-Talend-Data-Integration-pipelines/m-p/2556534#M3710 <P>Hello Qlik Support Team,</P><P>I have a question regarding <STRONG>Qlik Talend Data Integration Data Mart / transformation pipelines</STRONG>.</P><P>We have a requirement to execute custom SQL statements before and/or after a Transformation / Data Mart task. One of the use cases is <STRONG>index management</STRONG> — for example, creating an index on a target table after the Transformation / Data Mart step has created the table or populated the table.</P><P>For example, we would like to achieve a workflow similar to:</P><OL><LI><P>Execute a <STRONG>pre-action SQL statement</STRONG> (if required)</P></LI><LI><P>Execute the Qlik Transformation task</P></LI><LI><P>Execute a <STRONG>post-action SQL statement</STRONG>, such as:</P><UL><LI><P>Create or rebuild indexes</P></LI><LI><P>Update statistics</P></LI><LI><P>Execute a stored procedure</P></LI><LI><P>Perform other target-database maintenance</P></LI></UL></LI></OL><P>Is there a supported way in <STRONG>Qlik Talend Data Integration / Qlik Cloud Data Integration</STRONG> to implement such <STRONG>pre- and post-processing SQL hooks</STRONG> for a Data Mart or transformation task?</P><P>If there is no direct pre/post hook functionality, what is the <STRONG>recommended Qlik-supported approach</STRONG> for implementing this type of orchestration?</P><P>For comparison, I understand that <STRONG>Qlik Compose</STRONG> provides pre- and post-processing functionality that can be used to execute custom SQL around generated ETL/ELT processes. We are looking for an equivalent capability in Qlik Talend Data Integration.</P><P>In particular, our use case is to ensure that indexes can be automatically created or maintained on Transformation target tables after the Transformation task creates or refreshes them.</P><P>Could you please clarify:</P><UL><LI><P>Is there currently a native pre/post SQL hook mechanism in Qlik Talend Data Integration?</P></LI><LI><P>what is the recommended approach for executing SQL before or after a Transformation task?</P></LI><LI><P>Is there a roadmap item for functionality equivalent to the pre/post processing available in Qlik Compose?</P></LI></UL><P>Thank you.</P> Mon, 21 Sep 2026 10:13:53 GMT alex_nerush 2026-09-21T10:13:53Z Pre/post hooks in Qlik Talend Data Integration pipelines https://community.qlik.com/t5/Data-Movement-Streaming/Pre-post-hooks-in-Qlik-Talend-Data-Integration-pipelines/m-p/2556534#M3710 <P>Hello Qlik Support Team,</P><P>I have a question regarding <STRONG>Qlik Talend Data Integration Data Mart / transformation pipelines</STRONG>.</P><P>We have a requirement to execute custom SQL statements before and/or after a Transformation / Data Mart task. One of the use cases is <STRONG>index management</STRONG> — for example, creating an index on a target table after the Transformation / Data Mart step has created the table or populated the table.</P><P>For example, we would like to achieve a workflow similar to:</P><OL><LI><P>Execute a <STRONG>pre-action SQL statement</STRONG> (if required)</P></LI><LI><P>Execute the Qlik Transformation task</P></LI><LI><P>Execute a <STRONG>post-action SQL statement</STRONG>, such as:</P><UL><LI><P>Create or rebuild indexes</P></LI><LI><P>Update statistics</P></LI><LI><P>Execute a stored procedure</P></LI><LI><P>Perform other target-database maintenance</P></LI></UL></LI></OL><P>Is there a supported way in <STRONG>Qlik Talend Data Integration / Qlik Cloud Data Integration</STRONG> to implement such <STRONG>pre- and post-processing SQL hooks</STRONG> for a Data Mart or transformation task?</P><P>If there is no direct pre/post hook functionality, what is the <STRONG>recommended Qlik-supported approach</STRONG> for implementing this type of orchestration?</P><P>For comparison, I understand that <STRONG>Qlik Compose</STRONG> provides pre- and post-processing functionality that can be used to execute custom SQL around generated ETL/ELT processes. We are looking for an equivalent capability in Qlik Talend Data Integration.</P><P>In particular, our use case is to ensure that indexes can be automatically created or maintained on Transformation target tables after the Transformation task creates or refreshes them.</P><P>Could you please clarify:</P><UL><LI><P>Is there currently a native pre/post SQL hook mechanism in Qlik Talend Data Integration?</P></LI><LI><P>what is the recommended approach for executing SQL before or after a Transformation task?</P></LI><LI><P>Is there a roadmap item for functionality equivalent to the pre/post processing available in Qlik Compose?</P></LI></UL><P>Thank you.</P> Mon, 21 Sep 2026 10:13:53 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Pre-post-hooks-in-Qlik-Talend-Data-Integration-pipelines/m-p/2556534#M3710 alex_nerush 2026-09-21T10:13:53Z