Stored procedure in Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Database Connection
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
On the input tool, insert in 'Pre SQL Statement' your proc:
exec <procedure>
cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am getting Store Procesure are not supported for this type of connection.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yep, needs to be OLEDb not ODBC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
 
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
