DBeaver

This article explains how to use DBeaver with Exasol.

DBeaver is a free universal SQL client and database administration tool. For more information, refer to the DBeaver website.

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 community edition of DBeaver on Windows.

Prerequisite

  • A running Exasol database
  • Exasol JDBC driver must be installed. You can download drivers from the Exasol Downloads portal. For more information, see Drivers.
  • DBeaver is installed and has network access to the Exasol database

Connect to your Database

  1. Click Database > New Database Connection.
  2. In the Select your database screen, click All, select Exasol, and then click Next.

    3. Select New Database Connection

  3. In the Exasol Connection Settings screen, enter the following connection details:
    • Host List: Enter the Connection string.
    • Port: Enter the port number. The default port is 8563.
    • User name: Enter your user name.
    • Password: Enter your password.

    Database Connection Details

  4. To test the connection, click on Test Connection. If the connection test fails, check the connection string and authentication details.
  5. When you click Test Connection, DBeaver also performs a check on the available JDBC driver for Exasol and prompts you to download the driver. The Driver settings screen is displayed where you can download the latest driver. To download the JDBC driver for Exasol, click Download .

    6. Download Exasol JDBC Driver

  6. Next, you can verify the JDBC driver details by clicking Edit Driver Settings in the Connect to database screen, and click OK to continue.

    7. Edit Driver Settings

  7. Click on Test Connection again to confirm that the connection works. Click OK to continue.

The Exasol database is now listed in the Database Navigator section in DBeaver. 

Successful Connection

Execute SQL Statements

Before you continue to execute SQL statements, make sure that enhanced metadata usage is enabled.

  1. Click Window > Preferences > Connections > Metadata, and, if necessary, select the Open separate connection for metadata read check box. To save the changes, click Apply and Close.

    2. Metadata Settings

  2. To open an SQL editor, click SQL Editor > SQL Editor.

    Open SQL Editor

  3. Enter an SQL statement in the SQL editor and execute it. The result of the query is shown in the Result tab.

    Execute Queries

Known Issues

Problem: If a script contains multiple semicolons or newlines, DBeaver will not be able to identify where the script ends.

Solution: A simple workaround is to highlight the whole script and execute it as a single step.

Problem: R scripts on DBeaver are not executed.

Solution: This issue can occur when DBeaver is running on a platform that uses CRLF line endings. R scripts must be compiled with LF (Linux) line endings. To change the line endings to LF, click File > Convert Line Delimiters to > LF.