Advanced Query Tool

This section 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.

    Connect AQT to Exasol

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

    Connect AQT to Exasol

  1. 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.

      Connect AQT to Exasol

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

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

    Connect AQT to Exasol

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

    Connect AQT to Exasol

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.