Pentaho Data Integration

Learn how to connect Pentaho Data Integration and Analytics to Exasol through JDBC.

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

  • Pentaho Data Integration and Analytics must be installed.

  • 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 Pentaho DIA 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 Pentaho to Exasol

  1. Make sure that Pentaho is not running.

  2. Copy the Exasol JDBC driver into the Pentaho Data Integration driver library.

  3. Launch Pentaho and create a new database connection. Select Exasol 4 as the connection type and Native (JDBC) as the access type.

  4. Enter the following settings:

    • The Exasol database name

    • The user name and password of the Exasol database user.

      For Exasol SaaS, use a valid personal access token as password.

    • The URL for the Exasol cluster.

      For example: jdbc:exa:192.168.6.11..14:8563

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

      To learn more about supported URL structures for the JDBC driver, see Exasol URL.

For more information about how to configure and use Pentaho DIA with Exasol, refer to the documentation on the Pentaho Data Integration website.