Select Page

Art of BI: OBIEE 11g RPD Encryption is HomeGrown?

Christian Screen | | April 23, 2011

A client recently asked me to find some information regarding the security algorithm used to encrypt the RPD in OBIEE 11g.  After some investigation and attempts at trying to identify the encryption patterns, I came across a section in the Oracle BI 11g documentation for encryption in presentation services.   A segment of this particular section goes on to say…

“Finally, a proprietary key-based encryption provides security to prevent unauthorized users from accessing the metadata repository.”

Well there is your answer, it is a proprietary encryption algorithm.  This leads me to believe that the algorithm applied to the repository (RPD), utilizing the repository password most likely as a hash key, is most likely something like DES.  No matter what algorithm really is I believe encrypting the repository in OBI 11g was a brilliant idea.

My opinion is that the RPD encryption is just a deterrent rather than an actual attempt at mission critical security lock-down.   Because, if a professional hacker was able to get into your system and get at your RPD, chances are they would already be able to access a myriad of other sensitive bits of information and data, making the compromise of your RPD the least of your concerns.

References:

http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/authentication.htm#BABBIBBI

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS