DataGrip

This article explains how to connect to Exasol with DataGrip.

DataGrip is a cross-platform database IDE developed by JetBrains. For more information, see DataGrip on the JetBrains website.

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

  • DataGrip must be installed. For download links and instructions, see Download DataGrip on the JetBrains website.

  • Your Exasol SaaS database must be running. For more information, see Database Management.

  • The IP address of the host where the tool is running must be in the allowed IP address list. For more information, see Network Security.

Get the connection details

  1. On the Databases page in the Exasol SaaS web console, click on the info button  on the cluster to view the cluster details.

  2. Copy the Connection string as well as the Port and User name. You will need these details to set up the connection in the client.

    saas cluster details

  3. If you do not already have a personal access token (PAT), follow the instructions in Personal access token to create a new token. The token and the username will be used by the client to authenticate to Exasol.

    The token is only shown once and will disappear when you close or refresh the page. Make sure that you copy the token, since it cannot be retrieved if you lose it. In that case you must create a new token.

Connect to Exasol

DataGrip comes with a built-in Exasol driver.

  1. In DataGrip, create a new Exasol data source.
  2. If the database driver is missing or outdated, click on Download driver to download the latest Exasol JDBC driver.

  3. In the data source configuration, enter the connection details that you fetched in Get the connection details:

    Host: The connection string for the Exasol SaaS database.

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

    Authentication: Select User & Password

    User: Your Exasol SaaS username.

    Password: Your personal access token (PAT).

    data source settings

  4. Click on Test Connection to test the connection.

  5. If the connection attempt is successful, click on OK to connect to Exasol.

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

Next steps

For more information about how to use DataGrip, refer to the DataGrip documentation on the JetBrains website.