SQL Workbench

This section describes how to connect SQL Workbench to Exasol and run an SQL statement.

Environment

The following environment is used as an example:

  • SQL Workbench standard edition
  • Windows Operating System

Prerequisite

  • Java Runtime environment should be installed
  • A running Exasol SaaS database. For more information, see Manage Databases and Clusters.
  • The IP address of the client or server where the tool is running must be listed in the allowed IP address list. For more information, see Network Security.

Get Drivers and Connection Details

Before you can proceed with connecting to your database from a tool, download the latest Exasol JDBC driver and get the connection details. Follow these steps to get your connection details: 

  1. Click Databases Databases in the web console to open the Databases page.
  2. Click More on the cluster you want to connect to and then click Connect via tools.
  3. In the Connect to cluster wizard, enter the IP address of the client or server which will connect to the database and click Add IP. Then click Next. If the IP address was already added, just click Next.
  4. If not already installed, download the latest JDBC driver for your operating system and install it.
  5. Click Next and proceed through the wizard until you see your connection details:

  6. Copy the HOST, PORT, USERNAME, and PASSWORD. You can generate a new Personal Access Token by clicking Generate. You will need this information to connect to your database.

Procedure

  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 and click OK to continue:
  • Exasol installation URL with jdbc:exa: prefix.
  • Exasol username and password for the user.

    You can click the Test button to test the connection settings.

    On a successful connection, a message is shown, click OK to continue.

  1. Enter an SQL statement in blank space. The result is displayed below the query window.

Next Step

After connecting SQL Workbench to Exasol, you can start loading data into the Exasol database. For more information, see Loading Data.

Further Information

For more information about SQL Workbench, see SQL Workbench Official Documentation.