Approaches to Encrypt Sensitive Columns in BIP Data Model Results

ManikandanRajagopalan

We are generating notification emails for referrers who have referred candidates in ORC. We are developing a page in Apex that allows referrers to upload recommendation letters. The email will include an Apex URL, which will be dynamically constructed from BIP.

The URL should be constructed using the host component and encrypted values from specific columns, such as the requisition number and candidate number. How can these column values be encrypted using a specific key in data model?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24325/approaches-to-encrypt-sensitive-columns-in-bip-data-model-results

Hi Mani,

There is no OOTB the way to achieve this in data model level. You may try to use requisition IDs and candidate IDs instead of numbers.

Thanks.