Re: Using Oracle to facade Sybase

From: Andre van Winssen $andrew$ <andrew-no-spam-svp_at_info.nl>
Date: Tue, 5 Mar 2002 13:32:08 +0100
Message-ID: <3c84bac8$0$234$4d4ebb8e@news.nl.uu.net>

Hi,
this is the 2nd Andre I am answering today :-)

You can use database links that use HS for this purpose. It is described in the 8i Distributed Databases Systems guide. It boils down to following:
1) create an ODBC datasource that points to Sybase database 2) setup HS:
2a) create a file %oracle_home%\hs\admin\initgo2sybase.ora

       this should contain a line like
       HS_FDS_CONNECT_INFO = <name of datasource created in step 1)

2b) add an entry to your listener.ora file and restart/reload the listener, e.g.:
(SID_DESC=

  (SID_NAME=go2sybase)
  (ORACLE_HOME = E:\oracle\817EE)
  (PROGRAM=hsodbc))

3) create a database link, e.g.:
CREATE DATABASE LINK mysybase
CONNECT TO sybase user IDENTIFIED BY sybase user password USING

'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<oracleserver>)(PORT=1521))(CONNE CT_DATA=(SID=go2sybase))(HS=))'

4) run queries that reference the database link., e.g. SELECT * FROM TABLE_at_mysybase;

And yes, it might be a good idea to take snapshots of the sybase tables in your oracle database and run the joins using that snapshot.

Regards,
Andre van Winssen

"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 Tue Mar 05 2002 - 06:32:08 CST