This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Confirm that the data source name (DSN) specified in the workflow is pointing to an existing DSN in your machine’s ODBC Data Source Administrator:
***You must have the driver installed on the machine prior to using this guide. The download links to many of the drivers can be found here.
On your local machine, search for ODBC Data Sources (64 bit)
The DSN referenced in the input data tool within the workflow must be listed under either User DSN or System DSN tabs.
The workflow is not able to successfully run because the input data tool cannot reach the database in the following scenarios:
The workflow creator sends a workflow with a database connection to a colleague who does not have the same DSN on their computer.
The workflow gets sent to the alteryx server to run on a scheduled frequency where the DSN does not exist on the server machine.
You must have the driver installed on the machine prior to using this guide. The download links to many of the drivers can be found here.
Once confirmed that the appropriate driver is installed, select to add from either the user DSN or System DSN tab. Generally, the User DSN is what most users will have access to and what is commonly used. You can learn more about the difference between User and System DSNs here.