We have requirement to Mask the data in blob for cases in production and import them to lower environments.
But this should not affect the actual Production cases, for which a cloned DB is used.
Is there a DB Utility available OOTB which can help us Mask the data in blob before we export this to non prod environment ?
First need to take the production db back up and move it to lower environment.
next sit with a dba and see which are the columns u have pii data and make sure u extract all columns
there several functions in db to mask data and you can use them to mask the data in db tables.
coming to your question about blob it is basically already encrypted and stored you can write an activity to mask the values inside blob and run a ota to all the cases which will update the necessary columns masked as your need
@BhanuPrasanthT Thanks for the valuable response . Even I also thought of same approach, but looking for something that would help us mask the data in the backed-up prod data and then we don’t need to do anything post we import it to lower environments.
Is there any DB utility from Pega which can help us update blob data in db directly, without writing any activity from Pega ?
@AmolT17060258 there is no out-of-the-box utility from Pega to directly update blob data in the database. The blob data in Pega is stored in a proprietary format and is typically accessed and manipulated through Pega activities and functions. Direct manipulation of blob data outside of Pega is not recommended or supported due to the complexity and potential for data corruption.
This is a GenAI-powered tool. All generated answers require validation against the provided references.
Is there a quick option to modify the content of blob xml after database copy?
How to show blob data in an editable report in Pega 5.5 where I don’t have report definition?
Please can you mark @BhanuPrasanthT’s reply with Accepted Solution?