CloverDX

This section explains how you can connect CloverDX to Exasol.

Environment

Following environment is used as an example:

  • CloverDX evaluation version
  • Windows Operating System

Prerequisite

  • Java Runtime Environment should be installed.
  • CloverDX should be installed in your system and project setup should be done.
  • A running Exasol SaaS database. For more information, see Manage Databases and Clusters.
  • The IP address of the client or server where the tool is running must be listed in the allowed IP address list. For more information, see Network Security.

Get Drivers and Connection Details

Before you can proceed with connecting to your database from a tool, download the latest Exasol JDBC driver and get the connection details. Follow these steps to get your connection details: 

  1. Click Databases Databases in the web console to open the Databases page.
  2. Click More on the cluster you want to connect to and then click Connect via tools.
  3. In the Connect to cluster wizard, enter the IP address of the client or server which will connect to the database and click Add IP. Then click Next. If the IP address was already added, just click Next.
  4. If not already installed, download the latest JDBC driver for your operating system and install it.
  5. Click Next and proceed through the wizard until you see your connection details:
  6. Copy the HOST, PORT, USERNAME, and PASSWORD. You can generate a new Personal Access Token by clicking Generate. You will need this information to connect to your database.

Procedure

  1. In the Outline panel, right-click and select Connections > Create DB connection.

    Connect CloverDX to Exasol

  1. In the Create DB Connection dialog, do the following:
    1. Enter a name for the connection.
    2. Click the plus icon to add the JDBC driver.

      Connect CloverDX to Exasol

  2. In the URL Dialog, do the following:
    1. Click Local files tab.
    2. Select the JDBC driver from its installation directory and then click OK.

      Connect CloverDX to Exasol

  3. In the Create DB Connection dialog, do the following:
    1. Select com.exasol.jdbc.EXADriver from the Available drivers section.
    2. Select EXASolution from the drop-down JDBC specific.
    3. Provide the connection details (URL, username, and password).

      Connect CloverDX to Exasol

  4. Click Finish.

    Connect CloverDX to Exasol

    Exasol database is connected to CloverDX.

Next Step

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

Further Information

For more information about CloverDX, see CloverDX documentation.