Stored procedure in Alteryx

[Meena1]

Hi all,

I am very new to Alteryx.

I need to use stored proc as a source to my Alteryx WF.

The stored proc does not have input/output parameter and is on MS SQL db. It just contains a select query

How can we use this as my input? Shall I use the input tool and use SQL editor to write EXEC <stored proc name> or shall I use the stored proc tab to invoke the proc?

Please help.

Regards,

Meena

[afv2688]

On the input tool, insert in 'Pre SQL Statement' your proc:

exec <procedure>

cheers

[danilang · Accepted solution]

Hi @Meena1 

The input tool in Alteryx can directly execute stored procedures.  Once you define the connection to your SQL DB, the following window opens.

On the Stored Procedures tab, select the one you want to execute.  

Once you do, the table or query line in you config becomes 

In your case, you won't have any parameters.  

Note:  In my installation of Alteryx, making changes to the table or query can remove the space between the proc name and the first param value.  If this happens to you, go into the SQL Editor in the first dialog and add it back in manually

Dan 

[rohit782192]

I am getting Store Procesure are not supported for this type of connection.

[StephenCTaylor]

yep, needs to be OLEDb not ODBC

[Hakim64]

 

Hello, I want to reopen this topic. 

I want to connect to an oracle DB executing a stored procédure. 

I used the input tool ( PreSQL) as said above, however my job is falling in error. 
When I try to connect to a table in the BD, it's fine, but the stored proc doesn't run.

Here attached the config in input tool.

 

Thank all in advance for helping