Re: Oracle Golden Gate
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 15 Jun 2011 14:54:15 +0100
Message-ID: <BANLkTikPuznOGwEjzExsQOPESksUBjBJSg_at_mail.gmail.com>
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.
Date: Wed, 15 Jun 2011 14:54:15 +0100
Message-ID: <BANLkTikPuznOGwEjzExsQOPESksUBjBJSg_at_mail.gmail.com>
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_at_braintreegroup.com>wrote:
> Hi
>
> Has anyone been able to do this with Golden Gate” join live queries from
> an Oracle database with data in an SQL database. “
>
>
>
> Thanks
>
> JR
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 15 2011 - 08:54:15 CDT