DataGrip

This article explains how to use DataGrip with Exasol.

DataGrip comes with a built-in Exasol driver.

For more information about DataGrip, refer to the DataGrip Official Documentation.

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 trial version of DataGrip on Windows.

Prerequisites

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

Connect DataGrip to Exasol

1. Launch DataGrip and do one of the following to add Exasol as a data source:

• Select File > New > Data Source > Exasol.
• In the Database window, click on the icon and select Data Source > Exasol.

  

2. Enter the following details on Data Source and Drivers dialog:

• Name: Enter a name for the new datasource
• User: The username for the Exasol database
• Password: The database password
• URL: The connection string for the Exasol database with jdbc:exa: prefix

  

3. Click on Test Connection to check the connection. If the connection is successful, click on OK to finish. If the connection fails, check the connection string and authentication details.

   

If all the objects in the database are not visible after adding Exasol as a datasource, right-click the Exasol datasource and select Synchronize.

4. Enter an SQL statement in the database console. The result is displayed in the same window.

   

If the console is not visible, right-click the Exasol datasource and select Open Console.