kattle’s java installation, kettle installation
1.win system Click the .bat file to run 2.linux system Click the .sh file to run 3 .os system—–However, it cannot be opened through the terminal，So it is better to use 6 terminal brew install kettle It means This is something provided by the official website，However, it is useless，Ignore it for now，Maybe one day it will be enough. java_home：D:\Program Files\Java \jdk1.7.0_25(installation jdk path) classpath：.;%java_home%\lib\dt.jar;%java_home%\lib\tools.jar path& #xff1a;Add %java_home%\bin;%java_home%\jre\bin; kettle_home：D:\Program Files\data-integration (kettle installation path) (2) The Java version is too low ，jdk1.6 or above is sufficient，For details, please check the spoon.bat configuration file. (3) The Java environment configuration is correct，But after double-clicking spoon.bat, it flashes and disappears，Modify the memory configuration in spoon.bat： if “%PENTAHO_DI_JAVA_OPTIONS%”==”” set PENTAHO_DI_JAVA_OPTIONS=”-Xms2058m” “-Xmx1024m” “-XX:MaxPermSize=256m” Change for if “%PENTAHO_DI_JAVA_OPTIONS%”==”” set PENTAHO_DI_JAVA_OPTIONS=”-Xms512m” “-Xmx512m” “-XX:MaxPermSize=256m” Save the modification and restart spoon.bat to solve the problem. 4.win–Configure java environment variables http://blog.csdn.net/dongfengwuhen/article/details/21593361 (1) Open my computer–Properties –Advanced–Environment variables (2) Create new system variables JAVA_HOME and CLASSPATH Variable name：JAVA_HOME Variable value： C:\Program Files\Java\jdk1.7.0[The specific path is subject to your own local installation directory] Variable name：CLASSPATH Variable value： .;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar; (3) Select the environment variable named “Path” in “System Variables”， ;Double-click the variable ，Add the absolute path of the bin directory in the JDK installation path，…
Kettle installation, use and deployment_kettleonline_soldierluo’s blog
1. Download Kettle, version 7.1, the official website is too slow, do not download from the official website, refer to the address: https://blog.csdn.net/weixin_43407520/article/details/ 123593474 2. Kettle is a java program, you need to install jdk1.8 first (paired with kettle7.1), reference address: https://blog.csdn.net/weixin_45078706/article/details/115830318 Jdk download address, download jdk-8u341-windows-i586.exe: https://www.oracle.com/java/technologies/downloads/#java8-windows Install jdk, reference address: https://product. pconline.com.cn/itbk/software/dnwt/1408/5260596.html 3. Start the kettle, find the spoon.bat and open it, and you can log in to the interface successfully 4. Download the jar driver packages of each database, and copy them into the xxx\pdi-ce-7.1.0.0-12\data-integration\lib directory, restart kettle, sqlserver driver package address: sqljdbc4-2.0.jar: http://www.java2s.com/Code/Jar/s/Downloadsqljdbc430jar.htm jtds-1.3.1.jar: https://sourceforge.net/projects/jtds/ 5. Connect to the sqlserver database, log in to the kettle account and password is admin/admin, convert-right click-new-main object tree-DB connection-new-configure connection-right click connection name-share, reference address: https://blog.csdn.net/MengCXJ/article/details/123085141 6. Create transform, core object-input-drag table input-edit table input, output-drag insert update-hold shift to connect table input and insert update-edit insert update, run-observe Log – observe the import result 7. Create a job job, file-new-job, core object-drag-in-common start, conversion, dummy, script SQL and other components-press and hold shift to connect each component, open the conversion-select the corresponding created Conversion, open SQL-write corresponding sql script, execute-observe log-observe database result 8. dummy is a placeholder,…
