DBeaver

DBeaver is a universal SQL client and a database administration tool. It is a free tool, and you can download it from the DBeaver website.

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

Environment

The following environment is used as an example in the document: 

  • Community edition of DBeaver
  • Windows Operating System

Prerequisite

  • DBeaver downloaded and installed.
  • Exasol database installed and running.

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

  4. 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.
  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

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

  9. Perform the test connection again to make sure the connection to the database works. Click Test Connection, a confirmation message is displayed on a successful connection. Click OK to continue.

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

Successful Connection

Execute SQL Statements

Before you continue to execute SQL statements, ensure the option for enhanced metadata usage is checked.

  1. Click Window > Preferences > 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

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

    Open SQL Editor

  4. 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

Troubleshooting

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

Solution: The simplest way to get around that problem is to highlight the whole script and execute it as a single step.

Problem: R scripts on DBeaver are not executed.

Solution: The issue occurs when DBeaver uses the platforms linefeed convention CRLF. R scripts need to be complied with the linefeed convention LF. The workaround is to change the line delimiters to LF. To set the linefeed to LF, click File > Convert Line Delimiters to > LF.

Next Step

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

Further Information

For more information about DBeaver, see DBeaver Official Documentation.