Set up a workflow to run automatically when one process is completed.

Question

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!!

danilang · Answer

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

Atmaja · Answer

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?

danilang · Answer

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