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

Replication from one OBIEE instances to another (mainly data visualization contents)

Received Response
41
Views
10
Comments
Mostafizur Rahman
Mostafizur Rahman Rank 3 - Community Apprentice
edited Aug 13, 2024 5:35PM in Oracle Analytics Cloud and Server

I want to replicate everything like catalog,rpd,data visualiztion (connection with password,dataset,dataflow,sequence,my folder contents of all user) from one obiee instances to another. Is there any way to replicate in real time or one time?

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Try BI Archive files - https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2067513_1.html

  • Mostafizur Rahman
    Mostafizur Rahman Rank 3 - Community Apprentice

    Is there any way to replicate real time?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Setup a cluster with 2 nodes.

    Or look into the possible options for high availability and disaster recovery in the doc (they cover few scenarios).

  • Joel
    Joel Rank 8 - Analytics Strategist

    Active-Passive Model

    https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-261C278C-EA9E-4BE5-9216-FEFED1418FE6.htm#BIESG3457

  • Mostafizur Rahman
    Mostafizur Rahman Rank 3 - Community Apprentice

    Actually my scenario is I have two different site having two different repo db. In that case what should i do?

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Mostafizur Rahman wrote:In that case what should i do?

    Define exactly what in the target you expect to achieve and for which reason. Based on that you identify how to technically get there.

    There are many ways to do many things, if we list them all we can keep going for a while and maybe none of those things would really be an answer of your need.

    When you ask about real time replication of RPD + catalog + any other metadata apparently for something which seem to be 2 independent installs, there are still bunch of things you are missing. You copy the whole catalog it comes with a security set on it, but the second environment doesn't have the same security objects defined etc. There are too many things which are "wrong" or "will go wrong".

    So do a step back, define what is your final target and the reason you wanted it and, based on that, answers will be more adapted.

  • Mostafizur Rahman
    Mostafizur Rahman Rank 3 - Community Apprentice

    I have two different site(suppose SITE A and SITE B) having completely two different obiee instances(repo also). If an user  creates an analysis,connection,dataset,dataflow,sequnece on SITE A, it should be replicated to SITE B. If for any reason SITE A goes down, I simply point my application to SITE B. User get all the things what he has done in SITE A though he is in SITE B.

  • Joel
    Joel Rank 8 - Analytics Strategist

    what are the differences between the rpd in sites A & B?

  • Mostafizur Rahman
    Mostafizur Rahman Rank 3 - Community Apprentice

    rpd,catalog,security model should be same in both the site.

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

    There is no automagical synching of two different and distinct OBI instances.

    Joel told you BAR files - that's one approach. it will contain RPD, catalog and security setup (in terms of application roles and application policies etc).