Free Trial

Alteryx Designer Desktop Discussions

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

Alteryx End of Workflow Stored Procedure Runner

mobengyeboah
5 - Atom

Hello Guys,

 

First and foremost I'm a newbie to Alteryx as an ETL tool but I have used several other ETL tools like SSIS/Azure Data Factory, AWS Glue, etc. I am building a workflow for which I am extracting data from several sources i.e. Oracle, Teradata, and Snowflake... unironing and transforming them and finally writing them to an MSSQL Server table.

 

All of the above is no problem, however once the data is written to the table, I will like to execute certain Stored Procedures which perform certain actions on the newly written table data in succession for which I'm having a hard time finding how to do this in Alteryx, for which I am able to do in other ETL tools no problem. I'm hoping someone can give me some pointers and or idea of how to do this in Alteryx.

 

The attached sample workflow should give you some idea what I'm trying to do, the point where I need help is the part I've included in the container labelled "Help Needed Here".

 

Thanks in advance.

 

~ Max

1 REPLY 1
hroderick-thr
11 - Bolide

When you write out to a table you have a postsql option you might use. Failing that you can run a bat file after successful workflow completion using events.

hroderickthr_0-1659557065748.png

 

hroderickthr_1-1659557128383.png

 

Labels
Top Solution Authors