Pentaho Data Integration 7.1 (kettle) installation manual
Kettle is a foreign open source ETL tool, written in pure java, can be run on Window, Linux, Unix, green without installation, efficient and stable data extraction. It allows you to manage data from different databases by providing a graphical user environment to describe what you want to do, not what you want to do.
1. JDK environment settings
Because PDI is written in java, you need to have a local running environment for JVM. JDK download link: JDK_1.8
JDK installation is very simple, always click "next" to complete. After the installation is complete, set the environment variables as follows:
JAVA_HOME=C:\ Program Files\ Java\ jdk1.8.0_152Path=C:\ Program Files\ Java\ jdk1.8.0_152\ binCLASSPATH=.;C:\ Program Files\ Java\ jdk1.8.0_152\ lib\ dt.jar;C:\ Program Files\ Java\ jdk1.8.0_152\ lib\ tools.jar
2. Oracle environment variable setting
This step is optional or optional and can be configured according to the needs of the actual environment. Oracle instantclient version 11.2.0.4 x64 is used here, and you can use it simply by decompressing it.
ORACLE_BASE=C:\ OracleORACLE_HOME=C:\ Oracle\ instantclient_11_2LD_LIBRARY_PATH=C:\ Oracle\ instantclient_11_2NLS_LANG=AMERICAN_AMERICA.ZHS16GBKSQL_PATH=C:\ Oracle\ instantclient_11_2TNS_ADMIN=C:\ Oracle\ instantclient_11_2\ network\ adminPATH=C:\ Oracle\ instantclient_11_2
3. Obtain PDI software
This software is green software, after download, decompress to any directory can be used; the latest stable version is 7.1. After the installation is complete, click spoon.bat under the directory to start kettle. Download link: Data Integration 7.1
4. JDBC driver settings
Oracle JDBC driver download: Oracle Database 11g Release 2 JDBC Drivers (ojdbc6.jar and ojdbc6_g.jar)
Download MySQL JDBC driver: MySQL Connector Java
Download PostgreSQL JDBC driver: PostgreSQL JDBC Driver
Download the jar file above and extract it to the lib folder of the PDI home directory.
References:
1 、 Spoon User Guide
2 、 Pentaho Data Integration Steps
3. The usage of Kettle scheduling
4. Download Kettle Community Edition
5. Download Kettle Enterprise Edition
