Talend Data Integration

This article explains how to connect Talend Data Integration to an Exasol database.

For more information about Talend Data Integration, see Talend Documentation.

Exasol takes no responsibility for any changes in functionality or terms of use for the third-party software described in this section. For more information, refer to the respective software vendor’s website.

Environment

The following procedure uses Talend Open Studio for Data Integration on Windows.

Prerequisites

  • A running Exasol SaaS database. For more information, see Database Management.
  • 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.
  • Exasol JDBC driver is installed
  • Java Runtime Environment (JRE) is installed
  • A project is available in Talend Data Integration

Get JDBC Driver and Connection Details

To connect to your Exasol SaaS database from a tool you need a valid connection string. You must also allow network access to the database from the tool, and make sure that the latest Exasol JDBC driver is installed.

  1. On the Databases page in the web console, click on Connect via tools on the cluster that you want to connect to.

    connect via tools

  2. In the wizard, enter the IP address of the client or server that will connect to the database and click Add IP, then click Next. This will add the IP address to the list of IP addresses that are allowed network access to the cluster. The allow list is found on the Security page in the web console. For more information, see Network Security.

    If the IP address is already present in the allow list, just click Next.

    enter ip address

  3. If the latest JDBC driver for your operating system is not already installed, select the driver type and operating system and click on Download to download the latest driver to your local system. For more information about how to install the driver, see JDBC Driver.

    download driver

  4. Click on Next to view your connection details:

    connection details

  5. Copy the Connection string, Port, and User name values from the Connect details dialog. You will need to enter this information in your client to connect to your database.

  6. To generate a new Personal Access Token (PAT) to use for authentication in the client, click on the Password row, then click on Copy to copy the PAT to your clipboard. For more information, see Personal Access Token.

    generated pat

    The generated PAT is only shown once and cannot be retrieved after you have closed the wizard.

  7. Click on Done to close the wizard.

Connect Talend to Exasol

Connect to Exasol

Do the following to connect Talend Data Integration to Exasol:

  1. Create a new project in Talend Data Integration.

  2. In the Repository panel, right-click Db Connection under Metadata and select Create connection.

  3. Enter the database connection details (name, Purpose, and description) and click Next.

  4. Do the following to add the connection credentials:
    1. Select Exasol from the DB Type drop-down.
    2. Enter user name, password (personal access token), database IP address, and port (default 8563) to access the Exasol database.
    3. Enter the value for Database field which is the schema in the Exasol database.

  5. Click Test connection button to test the connectivity with Exasol database.
  6. Click Download and install all modules available when the wizard prompts to install Exasol driver.

    If you want to install only the Exasol JDBC driver, select exajdbc-<version> and click Download and Install.

  7. Review the license agreement, accept the terms, and click Finish.
  8. On a successful connection, click OK on the message and continue.

    If the connection fails, check the connection details provided in step 4.

    The new connection appears under Db connections drop-down menu.

Retrieve Schema

Do the following to retrieve a schema in Talend Data Integration:

  1. Right-click Exasol under Metadata > DB Connections.

  2. In Schema dialog, select required filter and click Next.
  3. In Schema dialog, select schema table(s) and click Next.
  4. Modify the selected schema table(s) if required.

  5. Click Finish.

    The retrieved schema appears in Metadata > DB Connections> Exasol.