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

Premise

First, install JDK java environment

1. Kettle is an open source ETL tool written by pure Java. Currently, both Kettle7 and Kettle8 need Java8 or above to run normally. So check that the Java environment is configured correctly before running Kettle.

It is obvious that the java JDK environment is not installed in the current environment, so let's go to the java official website to download the JDK installation package.

JDK download website: https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Download the corresponding JDK version according to your system environment, here is the windows 64-bit operating system.

Installation process:

1) after downloading and installing, you can choose the default installation here, and you can install it to the corresponding location according to your custom. The path to which you install is optional.

2) here is the Java installation, or you can click change to change to another drive letter (I install it here by default):

3) after the installation of Java is completed, the installation of the entire JDK is over. Click close.

Test whether the java installation was successful, but obviously it did not, because no JAVA environment variable was added.

Next, add java environment variables computer-> Properties-- > Advanced system Settings-- > environment variables.

JAVA_HOME environment variable

Now you need to create a new system variable. Click New under the system variable: the variable name can be self-named. Generally, JAVA_HOME is used. The variable value is the directory where your JDK is installed (full path). Mine is installed under disk C by default:

Path environment variable.

Find the Path variable in the system variable, which comes with the system and does not need to be created. Double-click Path, and since the original variable value already exists, add ";% JAVA_HOME%\ bin;%JAVA_HOME%\ jre\ bin" after the existing variable. Pay attention to the front semicolon.

CLASSPATH environment variable.

Configuration method:

Create a new CLASSPATH variable CLASSPATH variable name, and be careful not to forget the preceding dot and the semicolon in the middle. And semicolons and commas in the state entered in English.

CLASSPATH:.;% JAVA_HOME%\ lib;%JAVA_HOME%\ lib\ dt.jar;%JAVA_HOME%\ lib\ tools.jar

Third, test environment.

Verify that the configuration runs cmd successfully and enter java and java-version respectively (there is a space between java and-version).

If the version information is displayed as shown in the figure, the installation and configuration are successful.

Officially start installation of Kettle

Official website: https://community.hitachivantara.com/docs/DOC-1009855 to download the latest version, the size of this package is about 860m.

Or download it locally on git: http://192.168.20.12/download/dev-tool/kettle_windows.zip. Here is the Windows version.

Click to unzip the downloaded package

Find spoon.bat, double-click to run, and the following page appears:

1. Create a new transformation, click Save to local path, Ctrl+s is saved to a local directory, and the kettle default conversion file is saved with the suffix ktr.

two。 Right-click the DB connection and select New, which is used to connect to the database. This figure shows mysql as an example, and select Native (JDBC method). Fill in the options that need to be added on the right.

Connection name: the name of this connection

Host name: ip address of the database

Database name: refers to the specific library above the database.

Port number: fill in according to the actual open port

User name, password: user name, password of the database

After filling in the relevant information, click Test. If the connection is successful, a window will pop up to display the connection information as shown in the figure:

If it fails, you will be prompted that the jdbc driver connected to the database has not been found as shown in the figure. The method is as follows:

1) at this time, we need to go to the official website to download the jdbc driver. Here is mysql. If you need to go to the mysql official website to download the data, you can go to the official website to find the relevant driver. The method is the same as follows:

Web site: https://dev.mysql.com/downloads/connector/j/

Windows chooses to be flat and independent according to its own operating system.

Click to download the following driver

After downloading the compressed package, you will get the mysql driver as shown in the figure

Put the driver file under the kettle installation location and the path is: pdi-ce-7.1.0.0-12\ data-integration\ lib. At this time, you must restart kettle, add a connection to the DB library, and test:

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.