Oracle Gateways FAQ

$Date: 20-May-2000 $
$Revision: 1.10 $
$Author: Frank Naudé $

Topics

Oracle Open Gateways can be divided into 4 categories:

• Transparent Gateways
• Procedural Gateways
• Access Managers
• Oracle Replication Servers

Transparent Gateways are most commonly used and enable access to non-Oracle data sources as if they were Oracle databases. They allow you to interact with these foreign databases without regard to differences in SQL implementation and with the added ability to perform distributed processing.

Procedural Gateways are used to integrate with non-ralational data sources. Normally a toolkit is used to map foreign database functions to PL/SQL stored procedures. These PL/SQL procedures can be called from any Oracle product like Oracle Forms and SQL*Plus.

Access Managers are exclusively used on IBM's AS/400 and MVS platforms and allows products like CICS to interact with Oracle and other IBM data sources like IMS. Look at the Oracle/MVS FAQ for more info.

Replication Servers support heterogenious data replication. For Oracle to Oracle replication, see the Oracle Replication FAQ.

• ODBC Gateway
• Microsoft SQL Server
• Informix
• Sybase
• IBM DB2
• IBM DB2/400
• IBM DRDA
• EDA SQL
• etc...

• Procedural Gateway for APPC
• Procedural Gateway for MQSeries

• IBM CICS
• IBM IMS/TM
• IBM AS/400

• Oracle Replication Server for IBM's DataPropagator

• Oracle's Gateways Home Page

• Database Gateways User's Guide