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 database
  • Exasol JDBC driver must be installed. You can download drivers from the Exasol Downloads portal. For more information, see Drivers.
  • Java Runtime Environment (JRE) is installed
  • A project is available in Talend Data Integration

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