DbVisualizer

This article explains how to connect to Exasol with DbVisualizer.

DbVisualizer Pro is the SQL client recommended by Exasol and is used extensively in our documentation and training materials. This article explains how to connect to Exasol with DbVisualizer Pro version 25.3 on Windows. The procedure is essentially the same in the free edition and on other platforms.

For more information about the different editions and how to use DbVisualizer, refer to the DbVisualizer User Guide.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Prerequisites

  • DbVisualizer must be installed. For download links and instructions, see Download DbVisualizer on the DbVisualizer website.
  • The Exasol database must be running and reachable from the machine where DbVisualizer is running.

Connect to Exasol

  1. In DbVisualizer, run the Create Connection wizard from the start page or select Database > Create Database Connection.

  2. In the dropdown menu, double-click on Exasol to create a new connection.

    You can use the search field in the dropdown menu to quickly find Exasol in the list of drivers.

    select connection driver

  3. In Database Connection: Exasol, enter the following details:

    Database Server: The hostname or IP address to a node, or a list of nodes.

    For example: 203.0.110.11 or 203.0.110.11..13

    For more details about supported URLs for the JDBC driver, see Exasol URL.

    Database Port: The Exasol database port number. The default port is 8563.

    Database Userid: The database username.

    Database Password: The database password.

    Certificate Fingerprint: If the connection requires TLS encryption and there is no valid TLS certificate, you can use the certificate fingerprint to connect (see also the next step).

    database connection settings

  4. Click on Test Connection. If the connection attempt is successful, a confirmation message is shown.

    connection test successful message

    If the connection uses TLS encryption and a valid certificate or fingerprint is not found, the connection will fail. Copy the fingerprint from the error message and paste it into the Certificate Fingerprint field, then test the connection again.

  5. If the connection test was successful, click on Connect to connect to the Exasol database. The database should now be listed in the Databases pane.

    Exasol database in list of databases

    If the connection test fails, check the connection string and authentication details.

Next steps

To learn more about how to use DbVisualizer with Exasol, refer to the DbVisualizer User Guide.