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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com
This article covers how to connect to various database platforms outside of Alteryx Designer. This will help determine if the issue lies on the Alteryx side or if it's an environment issue on the client-side or database side.
Database Specific Clients
Windows Command Prompt
Procedure A - SQL Server
1. Right-click on Desktop > New text file. 2. Name the file test.udl (ensure to rename the extension as a UDL file). 3. Open the file and enter the SQL Server information in the Universal Data Link window.
Procedure B - Oracle
1. Open the CMD prompt > type sqlplus. 2. Enter the following command:
Procedure C - DB2
1. Go to Start > Type: DB2 Command Line Processor. 2. Enter the following command:
connect to <database_name> user <username> using <password>
Procedure D - MariaDB/MySQL
1. Open the CMD prompt > go to MariaDB’s bin folder (Default: C:\Program Files\MariaDB 10.4\bin) 2. Enter the following command: