Pentaho Data Integration

This article explains how to connect Pentaho Data Integration and Analytics to Exasol through JDBC.

Prerequisites

  • The Exasol JDBC driver must be installed on the system running the tool. For information about how to download and install the JDBC driver and to get the necessary connection details, see JDBC Driver.

  • Pentaho Data Integration and Analytics must be installed.

  • Basic knowledge about how to configure and use Pentaho DIA is assumed.

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 hostname or IP address and the port of the Exasol cluster

    • The Exasol database name

    • The user name and password of the database user

For more information about how to configure and use Pentaho DIA with Exasol, refer to the Pentaho documentation portal.