This section describes the functions of HiRDB Dataextractor.

HiRDB Dataextractor provides three facilities:

• Data extraction facility
  The data extraction facility extracts data from a specified database and sends the extracted data to a target system. The user selects the data to be extracted. It is also possible to add columns to the extracted data.
  The system used to execute the data extraction facility is referred to as the source system.
  
• Data import facility
  The data import facility receives data from a source system and imports it into a target table. This facility uses HiRDB's database load utility (pdload) to import data into a HiRDB table.
  The system used to execute the data import facility is referred to as the target system. For details about the HiRDB database load utility (pdload), see the HiRDB Command Reference manual.
  The data import facility cannot be used to import data into an ORACLE table.
  
• File creation facility
  The file creation facility receives data from a source system and saves it as a file. This facility enables data linkage with non-HiRDB database systems.
  The system used to execute the file creation facility is referred to as the file creation system.
  

Figure 1-2 provides an overview of data extraction and import between a mainframe database (XDM/RD) and a HiRDB or ORACLE database (TCP/IP connection).

Figure 1-3 provides an overview of data extraction and import between a mainframe database (XDM/RD) and a HiRDB or ORACLE database (OSI connection).

Figure 1-4 provides an overview of data extraction from a HiRDB or ORACLE database and its import into a HiRDB database.

Figure 1-5 provides an overview of data extraction from a HiRDB or ORACLE database and creation of a file.

Figure 1-2 Overview of data extraction and import between a mainframe database (XDM/RD) and a HiRDB or ORACLE database (TCP/IP connection)

Figure 1-3 Overview of data extraction and import between a mainframe database (XDM/RD) and a HiRDB or ORACLE database (OSI connection)

Figure 1-4 Overview of data extraction from a HiRDB or ORACLE database and its import into a HiRDB database

Figure 1-5 Overview of data extraction from a HiRDB or ORACLE database and creation of a file