Using Oracle to facade Sybase

Hi

Does anyone know if Oracle can be made to pass queries through to a Sybase server?

We have a third party application that requires a Oracle database. Today some of the required data (a few tables worth) is held in a Sybase database. Is it possible for Oracle to pass queries for that data on to Sybase?

For example,

1. The third party app issues the following request to Oracle (eg, SELECT * FROM XYZ)
2. Oracle passes the select query through to Sybase
3. Sybase returns rows to Oracle
4. Oracle returns rows to the third party app.

I assume DBLink is Oracle to Oracle only?

I am told that Sybase OpenServer allowed for pass through queries between Sybase databases.

(I'm sure that joins between real Oracle tables and Sybase facaded tables would cause lots of performance issues - even if it worked?)

Any help gratefully received

Thanks

Andrew Received on Tue Mar 05 2002 - 05:40:49 CST