Stored procedure in Alteryx

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

Developer

Database Connection

Accepted answers

danilang

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

All comments

afv2688

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

exec <procedure>

cheers

danilang

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.

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.

MicrosoftTeams-image (3).png

Thank all in advance for helping

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703