I have a server A and server B. When the data is received it will process data at server A and store the data in database at Server B for Alteryx to process further.
I want my Alteryx workflow to kick off automatically at server B as soon as my data processing is completed at server A and successfully written to server B
can anybody help on how this can be achieved? Thank you!!
Hi @Atmaja
Take a look at this recent topic, you will probably find the answer here:
Automation dependency on another workflow run - Alteryx Community
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
Thank you for your quick response. Is there any way it can be achieved as Event based Trigger? Data Processing on Server A should Automatically trigger Alteryx workflow on server B
You can try to have server A launch a bat file to call the workflow. Some documentation was previously referenced here: https://help.alteryx.com/20221/designer/run-workflows-command-line
Hi @Atmaja
You can use the Gallery API to programmatically launch a workflow on a server from an external machine. The details are here. You do have to be careful when calling this. For instance the Alteryx server does not filter requests to execute a job based on whether the job is currently running or not. So if you add the api call to an on-update trigger in SQL and 1000 records get updated, you will queue the workflow 1000 times.
Dan
Hi Dan, Thanks for your input. I'm new to Alteryx and I am not aware of the Gallery API. Does it mean we have to set up a trigger on table to call this API?
Hi @Atmaja
Yes. If you're using SQL, an after update trigger would work well, if you ensure that you only call the API once if inserting multiple rows.
Dan