Java集成kettle

首先记得添加仓库引用

查看版本可以到maven仓库地址：http://maven-repository.com/artifact/pentaho-kettle

  <repository>

    <id>pentaho-releases</id>

    <url>http://repository.pentaho.org/artifactory/repo/</url>

  </repository>

1）.必要的Jar包，应该不止这些，上次集成的时候一步一步加了很多jar包，有点乱，后面有时间再整理，commons、jdbc等也是必须的

<dependency>
			<groupId>pentaho-kettle</groupId>
			<artifactId>kettle-core</artifactId>
			<version>6.1.0.4-225</version> 
		</dependency>
		 <dependency>
		     <groupId>com.verhas </groupId>
		     <artifactId>license3j </artifactId>
		     <version>1.0.7 </version>
		 </dependency>
		<dependency>
			<groupId>pentaho-kettle</groupId>
			<artifactId>kettle-dbdialog</artifactId>
			<version>6.1.0.4-225</version> 
		</dependency>
		<dependency>
			<groupId>pentaho-kettle</groupId>
			<artifactId>kettle-engine</artifactId>
			<version>6.1.0.4-225</version> 
		</dependency>
		<dependency>
			<groupId>pentaho</groupId>
			<artifactId>metastore</artifactId>
			<version>6.1.0.4-225</version>
		</dependency> 

2）.使用Block组件，因为如果行超过所设的Memory Size就会缓存到磁盘上需要用到下面的序列化列

        <dependency>
    		<groupId>org.safehaus.jug</groupId>
   		    <artifactId>jug</artifactId>
    		<version>2.0.0</version>
    		<!-- the classifer is important!! -->
            <classifier>lgpl</classifier> 
        </dependency>

3）.使用了连接池需要包含以下jar包

<dependency>
              <groupId>commons-pool</groupId>
              <artifactId>commons-pool</artifactId>
              <version>1.6</version>
        </dependency>
        <dependency>
              <groupId>commons-dbcp</groupId>
              <artifactId>commons-dbcp</artifactId>
              <version>1.4</version>
        </dependency>

使用Java程序执行ktr、kjb文件或者资源库