Question

1
Replies
509
Views
 Dennis Osegard (DENNISMO)
Unitedhealth Group, Inc.

Unitedhealth Group, Inc.
US
DENNISMO Member since 2011 1 post
Unitedhealth Group, Inc.
Posted: November 3, 2017
Last activity: November 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?

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 7 Nov 2017 2:13 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Technical Lead
Pegasystems Inc.
IN

Hi Dennis,


If you are looking to encrypt the Data you can follow below

https://pdn.pega.com/how-encrypt-passwords-properties-and-blobs/how-encrypt-passwords-properties-and-blobs


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