|Oracle Transparent Gateways Using Transparent Gateways with Oracle9i Application Server
Part Number A88729-01
Part No. A88729-01
Oracle offers two solutions for integrating data from non-Oracle systems with data stored in an Oracle database. They are Generic Connectivity and Oracle Transparent Gateways. These solutions provide the ability to transparently access data stored in non-Oracle systems creating the appearance that all of the data resides within a local Oracle database server. Generic Connectivity uses the ODBC or OLE DB standards for accessing the non-Oracle systems. Oracle Transparent Gateways are agents designed specifically for a particular non-Oracle system. Both solutions extend Oracle9i Application Server functionality to non-Oracle systems.
This document discusses the following topics:
The following figures illustrate the path of a client request to either the Oracle or non-Oracle system. Figure 1 shows the path using Generic Connectivity and Figure 2 shows the path using Transparent Gateways.
This figure shows a client making a request for data to Oracle HTTP Server. The server forwards the data request to the Cache Router running in Oracle Database Cache. The cache router determines if the request is for data from an Oracle database or non-Oracle system. If the data is in an Oracle database, the router determines if the data is in the cache or in the back end database and forwards the request accordingly.
If the request is for data in a non-Oracle system, Cache Router forwards the request to Heterogeneous Services -- the generic technology for accessing non-Oracle systems. In the Generic Connectivity case, Heterogeneous Services forwards the request to the HS ODBC or OLE DB agent which handles all communication with either the ODBC or OLE DB driver. The driver transforms the request into a form that the non-Oracle database can process.
The Transparent Gateway scenario follows the same path as that for Generic Connectivity. The only difference is Heterogeneous Services forwards the request to a transparent gateway running on the non-Oracle system. The gateway routes the request to the non-Oracle database.
For installation instructions refer to the Oracle Transparent Gateway documentation for your non-Oracle database on Oracle9i Application Server Disc 1.
When installing a Transparent Gateway, you must:
This section describes configuring a Oracle Server instance and Oracle Database Cache for use with Transparent Gateways and Generic Connectivity.
By creating the same database links and synonyms in both Oracle Server and Oracle Database Cache, you can deploy the same applications to either tier without any changes.
Heterogeneous Services makes a non-Oracle system appear as a remote Oracle database server. To access or manipulate tables or to execute procedures in the non-Oracle system, create a database link that specifies the connect descriptor for the non-Oracle database. Use the following syntax to create a link to the non-Oracle system:
Synonyms are useful because they hide the identity of the underlying object, including its location in a distributed environment. Use the following syntax to create a synonym for an object in the non-Oracle system:
For configuration instructions refer to the Oracle Transparent Gateway documentation for your non-Oracle database on Oracle9i Application Server Disc 1.