Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How do I set up a workflow to run automatically when the back end data is updated.

Machingwa
7 - Meteor

How do I set up a workflow to run automatically when the back end data is updated.

5 REPLIES 5
gnans19
11 - Bolide

Could you please clarify what back end data is? Is it a file or database?

 

For database, I would write an insert/update trigger to invoke alteryx workflow through command line.

Machingwa
7 - Meteor

This is for a database.I will try your suggestion and get back to you..

Machingwa
7 - Meteor

Do you have an example of how to write an insert/update trigger to invoke alteryx workflow through command line..I am new to alteryx

gnans19
11 - Bolide

Assuming your database is SQL Server

 

CREATE TRIGGER Alteryx_Trigger ON TableName FOR UPDATE AS

DECLARE @AlteryxCmd nvarchar(200)

SELECT @AlteryxCmd= '"C:\Program files\Alteryx\bin\AlteryxEngineCmd.exe AlteryxApp.yxwz" '

EXEC master ..xp_cmdshell @command = @AlteryxCmd

 GO

 

For more details on this refer:

https://community.alteryx.com/t5/Advanced-Analytics/Alteryx-Workflow-execution-from-Command-Prompt-N...

Chaitanya001
5 - Atom

My data is an SharePoint based excel file, Published on Tableau Server. Is it possible to automatically run the workflow in my use case as well?

Labels