Question
Requirement : We need to scan the CID on Production database and anonymize them .
As Pega BLOB is not in a readable format , CS is unable to use their tool to have CID data anonymized.
Does Pega have any OTB database function which can be used by CS tool to scan the Pega BLOB ?
Thanks,
Subhajit
***Moderator Edit: Vidyaranjan | Updated Categories & tagged SR details***
Hi Ujjwal,
I forgot to mention that the application is in P5.5.
So solution is needed for P5.5
Thanks & Regards,
Subhajit
Hi Subhajit,
I dont have P5.5 at my end and hence would request you to check if Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE works at your end. (In case you have not tried)
If it does not, it means that pr_read_from_stream is not supported in P5.5.
I would suggest you to upgrade to Pega 7 to have a lot more capability at your disposal.
Thanks,
Ujjwal
Hi Subhajit,
You can use UDF to do this.
Syntax goes here Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE
Thanks,
Ujjwal