This section describes how to connect Alteryx to Exasol.
Following environment is used as an example:
- Alteryx Designer trial version
- Windows Operating System
- Exasol should be installed and running on your system reachable through a public network.
- Alteryx should be installed on your system.
- ODBC Driver should be installed. You can download the ODBC Driver from Exasol Download page. For more information about ODBC Driver, see ODBC Driver.
- Launch Alteryx application and select In-Database ribbon.
The ribbon is not visible if the ODBC driver is not installed.
- Drag Connect In-Database from the ribbon to a new workflow.
- Select Manage Connection from the drop-down in Connection Name.
- Do the following in the Manage In-DB Connections dialog:
- Select Exasol in the Data Source drop-down.
- Click New in the Connection section to define new database connection.
- Select New Database Connections... in the Connection String drop-down.
- Click ODBC Admin button on the Exasol Connection dialog.
- Click Add button in the User DNS tab of the ODBC Data Source Administrator dialog.
- Select EXASolution Driver in Create New Data Source and then click Finish.
- Do the following in the Exasol ODBC configuration dialog and then click OK:
- Enter data source name.
- Enter a connection string.
- Enter database username and password.
Exasol database is connected to Alteryx.
After connecting Alteryx to Exasol, you can start loading data into the Exasol database. For more information, see Loading Data.
For more information about Alteryx, see Alteryx Documentation.