Download of Kettle
? Kettle can be downloaded from the http://kettle.pentaho.org/website
Http://sourceforge.net/projects/pentaho/files/Data%20Integration/7.1/pdi-ce-7.1.0.0-12.zip/download
?
installation of KettleDownload the kettle compression package, as the kettle is green software, unzip to any local path. Here I am, under the D:\SoftWare, New kettle,
Extract
For the configuration of the JDK under Windows, I'm not going to go over it here.
preliminary use of KettleGo to the Kettle directory, if Kettle is deployed in a Windows environment, double-click Run Spoon.bat or Kettle.exe file, the following interface appears:
Because
Run Spoon
Run scripts supported by spoon on different platforms:
spoon.bat: Running Spoon on the Windows platform;
Spoon.sh: Run Spoon on Linux, Appleosx, and Solaris platforms.
The default is open, everyone Kettle installation directory, English welcome interface.
File:///D:/SoftWare/kettle/data-integration/docs/English/welcome/index.html
Initial use:
In the upper left corner, click "File-New-Convert" to save as Demo.ktr
Summary of issues that may arise from initial start-up and use
Issue one: Configuring JVM and Memory configuration issues
If Java_home is set, you are still prompted:
Could not find the main class. Program would exit!
Environment variables can be set: Pentaho_java_home, the value of the variable is: JDK installation directory, more than 1.6. This machine is: D:\Program files\java\jdk1.7.0_8
However, there is generally no need for ha.
Question two: If start also reported wrong error:could not create the Java virtual machine!
Not a Java virtual problem, modify the Spoon.bat memory configuration:
If "%pentaho_di_java_options%" = = "" Set pentaho_di_java_options= "-xms1024m" "-xmx2048m" "-xx:maxpermsize=256m"
Switch
If "%pentaho_di_java_options%" = = "" Set pentaho_di_java_options= "-xms512m" "-xmx1024x768m" "- xx:maxpermsize=256m "
Problem Three: Connection database cannot find driver problem (MySQL for example)
Hint error [MySQL]: org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Driver class ' Org.gjt.mm.mysql.Driver ' could not being found, make sure the ' MySQL ' Driver (jar file) is installed.
Org.gjt.mm.mysql.Driver
Workaround: Copy the Mysql-connector-java-5.1.21-bin.jar to
D:\SoftWare\kettle\data-integration\lib, and then restart Spoon.
Reference BlogHttp://www.cnblogs.com/limengqiang/archive/2013/01/16/kettleapply1.html#xzbs http://www.cnblogs.com/ Yiyezhiqiusmile/p/6010892.html
Download, installation and initial use of kettle (under Windows platform) (detailed)