Advanced Query Tool

This article explains how to use Advanced Query Tool (AQT) with Exasol.

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 evaluation version of AQT v10 on Windows.

Prerequisites

• A running Exasol database
• Exasol ODBC driver must be installed. You can download drivers from the Exasol Downloads portal. For more information, see Drivers.
• AQT client is installed

Connect the AQT Client

1. Launch AQT.

   

2. Click on Add new Datasource and select EXASolution Driver.

   

3. In the Exasol ODBC configuration dialog, enter the following details:
   • Data source name: Exasol
   • Connection string: IP address of the Exasol database

   • User name and password: The database username and password. The default username is sys and the password is exasol.

     

4. Click on Test connection to verify that the connection configuration works. If the test is successful, click on OK.

5. To connect to Exasol, enter the database username in Userid and the password in Password.

   

6. After a successful connection, the database details are displayed in the left tree as shown below.

   

You can now run SQL queries on your Exasol database using AQT. For more information on how to use AQT, refer to the AQT Documentation.