Alteryx Not Finding Stored Procedures

I am trying to access 2 stored procedures that our online host has provided me access to. However, in the Input Data tool is not reading them. I have another program I am migrating from and moving to Alteryx. This other program is reading and executing them perfectly fine.

exec DBO.sps_Custom_RR_RptGenLedger

exec DBO.sps_Custom_RR_ProdAnalysis

If I add the above to the SQL Editor the Error says Unable to find Stored Procedure.

PLease advise. This is slowing my migration away from a mu

Screenshot 2020-10-21 125721.jpg

Datasets

Database Connection

Accepted answers

All comments

BrandonB

You most likely need to adjust the Default Database when you are setting up the database connection. If you pick the database that has the stored procedure you should then see it available.

michael_franz

This should be the fully qualified path and not getting columns

Screenshot 2020-10-22 084834.jpg

BrandonB

Please see the information in this link: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/No-Columns-Returned-for-Stored-Procedure/ta-p/630089

Do you happen to know what the Stored Procedure is doing? Sometimes I have found that running the stored procedure as PreSQL and executing it into a temp table and then calling the results of that temp table in the main Input Data tool query can be more flexible in accommodating stored procedures.

CharudattaChousalkar

Change the odbc connection to OleDB connection, then it will work.

In manage In-DB Connection,

Select Driver: SQL Server OLE DB

In Connection String>Data Link Properties>Provider=Microsoft OLE DB Provider for SQL Server.

And finally provide server name and authentication in Connection tab.

michael_franz

Thanks for the info. Progress has been made. I can see the a subset of the system stored procedures, but not the 2 that I am looking for. When I use SQL Mgt Studio, I see the other 2 I am looking for, but can not see them in Alteryx.

Screenshot 2022-03-16 105702.png

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317