Open source free--one of the four favorite words
1. official website Download https://sourceforge.net/projects/pentaho/files/Data%20Integration/
After downloading, unzip can, double-click Spoon.bat to start.
2. Configuring JVM and memory configuration issues
Self-configuration reference: https://www.cnblogs.com/shinge/p/5500002.html
3. If you start the error "could not create the Java VM", the Java Virtual machine is not a problem, need to modify the Spoon.bat memory configuration
If "%pentaho_di_java_options%" = = "" Set pentaho_di_java_options= "-xms2058m" "-xmx1024m" "-xx:maxpermsize=256m"
Switch
If "%pentaho_di_java_options%" = = "" Set pentaho_di_java_options= "-xms M" "-xmx" "-XX: maxpermsize=256m "
If the computer memory is less than 4G, it is recommended to be smaller.
4. If the boot continues to error, "A Java exception has occurred", you can consider whether the downloaded Kettle version matches your JDK,
Example: pdi-ce-7.1.0.0-12 version corresponds to JDK1.8
3. Connection database could not 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.37-bin.jar to the \\pdi-ce-6.0.1.0-386\data-integration\lib below, and then restart the spoon.
Kettle start times wrong cannot create Java Virtual machine & A Java exception have occurred