A simple use of ETL tools kettle

The kettle of ETL tools extracts data from one database into another database:

1. Open the ETL folder, double-click Spoon.bat start Kettle

2. Resource pool selection, Connaught no choice to cancel

3. Select Close

4. Create a new transformation

5. Configure the required database

6. The data table that needs to be extracted, with the table input to get

7. Select the database and table where the source data resides, and the SQL statement can enter it yourself

8. Select the target database and table to be extracted (drag it out)

9. Select the corresponding column in the corresponding table

10. Hold down the SHIFT key and click on the table input drag to insert/update

11. Click Start to convert