Alteryx

This article explains how to connect Alteryx to an Exasol database.

For more information about Alteryx, refer to the Alteryx Documentation.

Exasol takes no responsibility for any changes in functionality or terms of use for the third-party software described in this section. For more information, refer to the respective software vendor’s website.

Environment

The following procedure uses the Alteryx Designer trial version on Windows.

Prerequisites

• A running Exasol SaaS database. For more information, see Database Management.
• The IP address of the host where the tool is running must be in the allowed IP address list. For more information, see Network Security.
• Exasol ODBC driver is installed
• Alteryx for Windows installed

Get ODBC Driver and Connection Details

To connect to your Exasol SaaS database from a tool you need a valid connection string. You must also allow network access to the database from the tool, and make sure that the latest Exasol ODBC driver is installed.

1. On the Databases page in the web console, click on Connect via tools on the cluster that you want to connect to.

   

2. In the wizard, enter the IP address of the client or server that will connect to the database and click Add IP, then click Next. This will add the IP address to the list of IP addresses that are allowed network access to the cluster. The allow list is found on the Security page in the web console. For more information, see Network Security.

   If the IP address is already present in the allow list, just click Next.

   

3. If the latest ODBC driver for your operating system is not already installed, select the driver type and operating system and click on Download to download the latest driver to your local system. For more information about how to install the driver, see ODBC Driver.

   

4. Click on Next to view your connection details:

   

5. Copy the Connection string, Port, and User name values from the Connect details dialog. You will need to enter this information in your client to connect to your database.

6. To generate a new Personal Access Token (PAT) to use for authentication in the client, click on the Password row, then click on Copy to copy the PAT to your clipboard. For more information, see Personal Access Token.

   

   The generated PAT is only shown once and cannot be retrieved after you have closed the wizard.

7. Click on Done to close the wizard.

Connect Alteryx to Exasol

1. Launch Alteryx application and select In-Database ribbon.

   The ribbon is not visible if the ODBC driver is not installed.

2. Drag Connect In-Database from the ribbon to a new work flow.
3. Select Manage Connections from the drop-down in Connection Name.

   

4. Do the following in the Manage In-DB Connections dialog:
   1. Select Exasol in the Data Source drop-down.
   2. Click New in the Connection section to define new database connection.
   3. Select New database connection in the Connection String drop-down.

   

5. Click ODBC Admin button on the Exasol Connection dialog.
6. Click Add button in the User DSN tab of the ODBC Data Source Administrator dialog.

   

7. Select EXASolution Driver in Create New Data Source and then click Finish.

   

8. Do the following in the Exasol ODBC configuration dialog and then click OK:
   1. Enter data source name.
   2. Enter a connection string.
   3. Enter database username and password.

   

   Exasol database is connected to Alteryx.