Using Oracle's Heterogeneous Services
March 10, 2005[From Builder UK]
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