Pre/post hooks in Qlik Talend Data Integration pipelines

[alex_nerush]

Hello Qlik Support Team,

I have a question regarding Qlik Talend Data Integration Data Mart / transformation pipelines.

We have a requirement to execute custom SQL statements before and/or after a Transformation / Data Mart task. One of the use cases is index management — for example, creating an index on a target table after the Transformation / Data Mart step has created the table or populated the table.

For example, we would like to achieve a workflow similar to:

1. Execute a pre-action SQL statement (if required)

2. Execute the Qlik Transformation task

3. Execute a post-action SQL statement, such as:

   • Create or rebuild indexes

   • Update statistics

   • Execute a stored procedure

   • Perform other target-database maintenance

Is there a supported way in Qlik Talend Data Integration / Qlik Cloud Data Integration to implement such pre- and post-processing SQL hooks for a Data Mart or transformation task?

If there is no direct pre/post hook functionality, what is the recommended Qlik-supported approach for implementing this type of orchestration?

For comparison, I understand that Qlik Compose 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.

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.

Could you please clarify:

• Is there currently a native pre/post SQL hook mechanism in Qlik Talend Data Integration?

• what is the recommended approach for executing SQL before or after a Transformation task?

• Is there a roadmap item for functionality equivalent to the pre/post processing available in Qlik Compose?

Thank you.