RE: Oracle Golden Gate

  • From: Michael Dinh <mdinh@xxxxxxxxx>
  • To: "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>, "jreid@xxxxxxxxxxxxxxxxxx" <jreid@xxxxxxxxxxxxxxxxxx>
  • Date: Thu, 16 Jun 2011 06:10:23 -0700

Take a look at Heterogeneous Services.

Done this once before in 9i and it was not bad at all.
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Niall Litchfield [niall.litchfield@xxxxxxxxx]
Sent: Wednesday, June 15, 2011 6:54 AM
To: jreid@xxxxxxxxxxxxxxxxxx
Subject: Re: Oracle Golden Gate

Golden Gate is a replication technology, not a distributed query technology, 
you'd want linked servers (in MSSQL) or database gateways (in Oracle) to do 
joins across different RDBMS instances on different platforms. This is , 
generally, rather slow.

On Wed, Jun 15, 2011 at 1:16 AM, Joseph Reid 
<jreid@xxxxxxxxxxxxxxxxxx<mailto:jreid@xxxxxxxxxxxxxxxxxx>> wrote:
Has anyone been able to do this with Golden Gate” join live queries from an 
Oracle database with data in an SQL database. “


Niall Litchfield
Oracle DBA

Other related posts: