Question

3
Replies
100
Views
SUBHAJIT7 Member since 2011 4 posts
Cognizant Technology Solutions
Posted: 2 years ago
Last activity: 2 years 5 months ago
Closed

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***

Data Integration SR Exists
Close popover
Moderation Team has archived post
Posted: 2 years ago

Hi Subhajit,


You can use UDF to do this.

Syntax goes here Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE


Thanks,

Ujjwal

Posted: 2 years ago

Hi Ujjwal,


I forgot to mention that the application is in P5.5.


So solution is needed for P5.5


Thanks & Regards,


Subhajit


 

Posted: 2 years ago

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
Share this page LinkedIn
Copied!