Oracle Database 10g added
support for remote functions in non-Oracle databases embedded in SELECT
statements. Oracle Database 11g adds new Gateways to connect to Adabas, IMS,
and VSAM data stores.
Procedural Gateways
Procedural Gateways implement remote procedure calls (RPCs) to applications
built on non-Oracle data stores. The Gateway for APPC, the standard IBM protocol
for RPCs, is used when Oracle applications need procedural access to
Figure 13-1. Typical configuration and use of Transparent Gateways
Oracle SQL
Results
Other Database SQL
Client Oracle Database
with Transparent
Gateway
Other Database
Server
308 | Chapter 13: Oracle Distributed Databases and Distributed Data
applications built on CICS, DB2, IMS, VSAM, and other data stores on the mainframe
and applications that use SNA LU6.2 to communicate to the mainframe. The
Oracle Procedural Gateway for IBM MQSeries allows Oracle-based applications to
exchange messages with applications that communicate via MQSeries message
queues. Both are included with the Oracle Enterprise Integration Gateways.
Pages:
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669