Question

7
Replies
400
Views
Close popover
Eugene Roytfeld (EugeneR7)
Deutsche Bank
Vice President
Deutsche Bank
US
EugeneR7 Member since 2013 30 posts
Deutsche Bank
Posted: February 14, 2019
Last activity: May 19, 2020

Data masking of pega blob content

Similar to previous question: https://community1.pega.com/community/product-support/question/data-masking-prod-data-non-prod-oracle-database

We have a requirement to mask pega blob data for preparation of non-prod environments. We have tried the approach of masking within pega as described, where you end up looping through the blob object structure, however this is incredibly inefficient and takes many days (for a 400gb work table, or maybe <100gb for an active request partition). Is there a more efficient way of achieving this? Blob encryption is not an option because data masking needs to prevent user from seeing content as well as prevent unmasked data from flowing through BIX.

Are there any scripting utilities which can do that (maybe via prpcUtils)?

Data Integration DevOps