Using Kettle for data import from different databases __ Yun-Wei

Kettle Download Address: community.pentaho.com/projects/data-integration/ One, preparation work

1. Unzip the downloaded compression package such as: Pdi-ce-6.1.0.1-196.zip
And then open Spoon.bat.

2. Create a conversion.
(When you connect to the database, you may encounter problems with the database driver package, download the corresponding driver package into the Kettle Lib folder restart software on it.) )
Creates a new transformation in the file->.
A DB connection is established in the left main object tree after the new transformation to connect to the database.
second, start to guide the data

1. Insert new Table
Select "Core Object" in the left panel, select "Enter-> table input" inside the core object, and drag the mouse to the right panel.

Double-click the dragged table to edit the table input.
Select the database connection and edit the SQL statement, and in this step you can click on the preview to see if you are connected correctly.

The database connection is in a popular configuration.

2 A table that is exported to another database through a table.
Select the core object in the left panel and select Output-> table output as shown in the figure:

Edit Table Output:
First: Table input join table output
Select table input, hold down the SHIFT key, and drag to the table output.

Then: Double-click the table output and edit it.

Here basically, this conversion will be done, you can click to run to see the effect, see if it is wrong, this must first save to run, you can save to any place.

Reference:
Kettle Introductory Course _ Baidu Experience https://jingyan.baidu.com/article/6b97984dcb1e9d1ca3b0bf4f.html