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 reverse engineer user-role mapping in OBIEE 11g to OBIEE 12C

Received Response
11
Views
5
Comments
Srinaath Kathirvelu Saroja-Oracle
Srinaath Kathirvelu Saroja-Oracle Rank 1 - Community Starter
edited Aug 13, 2024 6:02PM in Oracle Analytics Cloud and Server

How to reverse engineer user-role mapping in OBIEE 11g to OBIEE 12C


Fresh OBIEE 12c installation
Migrated  wls-users from existing OBIEE 11g Production to new OBIEE 12c Production
Migrated RPD & Webcat from existsing OBIEE 11g Test to new OBIEE 12c Production

Then we have everything execpt to user-role mapping.
Since we have about 25 roles and 75 users we would like have  an easy path to get that from existing OBIEE 11g Production to new OBIEE 12c Production

Using the 11g GUI we can only examine one role at the time and display to users belonging to it in a 4 row windows on that page.

That makes it unusable to reverse engineer the current user-role mapping.

Is there a tool for that?
Or in which table(s) is that information present?
Or in which files is that information present?

Your feedback is much appreciated.

Thanks in advance,
Regards,
Srinaath KS

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you google for it you must find WLST scripts around for that kind of work (WLST = weblogic scripting tool).

    It allow you to automate what you can do in the GUI and a lot more.

    It also depends if you had embedded LDAP users mapped directly to app roles or users were part of groups which were then mapped to roles.

    If the first one the mapping you must also be able to see it in the system-jazn-data.xml file of your 11g system (which was contained in the migration JAR and was supposed to be deployed, so I imagine you didn't deploy the full migration JAR? ).

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

    @Gianni Ceresa Even just a BAR contains the jaz

    @Srinaath Kathirvelu Saroja-Oracle as Gianni said you'll need to WLST script if you don't use the migration tool. If you're feeling hacky and brave you can also start extracing parts from the 11g jazn and inject into the 12c jazn.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Hello Srinaath,

    Did you use OBIEE 11g to 12c migration process? i.e. creation of 11g Export Bundle JAR file and then importing the same into your OBIEE 12c environment, because if you do so then Application Roles along with RPD and Catalog is migrated as well, with catalog groups converted to application roles from OBIEE 12.2.1.1.0 and above.

    If your users are in External LDAP then you need to reconfigure the same in OBIEE 12c environment, for Embedded LDAP users you need to migrate them manually as you have already done.


    Please refer to below mentioned link for more information on above stated points:

    https://docs.oracle.com/middleware/12211/lcm/BIMIG/GUID-D0867450-1AEF-43DE-8144-7816F7105CB1.htm#BIMIG-GUID-D0867450-1AEF-43DE-8144-7816F7105CB1

    Thanks and Regards,

    Syed Hamd Salman

  • Srinaath Kathirvelu Saroja-Oracle
    Srinaath Kathirvelu Saroja-Oracle Rank 1 - Community Starter

    Thanks to every one  for your you valuable time and feedback.

    Tried the official OBIEE 11g to 12c migration process, but that didn't work.

    We used wlst scripts to convert the user-role mapping

    Regards,

    Srinaath KS

  • Gianni Ceresa
    Gianni Ceresa Mod

    So you can now close the thread I guess ...

    For now it's still " This question is Not Answered. " and by closing it you will help others with the same / similar needs.