Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sybase/Oracle Connectivity

Re: Sybase/Oracle Connectivity

From: <paul_clare_at_my-dejanews.com>
Date: Fri, 21 May 1999 10:51:20 GMT
Message-ID: <7i3dr8$jgh$1@nnrp1.deja.com>


In article <37440108.8BBF22D2_at_vivi.com>,   Bruce Cota <bruce_at_vivi.com> wrote:
> Hi, we need to integrate an Oracle application with a Sybase
application. We're investigating any
> tools to help us -- especially tools for replicating data between one
server and the other.
> Thanks for any information.
>
> Bruce Cota
> Software Engineer
> Sandbox Entertainment
>
>

To perform real-time replication between Sybase & Oracle, you need Replication Server, Rep Agent for Oracle, DirectCONNECT, and, if the databases aren't on the same box, Server CIS enabled (or OmniCONNECT if you're running pre-11.5 Server versions). This product suite is great, but is designed around providing a platform-independant Enterprise interface solution. Hense it can get quite expensive. Running with many users ramps up the costs enormously - 50 users on such a set-up could put you back around $100K+.

Oracle does have a Sybase interface tool - OTG (Oracle Transparent Gateway), but I THINK it only allows you to see Sybase objects as Oracle objects across SQL-net (like DirectCONNECT), not to perform true replication. It is, however, much cheaper - around $20K, but we've had loads of problems with it, and it flatly doesn't work on some UNIX platforms (eg; IBM SP2). If you can afford it, definitely go with the Sybase Replication suite.

Paul J Clare,
Snr DBA,
L.E. plc.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 05:51:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US