Download, installation and initial use of kettle (under Windows platform) (detailed)

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 

Yellow Sea notes:

Download with thunder, the speed is very fast:

? 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. Yellow Sea Note:: http://download.oracle.com/otn-pub/java/jdk/8u171-b11/512cd62ec5174c3487ac17c61aaa89e8/ Jdk-8u171-windows-x64.exe? Authparam=1530515451_6b2c7a63a8530f7c0e8a17d17d1570d1 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

Yellow Sea Note: Download Https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-5.1.46.zip

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)