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.
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.
This is what your EXASOL data source should look like.
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.
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 will then ask you to specify a table name. IMPORTANT: list the EXASOL schema first.
Then, your EXASOL destination is ready to go.