Re: Using Oracle to facade Sybase

Oracle advertises a "transparent gateway product" here is one link I found.

Check there site for others. or the Oracle newsgroup. http://technet.oracle.com/products/gateways/faq.html#A698

andreww100_at_yahoo.com (Andrew Ward) wrote in message news:<613d30da.0203050340.37f66ab4_at_posting.google.com>...
> 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 - 10:17:57 CST