4 Using Heterogeneous Services Agents

This chapter explains how to use Heterogeneous Services (HS) agents. For installing and configuring the agents, refer to the Oracle Database gateway installation and configuration guides.

Topics:

• Initialization Parameters
  Configure the gateway using initialization parameters.
• Optimizing Data Transfers Using Bulk Fetch
  You can optimize data transfers using bulk fetch.
• Optimizing Data Loads Using Parallel Load
  The DBMS_HS_PARALLEL PL/SQL package enables parallel processing when accessing heterogeneous targets.
• Registering Agents
  Registration is an operation through which Oracle stores information about an agent in the data dictionary.
• Oracle Database Server SQL Construct Processing
  Heterogeneous Services and the gateway rewrite SQL statements when the statements need to be translated or postprocessed.
• Executing User-Defined Functions on a Non-Oracle Database
  You can execute user-defined functions in a remote non-Oracle database.
• Using Synonyms to Provide Data Location and Network Transparency
  You can provide complete data location transparency and network transparency by using the synonym feature of the Oracle database server.
• Copying Data from the Oracle Database Server to the Non-Oracle Database System
  Heterogeneous Services supports callback links.
• Copying Data from the Non-Oracle Database System to the Oracle Database Server
  The CREATE TABLE statement lets you copy data from a non-Oracle database to the Oracle database.
• Heterogeneous Services Data Dictionary Views
  You can use the Heterogeneous Services data dictionary views to access information about Heterogeneous Services.
• Heterogeneous Services Dynamic Performance Views
  You can use dynamic performance views to access information in the Oracle database server.