2 of 2 people found this helpful
The following section documents “Rest API” that can be used to trigger the execution of any TSCO Task (including ETLs) from a script.
Here is an example using the curl command in Linux:
curl -X POST -k --user admin:admin12345 https://clm-aus-011747.bmc.com:8280/dh-services/backend/requestTaskExecution -H 'Content-Type: application/xml' -d '<?xml version="1.0" encoding="UTF-8"?><TaskExecutionRequest><taskid>38</taskid><request>RUN</request></TaskExecutionRequest>'
With this single shell command you can launch an ETL from a script.
- User and password have to be a valid admin user. You might want to create one with limited rights just to execute this API call. The call is using basic authentication.
- The URL has to be adjusted to your DATAHUB server URL (e.g. clm-aus-011747.bmc.com:8280)
- The TASKID indicated has to be the id of the ETL task (e.g. 38)
Thank you Mike.