Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Custom objects migration from OBIEE11g to OBIEE12c in OBI Apps

Received Response
11
Views
3
Comments
2845107
2845107 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hi Experts,

We are trying to move only custom objects present in both RPD and Catlog from OBIEE11g to OBIEE12c in OBI Apps.

Can we merge only the custom changes present in 11g into 12c. But the issue is since this is OBI Apps. the 11g OOTB and 12c OOTB is different as we are moving from Informatica to ODI.

So will merge work in our case and if not what alternate approach we can use?

Similarly for Catalog also we are assuming we have only option moving reports directly from 11g to 12c and after moving to 12c do a Scan and Update Catalog Objects That Require Updates which will automatically upgrade the catalog items from lower version to higher

Is there any other approach?

Please let me know.

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    I will give you my point of view about that ....

    Moving custom objects in the RPD between different versions of OBIA? I don't see a simple "2 clicks" way to do it as, you said it, there are differences in the base RPD itself as you moved from an Informatica OBIA to the ODI based OBIA.

    So you are doing all the possible migration you could fit in at once, and at some points you reached the limits ...

    If your custom objects are not related to OBIA then maybe you have them as an independent RPD which you can upgrade to 12c first and merge with your OBIA rpd after.

    If not I'm afraid your only solution is a copy/paste by hand, recreate your custom objects in the RPD manually checking if they still make sense etc.

    I really don't imagine a simpler way of managing that because of the too many different things between your 2 RPD.

  • 2845107
    2845107 Rank 4 - Community Specialist

    Thanks Gianni for the reply.

    Looks like we only have two options and that is manually recreate by looking into 11g rpd and copy/paste by hand wherever necessary.

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    Honestly I guess that's the less risky, with merges etc. you really can break something in the OBIA side of the RPD and this is probably worse ...