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

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

How to Connect to Databases Outside of Alteryx

gtorres8
Alteryx
Alteryx
Created
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.
 

Prerequisites

 
  • Database Specific Clients
    • Database Credentials
  • 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:
 username/password@servicename


 

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:
 mysql –u <username> -p
3. Hit enter, then enter the password.



 

Additional Resources