Datavault Builder

This article explains how to connect Datavault Builder to Exasol.

Prerequisites

  • The Exasol JDBC driver must be installed on the system running the tool. For information about how to download and install the JDBC driver and to get the necessary connection details, see JDBC Driver.

  • Datavault Builder must be installed with the following configuration in the docker-compose.yml file:

    - 'CLIENT_DB_CONNECTIONSTRING=jdbc:exa:[IP Address]:[port]'
    - CLIENT_DB_TYPE=exasol_client_db

  • Basic knowledge about how to configure and use Datavault Builder is assumed.

Connect Datavault Builder to Exasol

  1. Open Datavault Builder in your browser and add a new source definition. Fill in the mandatory fields as required.

  2. In the CONNECTION dropdown, select Exasol Server and enter the following parameters:

    • The hostnames or IP addresses of the Exasol cluster

    • The port of the Exasol cluster

    • The database name

    The JDBC connection string will be automatically generated by the tool.

For more information about how to use Datavault Builder, refer to the Datavault Builder documentation.