DbVisualizer

Learn how to connect to Exasol with DbVisualizer.

DbVisualizer Pro is the database 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.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

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.

    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 Exasol SaaS, use the connection string provided in the web console as hostname.

    To learn about supported URL structures for the JDBC driver, see Exasol URL.

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

    Database Userid: The username of the Exasol user.

    Database Password: The password of the Exasol user.

    For Exasol SaaS, use a valid personal access token as 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.