HOW TO: Connecting Alteryx to EXASOL

Connecting Alteryx to EXASOL has three parts, downloading the relevant EXASOL driver,  Creating an ODBC Data source for EXASOL and finally configuring that in Alteryx.

Downloading the EXASOL Driver

With the Alteryx free download there is currently no EXASOL driver by default.

Download Download ODBC Driver from the EXASOL website

Install the driver.

Open up the ODBC Data Source Administrator, and go to the Drivers tab. You will see that the EXASolution Driver is now installed.

datasources_admin_drivers

Create an EXASOL Data Source

Still in the ODBC Data Source Administrator, go to the System DSN tab. Select Add. Then, in the EXASolution ODBC configuration window, enter in the details for your EXASOL instance. You can also provide the default schema, or leave it blank to be flexible.exasol_odbc_config

This is what your EXASOL data source should look like.exasol_ds

Configuring EXASOL as a Database Connection in Alteryx

Now we have the EXASOL data source configured we can head to Alteryx. In this case we are going to use an Output with EXASOL.

With your ETL process already setup, drag on Output Data block.

In the Write to File or Database dropdown, select Database Connection, then New ODBC Connection.

alteryx_add_odbc

Next, select the Data Source Name you just created. If it’s not in the dropdown, use ODBC Admin to select it. If you did not specify your credentials in the data source, enter them in here.

alteryx_set_odbc

Alteryx will then ask you to specify a table name. IMPORTANT: list the EXASOL schema first.

alteryx_output_table

Then, your EXASOL destination is ready to go.alteryx_exasol_output