Here are the steps to set up a database connection to run a stored procedure from Alteryx:
- Open Alteryx Designer and click on the Connections tab.
- Click on the New Connection button and select the appropriate database type from the list.
- Enter the required credentials and click on the Test Connection button to verify the connection.
- Once the connection is established, drag and drop the Input Data tool onto the canvas.
- In the Configuration window, select the database connection you just created.
- Click on the Stored Procedures tab and select the stored procedure you want to run.
- If the stored procedure has any input parameters, you can specify them in the Input Parameters section.
- Click on the Preview button to verify the output of the stored procedure.
- 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.