Datavault Builder

Learn how to connect Datavault Builder to Exasol.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Prerequisites

  • 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

  • The Exasol JDBC driver must be installed. To learn more, see JDBC driver.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

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

    • Exasol SaaS

    • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

    • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

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.

      For Exasol SaaS, use the connection string provided in the web console as hostname.

    • The Exasol database port (8563)

    • 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.