Introduced in Oracle 9i, the Heterogeneous Services component of the Oracle database and the database gateways enables synchronous data integration between Oracle and non-Oracle databases in a transparent manner. The main advantage of this Oracle solution is that the database developers do not need to customize the applications based on the databases they are trying to access from an Oracle database-based application, in terms of using different APIs for different databases. Oracle enables the use of the same SQL dialect for all non-Oracle databases as Oracle. These gateways are optimized for the databases that they connect to and provide an end-to-end solution for integration with non-Oracle systems.
There are many benefits of an Oracle heterogeneous connectivity solution, including:
Consistent set of APIs (Oracle) for access to non-Oracle systems
Access to objects from non-Oracle systems in SQL Statements, views, triggers, stored procedures, and so on, without...