SQL Workbench

This section explains how to use SQL Workbench 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 SQL Workbench standard edition on Windows.

Prerequisites

  • A running Exasol database
  • Exasol JDBC driver must be installed. You can download drivers from the Exasol Downloads portal. For more information, see Drivers.
  • Java Runtime Environment (JRE) installed

Connect SQL Workbench to Exasol

  1. Launch SQL Workbench and provide the following details in the Select Connection Profile dialog. Alternatively, select File > New Window and provide the details;
  • Default group name: Exasol
  • Driver: Select EXASolution (com.exasol.jdbc.EXADriver) from the Driver drop-down.

    Connect SQL Workbench to Exasol

The Exasol driver does not come integrated with SQL Workbench. On selection in the Driver drop-down, it shows a message for editing the driver. Click OK in the message box to edit the driver.

  1. Click Open and provide the path of the JDBC driver installation directory and click OK to continue. For example, C:\Program Files (x86)\Exasol\EXASolution-7.1\JDBC\exajdbc.jar

  1. Provide the following details in the Select Connection Profile dialog:
  • Exasol installation URL with jdbc:exa: prefix
  • Username and password for the Exasol user

    To test the connection settings, click on Test. If the connection is successful, click on OK to continue.