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.
Alteryx can connect to databases using different methods. This guide will focus on setting up an OleDB connection to SQL server, however, the same general process can be followed to connect to any database via OleDB.
Product - Alteryx Designer or Server.
OleDB driver for the database (if it is not currently present on your machine, you must download and install it prior to using this guide. The download links to many of the drivers can be foundhere. If you are unsure of where to get the driver or which driver to use please contact your IT or database admin for this information).
Open Alteryx Designer and drag and drop the “Input Data” tool onto the canvas
Click the drop-down to "Connect to a File or Database." Then select "Database Connection" > "New OleDB Connection…" The "Data Link Properties" window should appear.
2019.2 and later
Click OleDB under Microsoft SQL Server. The "Data Link Properties" window should appear.
Select the driver for the database you wish to connect to and click “Next.” In this guide we will be selecting the “SQL Server Native Client 11.0” driver. This is the recommended driver for Microsoft SQL Server.
On the next screen, enter the server name by either selecting it from the drop-down, or if it does not appear, by typing it in manually
Select the authentication method of the database. If your database uses “Windows Authentication” additional login information is not required. If your database uses user ID/PW authentication please enter the username and password you will be connecting with. If you are unsure of your login information please contact your IT or database admin.
Select the database on the server you wish to connect to by selecting it in the drop-down.
Click the “Test Connection” button to test that you are set up correctly.
Upon successful test you will get the below popup window:
Click the “OK” button
On the “Data Link Properties” window click “OK”
The “Choose Table…” Window should appear.
In the window select the table you wish to connect to.
After successfully connecting to a table, the connection will now be saved in the “Connect a File or Database” drop-down, both under the initial drop-down and also under “Database Connection”