What is Oracle Transparent Gateways

Oracle Gateways FAQ

$Date: 20-May-2000 $
$Revision: 1.10 $
$Author: $

---

---

The Oracle Open Gateway product set (previously called SQL*Connect) is used to access data from non-Oracle databases (eg. DB/2, Sybase, Informix, etc), and even non-relational data sources like Adabas and file systems.

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 for more info.

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

---

• 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

---

• Database Gateways User's Guide