Import and export of ETL tools-kettle data-database to database

Introduction to ETL:

ETL (extract-transform-load abbreviation, that is, the process of data extraction, transformation, loading)

Database to Database

The following explains: Kettle Tool Implementation method

Case Purpose : Import the EMP table from user Scott under User testuser.

Preparation: first create a new table with the same structure as the EMP table in the Scott account under the TestUser account.

Operation Steps:

1. Check if an EMP empty table has been established under the TestUser account.

Figure 1: Detecting the EMP table in user TestUser

2. Create a new transform and drag into table input, table output.

Figure 2: New step

Figure 3: "Table input", "table output" dragged into "conversion 1" in the workspace

Note: After the operation of Figure 2, the interface of Figure 3 will appear, but the "Conversion 1" interface is blank. Expand "Input" in the left panel, find "Table input", drag and drop to "convert 1", and similarly expand "output" to find "table output" dragged to the "transform 1" workspace. Hold down the SHIFT key and drag the "table input" icon from "Convert 1" to "table output" to establish a connection. Notice that the arrow is in the opposite direction.

3. Double-click "Table Input" to configure the relevant content

Figure 4: Configuring the relevant content in table input

Figure 5: Test result diagram

Figure 6: Configure the SQL statement to query the specified table. And you can see the records in the table by "preview"

Note: You can see the records in the table, which means that the "input table" configuration was successful.

4. Double-click "Table Output" to configure related content

Figure 7: Configuring the database connection for table output

Figure 8: Additional options for configuring table output

5. Save and run

Figure 9: Run > Start > Save configuration file

Figure 10: The correct running result

6: Check in the database

Figure 11: The data has been imported

End!!!

Import and export of ETL tools-kettle data-database to database