FAQ
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

Search Discussions

  • John Garmany at Jun 15, 2011 at 1:46 am
    What are you trying to do? Golden Gate mines redo for changes and
    replicates the changes. It can replicate Oracle changes to a SQL
    database or any other supported database. What do you mean by "join a
    live query"?

    John
    On 6/14/2011 6:16 PM, Joseph Reid 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
    --
    http://www.freelists.org/webpage/oracle-l
  • Guenadi Jilevski at Jun 15, 2011 at 10:37 am
    Hi,

    You can replicate the Ms SQL tables across to the Oracle database. Once
    tables are replicated you can join them in the usual manner.

    Regards,

    Guenadi Jilevski
    On Wed, Jun 15, 2011 at 3:16 AM, Joseph Reid 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
    --
    http://www.freelists.org/webpage/oracle-l
  • Niall Litchfield at Jun 15, 2011 at 1:54 pm
    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 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-l
  • Job Miller at Jun 15, 2011 at 4:43 pm
    This is the role of the BI Server, which can be bought independently from the BI tool set, and is more target neutral than DB gateways.  the BI Server itself is a "Virtual" ODBC data source to multiple types of data sources, so it processes joins in middleware.
    Â
    Snippet from an event last year..
    Â
    http://obieetalk.com/inside-oracle-bi-server-part-1-bi-server-architecture
    Â

    The session that I’m giving at the BI Forum in Brighton in May is entitled “Inside the Oracle BI Server”, and I’m aiming to take a closer look at the architecture and functionality of this key OBIEE component. We’re all fairly aware of what the BI Server does at a high level, but I thought it’d be interesting to take a closer look at what the BI Server does, particularly when it parses queries and joins datasets together.
    Â
    At a very high level, the main function of the BI Server is to process inbound SQL requests against against a virtual database model, build and execute one or more physical database queries, process the data and then return it to users. The BI Server is one part of the Oracle BI Enterprise Edition Plus product family, and presents itself to query tools as one or more databases in a simple relational (star schema) model, that can then point to a much more complex set of relational, multidimensional, file and XML data sources (and in 11g, ADF objects).
    Â
    Taking the standard OBIEE architecture diagram, the BI Server sits in the middle of the OBIEE set of servers and provides the query capability, security, interfaces to data sources and calculation logic for OBIEE (all of this is based on the current, 10g set of products).
    Â

    Â
  • Michael Dinh at Jun 16, 2011 at 1:10 pm
    Take a look at Heterogeneous Services.

    Done this once before in 9i and it was not bad at all.

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/ds_concepts001.htm#ADMIN12079

    From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield [niall.litchfield_at_gmail.com]
    Sent: Wednesday, June 15, 2011 6:54 AM
    To: jreid_at_braintreegroup.com
    Cc: ORACLE-L
    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 > 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 15, '11 at 12:16a
activeJun 16, '11 at 1:10p
posts6
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase