Setup a DB connection to run a stored procedure

[EN6924]

Hi All,

Please provide the steps to setup a DB connection to run a stored procedure. We're looking to run a SQL SP from Alteryx.

[Hammad_Rashid · Accepted solution]

Here are the steps to set up a database connection to run a stored procedure from Alteryx:

1. Open Alteryx Designer and click on the Connections tab.
2. Click on the New Connection button and select the appropriate database type from the list.
3. Enter the required credentials and click on the Test Connection button to verify the connection.
4. Once the connection is established, drag and drop the Input Data tool onto the canvas.
5. In the Configuration window, select the database connection you just created.
6. Click on the Stored Procedures tab and select the stored procedure you want to run.
7. If the stored procedure has any input parameters, you can specify them in the Input Parameters section.
8. Click on the Preview button to verify the output of the stored procedure.
9. If everything looks good, click on the OK button to save the configuration.

That’s it! You should now be able to run the stored procedure from Alteryx.