pentaho-kettle

Pentaho 数据集成(ETL),也称为 Kettle,提供强大的提取、转换和加载(ETL)功能。【 Pentaho’s Data Integration, also known as Kettle, delivers powerful extraction, transformation, and loading (ETL) capabilities. 】

Github stars Tracking Chart

Pentaho Data Integration

Pentaho Data Integration ( ETL ) a.k.a Kettle

Project Structure

  • assemblies:
    Project distribution archive is produced under this module
  • core:
    Core implementation
  • dbdialog:
    Database dialog
  • ui:
    User interface
  • engine:
    PDI engine
  • engine-ext:
    PDI engine extensions
  • plugins:
    PDI core plugins
  • integration:
    Integration tests

How to build

Pentaho Data Integration uses the maven framework.

Pre-requisites for building the project:

  • Maven, version 3+
  • Java JDK 1.8
  • This settings.xml in your /.m2 directory

Building it

This is a maven project, and to build it use the following command

$ mvn clean install

Optionally you can specify -Drelease to trigger obfuscation and/or uglification (as needed)

Optionally you can specify -Dmaven.test.skip=true to skip the tests (even though
you shouldn't as you know)

The build result will be a Pentaho package located in target.

Running the tests

Unit tests

This will run all unit tests in the project (and sub-modules). To run integration tests as well, see Integration Tests below.

$ mvn test

If you want to remote debug a single java unit test (default port is 5005):

$ cd core
$ mvn test -Dtest=<<YourTest>> -Dmaven.surefire.debug

Integration tests

In addition to the unit tests, there are integration tests that test cross-module operation. This will run the integration tests.

$ mvn verify -DrunITs

To run a single integration test:

$ mvn verify -DrunITs -Dit.test=<<YourIT>>

To run a single integration test in debug mode (for remote debugging in an IDE) on the default port of 5005:

$ mvn verify -DrunITs -Dit.test=<<YourIT>> -Dmaven.failsafe.debug

To skip test

$ mvn clean install -DskipTests

To get log as text file

$ mvn clean install test >log.txt

IntelliJ

  • Don't use IntelliJ's built-in maven. Make it use the same one you use from the commandline.
    • Project Preferences -> Build, Execution, Deployment -> Build Tools -> Maven ==> Maven home directory

Contributing

  1. Submit a pull request, referencing the relevant Jira case
  2. Attach a Git patch file to the relevant Jira case

Use of the Pentaho checkstyle format (via mvn checkstyle:check and reviewing the report) and developing working
Unit Tests helps to ensure that pull requests for bugs and improvements are processed quickly.

When writing unit tests, you have at your disposal a couple of ClassRules that can be used to maintain a healthy
test environment. Use RestorePDIEnvironment
and RestorePDIEngineEnvironment
for core and engine tests respectively.

pex.:

public class MyTest {
  @ClassRule public static RestorePDIEnvironment env = new RestorePDIEnvironment();
  #setUp()...
  @Test public void testSomething() { 
    assertTrue( myMethod() ); 
  }
}

Asking for help

Please go to https://community.hitachivantara.com/community/products-and-solutions/pentaho/ to ask questions and get help.

Main metrics

Overview
Name With Ownerpentaho/pentaho-kettle
Primary LanguageJava
Program languageShell (Language Count: 7)
PlatformLinux, Mac, Windows
License:Other
所有者活动
Created At2013-10-08 18:27:11
Pushed At2025-04-22 00:15:07
Last Commit At2025-04-21 16:58:04
Release Count2180
Last Release Name10.2.0.3-331 (Posted on 2025-04-22 00:15:03)
First Release Name2.2.2 (Posted on )
用户参与
Stargazers Count8k
Watchers Count457
Fork Count3.5k
Commits Count23.9k
Has Issues Enabled
Issues Count0
Issue Open Count0
Pull Requests Count8806
Pull Requests Open Count65
Pull Requests Close Count1090
项目设置
Has Wiki Enabled
Is Archived
Is Fork
Is Locked
Is Mirror
Is Private