1 Introduction to the Oracle Database Gateway for Sybase
Oracle Database Gateways provide the ability to transparently access data residing in a non-Oracle system from an Oracle environment. The following sections briefly covers Heterogeneous Services, the technology on which the Oracle Database Gateway for Sybase is based.
To get a good understanding of generic gateway technology, Heterogeneous Services, and how Oracle Database Gateways fit in the picture, refer to the Oracle Database Heterogeneous Connectivity User's Guide first.
- Overview of Oracle Database Gateways
Heterogeneous data access is a problem that affects a lot of companies. A lot of companies run several different database systems. Each of these systems stores data and has a set of applications that run against it. - About Heterogeneous Services Technology
Heterogeneous Services provides the generic technology for connecting to non-Oracle systems. As an integrated component of the database, Heterogeneous Services can exploit features of the database, such as the powerful SQL parsing and distributed optimization capabilities. - About Oracle Database Gateway for Sybase
The capabilities, SQL mappings, data type conversions, and interface to the remote non-Oracle system are contained in the gateway. The gateway interacts with Heterogeneous Services to provide the transparent connectivity between Oracle and non-Oracle systems.