Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to refer data from OBIEE database to Oracle(EBS) database

Received Response
1
Views
6
Comments
Affy
Affy Rank 1 - Community Starter
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

Hi,

I have to frequently refer OBIEE data (which is in a separate database) in oracle database (another database), both are in different database

Please suggest me the best approach/suggestion (db links, clone data etc...)

Thanks,

Affy

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    OBIEE 'has no' data ... not sure what you are asking

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    as @Thomas Dodds says, OBIEE doesn't have an DB.

    Probably what you are asking is how you can relate informations coming from multiple databases.

    Theoretically OBIEE can do it (and it does) however if you fetch large volumes of data from different database and join them all the process is done by the BIServer instead of being pushed to the database.

    The optimal solution depends on multiple factors including what your DBAs will allow you to do (e.g. DB Links could not be allowed).

    Please provide more details in order for us to help.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Agreed - cross database joins are a performance killer for OBIEE ...  the BI Server is good, but it's going to fetch more rows than maybe needed ... network traffic up, amount of memory need in BI Server up and time to deliver results to screen up. 

    Federate / integrate your databases where you need to ...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What does that mean? "refer OBIEE data to in oracle database"?!

  • Affy
    Affy Rank 1 - Community Starter

    Hi Berg, First of All apologies for my unclear question. I actually meant how can we refer data coming from multiple databases, As FTisiot and Dodds Suggested, I will have to check with DBAs and go for the optimal solution

    Thanks FTisiot, Dodds and Berg for your valuable time

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi @Affy

    If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.