Using Oracle's Heterogeneous Services

March 10, 2005

Using Oracle to access external, non-Oracle databases transparently can be tricky. We show you how.

Oracle's Heterogeneous Services layer is a way for an Oracle database server to access data on external, non-Oracle databases transparently using Oracle. For example, you can configure Heterogeneous Services and SQL*Net to access a Microsoft Access database through ODBC or OLE DB. Afterwards, you can query the table as if it were in a remote Oracle database:

The article continues at http://uk.builder.com/architecture/db/0,39026552,39239577,00.htm