8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | Linux

Home » Articles » Misc » Here

Heterogeneous Services - Generic Connectivity

Oracle supports heterogeneous services to allow data in non-Oracle database to be queried using SQL. This support has been in the form of transparent gateways, which are vendor specific, or generic connectivity which uses ODBC or OLEDB to make the connections. The functionality supported by generic connectivity is typically more limited than that possible when using vendor specific gateways, but it is quick and simple to configure. The steps listed below can be used to connect Oracle to any ODBC compliant database (MS Access, SQL Server, MySQL etc.).

In the following example, "SQLSERVER1" is the ODBC Data Source Name (DSN) of the non-Oracle database.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.