Alteryx

Learn how to connect Alteryx to an Exasol database through ODBC.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Prerequisites

  • Alteryx for Windows must be installed.

  • The Exasol ODBC driver must be installed. To learn more, see ODBC Driver.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

  • Basic knowledge about how to configure and use Alteryx is assumed.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

Connect Alteryx to Exasol

  1. In the Alteryx application, create a new In-Database connection and select Exasol as a data source and Exasol ODBC as the driver.

  2. In the ODBC data source administration tool, enter the following details for the Exasol ODBC configuration:

    • A name for the new data source

    • A connection string containing the IP addresses and port of the Exasol cluster.

      For Exasol SaaS, use the connection string provided in the web console as hostname.

    • The user name and password of the Exasol user.

      For Exasol SaaS, use a valid personal access token as password.

    exasol odbc configuration

For more details about how to configure an ODBC connection, see ODBC Driver for Windows.

For more information about how to use Alteryx with Exasol, refer to the Alteryx Documentation.