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