Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using Oracle to facade Sybase
Hi Andrew,
MetaMatrix can do this in a very flexible & straightforward manner. The Oracle tools will only let you pass through commands to the Sybase, our approach lets you integrate the two databases into a unified view - so the datamodels can be merged - in effect a virtual database.
This allows you to make a request to what looks like one database with a unified model & we will map that to both databases, integrate the results & return it to you. In fact the sources dont have to be databases - you can do the same with applications, files & even message systems like TIBCO & MQ.
Take a look at our website & leave a message for me - I'd be happy to show you how I can integrate your two databases in a few minutes. We call this a model driven approach to data integration.
Good luck.
Regards,
David Penney CTO - Europe http://www.metamatrix.com
"Andrew Ward" <andreww100_at_yahoo.com> 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 Wed Mar 06 2002 - 03:01:50 CST