Eight-step learning data Migration: How to use ETL tools kettle

First, the purpose

Merge tables on different servers onto another server. For example, merge table B on server 1 on table A and server 2 to table C on server 3

Requirements: Table A needs to be cropped (removing unnecessary fields), table B needs to add some fields

Ii. Methods of Use

(1) Create a new Table C (field that conforms to the actual system design) in the database on server 3

(2) Create a new table input, connect to server 1, select the table you want to use by getting the SQL statement, or select some fields

(2) In the same vein, create a new table input, connect to server 2, select the table you want to use by getting the SQL statement, or select some fields

(3) Create a new two sort record

(4) Select the fields to sort

(5) New record set connection

(6) Select the fields you want to connect to

(7) New table output, connecting to server 3

1. Select Table C in Server 3

2. Get fields

3. Mapping fields

(8) operation, working Gaocheng

Eight-step learning data Migration: How to use ETL tools kettle