Trigger to execute cloud ETL job

[Cloud release: 2025.02.19]
[On-prem release: n/a]
[On-prem build: n/a] 

Note: This feature is only available to customers where TARGIT hosts both the InMemory database and the ETL process!

For a TARGIT solution installed as a Cloud tenant, TARGIT Designer users and TARGIT Anywhere users can execute on-demand updates of their Data Warehouse data.

A TARGIT Cloud solution may be configured with several TARGIT InMemory ETL jobs. When run, these ETL job will transfer fresh data from their respective business systems and into the Data Warehouse. Once the Data Warehouse has been updated, the data will be available to TARGIT end-users.

Rights

The abilities to manage and to execute ETL jobs are handled as permissions in the Rights section of the TARGIT Management client.

The 'Manage cloud ETL jobs' permission is a Designer user permission, while the 'Trigger cloud ETL jobs' is a Consumer user permission.

Manage cloud ETL jobs

As a Designer user, if you have this permission, you will see the 'ETL jobs' button in the Tools menu in the TARGIT Designer client - and you will be able to manage the ETL jobs that are associated with your TARGIT Cloud solution.

• Play. Clicking the 'Play' button will execute the ETL job and your Data Warehouse data will update. The time required for the updated data to be available in the TARGIT client depends on the complexity of the ETL job and the amount of data to be transferred.
• Save. Clicking the 'Save' button for an individual job will save an ETL job file in your Shared folder structure. These saved ETL job files are necessary only if you want to create triggers that can execute the ETL jobs.
• Multi-save. If you multi-select two or more ETL jobs in the list, you can use the big Multi-Save button to save these jobs into a single ETL job file. When this file is used for a trigger, the trigger will then execute multiple ETL jobs.

The saved ETL job files may be stored in any subfolder in your Shared folder structure. In this way, the ETL job files and the triggers created from these, are governed by the document access rules that you set in your TARGIT Management Roles.

Note: To see the saved ETL job files, you may need to enable the 'Other' documents filter.

Setting up a trigger to execute an ETL job

Once you have saved an ETL job as a file, you can create a trigger from this file. The trigger will then execute the associated ETL job.

The action required for the trigger, is an 'Open document' action.

When an end-user clicks a text box, a menu or any other type of object that has been configured with an Execute ETL job trigger, the end-user will get a brief notification that the job has started.