Datavault Builder

This article explains how to connect Datavault Builder to Exasol.

Prerequisites

  • Your Exasol SaaS database must be running.

  • The IP address of the host where the tool is running must be in the allowed IP address list.

    To learn more about how to allow traffic to your database, see Network Security.

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

    Copy 
    - '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.