Skip to main content
Version: v3

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.