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)?
Pegasystems Inc.
US
@ChaitraKamaraju - Can you assist @EugeneR87 ? Appears you may have supported teams in past with similar scenario based on some materials I was reading in the archived MESH
Pegasystems Inc.
US
CC: KevinZheng_GCS - looks like you have comment on similar thread - can you comment?
Pegasystems Inc.
IN
We did a build a PoC tool which can do data masking for identified properties, like PII related. The primary intent behind the PoC tool was to mask the data when the data is being replicated from higher environments to lower environments.
In your scenario, I read that you are looking for encryption in the same environment, and it is all the data. Have you considered the DB level encryption options ?
Deutsche Bank
US
Could you provide more information on this PoC tool? It seems like something that covers what I'm looking for.
In my scenario, i'm specifically not looking for encryption, as we need to data on an (any) environment masked. We do full schema backup and restore, so we don't necessarily care whether we mask data on same environment, or replicate with masking to a different environment, as long as the blob content (selective set of properties deemed relevant for masking) is masked.
NAB
AU
Hi @ChaitraKVL, is there a way we can get access to this POC to try out in our private cloud environment please?
Mercedes-Benz Auto Finance Ltd.
CN
We have the similar requirement from Mercedes-Benz Financial China. Would like seek for an efficient approach to mask the customer related data columns from database level including blob columns in lower environment. Is there any feasible solution or Poc?