OBIEE 12.2.1.3 to OAS 5.9 upgrade, security migration

Question

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.

Gianni Ceresa · Answer

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...

[Deleted User] · Answer

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.