java与kettle的集成表输入--插入更新DEMO

1. 导入依赖包
<dependencies>
  <dependency>
    <groupId>pentaho-kettle</groupId>
    <artifactId>kettle-core</artifactId>
    <version>7.1.0.0-12</version>
  </dependency>
  <dependency>
    <groupId>pentaho-kettle</groupId>
    <artifactId>kettle-dbdialog</artifactId>
    <version>7.1.0.0-12</version>
  </dependency>

  <dependency>
    <groupId>pentaho-kettle</groupId>
    <artifactId>kettle-engine</artifactId>
    <version>7.1.0.0-12</version>
  </dependency>

  <dependency>
    <groupId>pentaho</groupId>
    <artifactId>metastore</artifactId>
    <version>7.1.0.0-12</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-vfs2 -->
  <dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-vfs2</artifactId>
    <version>2.2</version>
  </dependency>

  <dependency>
    <groupId>com.google.guava</groupId>
    <artifactId>guava</artifactId>
    <version>19.0</version>
  </dependency>

  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.25</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/commons-lang/commons-lang -->
  <dependency>
    <groupId>commons-lang</groupId>
    <artifactId>commons-lang</artifactId>
    <version>2.6</version>
  </dependency>
</dependencies>

2. 转换方法

// 调用Transformation示例：
public static void runTrans(String filename) {
    try {
        KettleEnvironment.init();
        TransMeta transMeta = new TransMeta(filename);
        Trans trans = new Trans(transMeta);
        String[] params = {};
        trans.execute(params);// 执行转换
        trans.waitUntilFinished(); // 等待转换执行结束

        if (trans.getErrors() != 0) {
            System.out.println("Error");
        }
    } catch (KettleXMLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (KettleException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

3. main 测试类

public static void main(String[] args) {
    String jobname = "C:\\Users\\lhh\\Desktop\\kettle\\pdi\\表输入-插入更新\\TE.ktr"; //选择自己的ktr文件地址
    KettleTest.runTrans(jobname);
}

成功示例图