Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Dennis Osegard (DENNISMO)
Unitedhealth Group, Inc.

Unitedhealth Group, Inc.
US
DENNISMO Member since 2011 1 post
Unitedhealth Group, Inc.
Posted: Nov 3, 2017
Last activity: Nov 7, 2017
Posted: 3 Nov 2017 16:25 EDT
Last activity: 7 Nov 2017 2:13 EST
Closed

Data masking of Prod data in a non-prod Oracle Database

I have a need to load prod data in an Oracle 12c Database that contains PHI and PII data (names, addresses, etc.) into a non-prod (Stage) environment Oracle 12c Database to support performance testing. The applicable PHI and PII data will need to be masked after it is loaded into the Stage environment. Some of the data needing masking (scrambling) is in a Blob. What recommendations are there for masking software to use and the overall approach to solving this issue?

To see attachments, please log in.
Data Integration

Posted: 7 years ago
Posted: 7 Nov 2017 2:13 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi Dennis,

If you are looking to encrypt the Data you can follow below
https://docs-previous.pega.com/security/85/creating-custom-cipher

If you are looking to just randomly change the Data, you can create an Activity and use ObjBrowse and loop through all the records and change the value of required properties.
Obj save post this would commit changes in the BLOB.

Regards,
Ujjwal

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice