Kettle _ example of data extraction

Experiment project: kettle is used to extract emp table data of scott user to emptest table of hyl user. experiment environment operating system: WIN7 Database: oracle11gr1_bitkettle version: version3.2.2 start experiment: 1. query the data in the emp table of scott. create an experiment table (emptest) 3. query hyl users

Experiment project: kettle is used to extract emp table data of scott user to emptest table experiment environment of hyl user. Operating System: WIN7 Database: Oracle11G R2 64-bit KETTLE version: version 3.2.2 starts the experiment: 1. query the data in the emp table of scott. create an experiment table (emptest) 3. query hyl users

Experiment project: kettle is used to extract emp table data under scott to emptest table under hyl.

Lab Environment

Operating System: WIN7

Database: Oracle11G R2 64 bit

KETTLE version: version 3.2.2

Start the experiment:

1. query the emp table data of scott.

2. Create an experiment table (emptest) under the hyl user)

3. query the experiment table (emptest) data of hyl users.

4. Configure kettle

Click "no resource library" to start and then add a database connection, as shown in:

Create a new conversion, such:

Click "table input" and drag it to the Panel, for example:

Similarly, in the output project, select "insert/update" to add it to the Panel, for example:

Click the "table input" icon and press "SHIFT" to connect to the "insert/update" icon, as shown in:

Double-click the "table input" icon and click "new" To Go To The following configuration page. Refer to the settings shown in the figure to complete the database connection configuration and perform a test, as shown in:

After completing the database connection settings in "table input", configure the database connection under the "insert/update" icon in the same way. Refer to the configuration below:

After configuring the database connection between "table input" and "insert/update", double-click "table input" To Go To The following interface and select "scott" as the database connection ", in our previous data source database, click "obtain SQL query statement", as shown in:

Select the table to be extracted, as shown below:

Click "yes" as prompted, for example:

Write an SQL script. Here we want to make the experiment simple. The table structure at the source and target ends is the same, as shown in:

Double-click the "insert/update" icon to configure the target end, select the target database hyl to connect to, click & ldqu [this article from the Internet (http://www.68idc.cn)] o; browse to obtain the target table, as shown in:

Click "get field" to see the correspondence between the source and target. Click "get update field" to see what fields we want to update, as shown in:

You need to save the kettle project before running it, for example:

Everything is ready, just run, as shown in:

After extraction, a message is displayed, as shown in:

5. hyl user verification of data extraction from the experiment table

So far, we have extracted scott's emp table data to the emptest table under the hyl user to complete the experiment.

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/42264543