Why is there no tool for executing sql scripts? I have had several issues where I had a script I needed to be ran which contains 20+ individual SQL statements. Why can Alteryx not just execute the script in the database?
The solution I am currently using is to create an automation script with Toad Datapoint to execute the script then execute the toad automation script in alteryx like a batch file. It just makes no sense that alteryx can't execute an sql. Seems like it should be really simple.
Are you from SSIS background?
Alteryx is not a pure ETL platform. You can compare Alteryx workflow as one data flow task in SSIS. You cannot have Execute SQL inside a data flow task.
Unfortunately this is a use case that Alteryx does not want to implement.
https://community.alteryx.com/t5/Alteryx-Product-Ideas/Have-an-SQL-Tool/idi-p/5392
