Skip to main content
Version: v2

Pentaho Kettle

Pentaho Kettle is a popular ETL (Extract-Transform-Load) tool developed by Pentaho, allowing users to easily move data from different data sources, convert data, and store them in other places.

Version support

Only supports 7.x, 8.x and 9.x

Pentaho Kettle Canner Plugin Installation

  1. Download Pentaho Kettle Canner Plugin
  2. Unzip the downloaded zip file, and put the unzipped folder (/canner-pdi-plugin-x.x.x) under the /plugins path of Pentaho Kettle pentaho-kettle-list

How to use

1. Create Database Connection

pentaho-kettle-create-db

Parameter setting

  • Connection Type: Select Canner in the list
  • Access: Select Native (JDBC)
  • Host Name: Fill in the Host of Canner Enterprise. For example, if you use an IP connection, the Host will be like 192.168.100.1; if you use a network domain, the Host will be data-portal.apps.cannerdata.com
  • Database Name: Fill in the workspace Name, workspace sql name will be the SQL Name of the workspace; this parameter can find in the Name in SQL of the Settings section in Workspace > Config
  • Port Number: If you use http, fill in 80; if you use https, fill in 443 pentaho-kettle-create-db

Put in Token

Please go to Options, and add a token parameter; the value is the Personal Access Token required for authentication; token can be obtained by referring to Get Personal Access Token pentaho-token

2. Explore

After completing the above steps, you can click Explore to see the tables, view, and materialized view set in the workspace, as shown in the figure below.

pentaho-kettle-explore-db pentaho-kettle-explore-db-result

3. Use in Design -> Input -> Table Input

After setting the Database connection, you can drag Table Input to the design screen, double-click Table Input to enter the setting form, select the connection to the database connection settings in the previous step, and enter the SQL Statement you want to use pentaho-kettle-table-input-edit

Click Preview to see part of the information pentaho-kettle-table-input-preview

Then, according to how you want to use it, Output can be converted and stored in different places.