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

OBIEE 12.2.1.3 to OAS 5.9 upgrade, security migration

Received Response
3
Views
2
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Aug 13, 2024 5:12PM in Oracle Analytics Cloud and Server

Hi Gurus,

We are on our way to moving to OAS 5.9 from OBIEE 12c. In 12c we are on Argus/Novell authentication security mechanism, and decided to move to Active Directory once in OAS.

We have around 30,000 reports and thousands of users working on them. Is there a way we could migrate the security instead of manually assigning permissions to each report/dashboard which seems to take forever...

Thanks in advance.

Answers

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

    Define "migrate the security". Security integration config in the WLS backend? Or security translation into App Roles in EM?

    The former you have to do again since you switch tech, that's clear. The latter you can migrate using WLST or just the migration bundle.

  • Gianni Ceresa
    Gianni Ceresa Mod

    We have around 30,000 reports and thousands of users working on them. Is there a way we could migrate the security instead of manually assigning permissions to each report/dashboard which seems to take forever...

    While I don't know if Argus/Novell had something special, the security in your catalog was already group/user based in your 12c.

    If your question is how to deal with a change of user identifier (for example if the same user is identified differently with Active Directory than with your previous setup, like a different username format or email or whatever), there are ways to script a replacement of identifiers in various places depending on the needs. As long as you have a rule or a way to map old to new identifiers of course...