Database News

Posted Mar 10, 2005

Using Oracle's Heterogeneous Services

By DatabaseJournal.com Staff

[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

Database News Archives

0 Comments (click to add your comment)

Comment and Contribute

Latest Forum Threads
Database News Forum
Topic	By	Replies	Updated
Efficient SQL Server Indexing by Design	lcole	0	April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5	lcole	0	April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application	lcole	0	April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market	lcole	0	April 30th, 12:30 PM

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.