Alteryx Work Flow and Conversion

[tjamal1]

Hello,

We have a Stored Procedure in our SQL which get data from some tables and insert into another tables 

My question is ? 

1) Can we execute by simply calling it in Alteryx  ?

[DavidP]

If you connect to your database table using an Input Data tool, you can enter the SQL query that calls your stored procedure in the SQL editor inside the Input Data tool

[tjamal1]

Can we do this with IN-DB Tool? and if so , which tool should i use?

[DavidP]

Use the Dynamic Input In-DB.

[tjamal1]

Can you provide your workflow file ? 

[DavidP · Accepted solution]

You'd have to define the connection and query in the Text Input tool