Data extraction by HiRDB Dataextractor involves extracting data from a database and then sending that data to a target system. HiRDB Dataextractor enables you to extract only selected data and also to add fields to the extracted data.

The explanation in this section is for data extraction from a HiRDB database and data import into a HiRDB database.

Figure 3-1 shows the data extraction procedure.

Figure 3-1 Data extraction procedure

Organization of this section

3.1.1 Extracting selected data

3.1.2 Adding columns to extracted data

3.1.3 Converting the data type of extracted data

3.1.4 Converting the character codes of extracted data