Shulou(Shulou.com)06/03 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.