Re: Heterogeneous Replication

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Thu, 29 Jan 2004 18:06:28 -0800 (PST)
Message-ID: <20040130020628.33051.qmail@web60501.mail.yahoo.com>

Hi,

We(I) configured ~20 ODBC connections using Oracle Generic Heterogeneous Services (HS). I hated it because we were dynamically adding-dropping connections every couple weeks, which is a manual configuration process on the server (updating config files, processes, etc).

I found Generic HS had syntax incompatibilities that hung cursors on DB_LINKS based on incompatible SQL statements (which I had to protect using views). At one point I figured out a couple tricks to flush the DB_LINK connection and recover cursors, but I forgot them now.

We ended up using an ETL tool instead to bridge databases, and I think Oracle's gateway products might also be something to check out. Maybe others had better luck with a particular flavor of HS, but not Generic.

That's my opinion. Good luck.

Regards,

Mike Thomas

Nikhil Khimani <nkhimani_at_marketaxess.com> wrote:
> L&G,
>
> We are looking at replicating data from Oracle
> (8.1.7.0 and 9.2.0.4) to
> MS-SQL (2K). I would like to know if anyone has done
> this using
> heterogeneous services and if yes would you please
> get me started at least
> with the right links to RTFM. Anything additional
> will be gravy. We are also
> looking at Golden Gate solutions (for Oracle to
> MS-SQL) and I'd appreciate a
> feed-back, if anyone has had any experience with it.
>

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jan 29 2004 - 20:06:28 CST