Kettle tool User Guide, kettle tool use

Kettle tool User Guide, kettle tool use

You can directly use kettle.zip to run Spoon. bat.

 

Ii. Conversion example: Data Conversion between databases

A) create a new conversion db to db. ktl

B) Create a database connection

I. Click the main object tree on the left of the screen, right-click DB connection under the current transpose, and click New,

 

Ii. Configure the database connection,

 

Iii. Click test to indicate that the database is successfully configured.

 

Iv. Click OK and save

C) Procedure of configuration Conversion

Click [core object], drag the table input, field selection, and table output, and press shift to connect them in sequence.

Follow these steps:

I. configuration table input

1. Click input, select table input, and drag it to the main window. Double-click

 

2. Fill in the SQL statement. The data obtained after running will be used as the input data.

3. Click Preview to test the data obtained after running SQL.

 

Ii. Configure table output

1. Click output, select table output, and drag it to the main window. Double-click

 

2. Select a target table

3. Click OK.

Iii. Select Configuration Fields

1. Click convert, select field, drag it to the main window, and double-click

 

2. Click column ing]

 

3. Select a field from the source field and the target field respectively, and generate a add ing of add.

D) run the conversion.

 

Similar to success, you can go to the database to check whether the changes are as expected.

 

Iii. Job example: Call the preceding Conversion

A) create a Job

B) configuration steps

Point [core object], point [general]

 

I. Configure the Start step

1. Drag Start to the main window.

2. Timing

You can double-click to set the timing.

 

Ii. Procedure for configuring Transformation

1. Drag [Transformation] to the Main Window

2. Double-click and select the path of the converted file. $ {Internal. Job. Filename. Directory} indicates the folder where the current job file is located.

 

C) run this job.

 

Similar to success, you can go to the database to check whether the changes are as expected.