Datavault Builder

This section explains how to connect Datavault Builder to Exasol.

Environment

Datavault Builder enterprise edition is used as an example.

Prerequisite

  • A running Exasol SaaS database. For more information, see Manage Database and Clusters.
  • 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.
  • Datavault Builder should be installed and the following details should be configured in the docker-compose.yml file during installation.
  • - 'CLIENT_DB_CONNECTIONSTRING=jdbc:exa:[IP Address]:[port]'
    - CLIENT_DB_TYPE=exasol_client_db

Procedure

  1. Open Datavault Builder in your browser and click New Source button.
  2. Add the following details in the BASE tab of the Add source dialog:
    • Source System Name: Enter Exasol as source system name. This is a mandatory field.
    • Source System ID: Enter an ID for the source system. This is a mandatory field.
    • Comment: This is an optional field.

    Connect Datavault Builder to Exasol

  3. On the CONNECTION tab, select Exasol Server in the Source Type drop-down and provide the following details:
    • Host Name: Hostname or IP address of Exasol database.
    • Port: Port of the Exasol database.
    • JDBC Connection String: Connection string with required details of the Exasol database.

    Connect Datavault Builder to Exasol

    Click TEST CONNECTION if you want to test the connection to the Exasol database.

  4. On the CONNECTION tab, review all the details that you provided in the earlier steps and click ADD SOURCE.

    Connect Datavault Builder to Exasol

Exasol is connected to Datavault Builder.

Further Information

For more information about Datavault Builder, see Datavault Builder Official Documentation (external link).