Stitch is an ETL platform that connects to all your databases and SaaS applications and replicates that data to a destination of your choosing. In Qlik Application Automation, the Stitch connector allows you to subscribe your automations to completed data load events in Stitch. The automation can then evaluate the pipeline’s status, if successful, it can start Tasks in Talend or jobs in dbt.
See the below video for a demo to get you started with the Talend Cloud and Stitch connectors in automations:
In order to authenticate with the Stitch connector, you’ll need to generate an API key for your Stitch account. The connector will use this API key for authentication and authorization purposes.
Go to the Stitch platform and navigate to the top right, then click your username.
Choose Manage Account Settings
Scroll down to API access keys and click Generate Key. Use this key to create the connection in automations.
The Stitch connector currently only has a webhook available for the post-load event. More information about the automation webhooks can be found here: Webhooks
Go to the Start block in a new automation and configure its run mode to Webhook, then pick Stitch as a connector.
Now select the post-load event and configure the destination by clicking the empty input field and selecting “do lookup” to fetch all available destinations from you Stitch account. Saving the automation will register the webhook to the event in stitch, it will now run for each post-load event.
You can now add additional blocks to the automation Run Job from the dbt Cloud connector or Execute Task from the Talend Cloud connector and then reloading a Qlik Sense app.