Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)
Learn how to access and install Gateway products.
How can I access my Oracle applications access data in a non-Oracle database system?
You can use Oracle Database Gateway as the connectivity tool to enable Oracle applications to access data in non-Oracle databases. The following are the functions of Oracle Database Gateway:
-
Integrates a non-Oracle database into your Oracle Database environment.
-
Enables Oracle PL/SQL applications to integrate with APPC-enabled transactions, or access messages in IBM Websphere MQ.
You can install the Gateway product on a computer independent of the Oracle application, Oracle database, and non-Oracle database.
For example, suppose you have the following scenario:
-
Oracle Database is installed on a Linux computer.
-
The Oracle application is installed on a Microsoft Windows computer and accesses data from the Oracle database on the Linux computer.
-
The Oracle application needs to join data in a DB2 database on Solaris Operating System and an Oracle Database on Linux.
You have the option of installing Oracle Database Gateway for DRDA on the Solaris computer where DB2 is running, on Linux where Oracle is running, or on a third computer.
Table G-1 lists the non-Oracle database systems that you can access from Oracle applications, and the Gateways products that are available for those systems.
Table G-1 Oracle Gateway Products