Thursday, May 29, 2014

[OBIEE] [QlikView] Tapping OBIEE Security for Qlikview use | Convert OBIEE Security to Qlikview understandable-format Security

OBIEE security mention here is referring to object based security (securing the OBIEE presentation column)
Qlikview security mention here is referring to section access.

Background:
OBIEE is a BI tool from Oracle.
Qlikview is also a BI tool, but from different company, named QlikTech.
The requirement to tap/convert OBIEE security to Qlikview security is not really a common one, but it does happen to me during my project.
The OBIEE is setup to secure the object (object based security), and all the settings is setup manually on the repository itself and not pointing/coming from any database

The method here is working and tested for:
OBIEE 11g

In summary, here's how to convert the security:
1. Extract security access based from OBIEE repository
2. Extract user and group list from WebLogic
3. Convert security access from OBIEE security to CSV format
4. Reverse the security access
5. Convert user and group list from WebLogic to CSV format

Details will be updated later.

No comments: