Question
Accenture
IN
Last activity: 4 Apr 2016 7:59 EDT
Can we mask the confidential data and then export the data to other environment?
Scenario is as follow:
There may be certain confidential data in the blob, so if I want the work object to be exported from one environment to another environment.
But the data inside the work object should be replaced with some random character say 'abc' or 'xyz'.
Is there any OOB export feature available in pega?
P.S
I am Using Pega 7.1.7,and we run the application in IE 11
-
Like (0)
Pradeepa Sivakumar -
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
One
UA
âº
Pegasystems
IN
Should this apply to all properties or some properties in the BLOB? That said, how is the data currently being stored in the BLOB?
This link should be useful - https://pdn.pega.com/how-encrypt-passwords-properties-and-blobs
Accenture
IN
Only some properties needs to be masked, I don't want to store them encrypted in my database but I want to mask(change value of few properties) them when I am exporting.
So that when I import the work object, the values of the masked properties in the new environment are random characters rather than original data value.
Pegasystems Inc.
IN
Re: Encryption on Fields be of help?
Accenture
IN
I don't want to encrypt data I want to mask them when I move them from one environment to another.
Here masking means change their original value to some dummy value
Pegasystems
IN
I don't believe there is anything OOTB in Pega which allows you to do that.
Accenture
IN
okay, that needs to be customized then, is there any easy way for such customization.
I think pega should make something around this. As this would be the need for any origanizaton, as a confidential data from production should be exported with masking to non production environment.
Pegasystems
IN
The following enhancement request has been filed - FDBK-13720
Accenture
IN
The above link gives me an error.
The webpage cannot be found.
What does the above link does?
Pegasystems
IN
Oh that is an internal enhancement request number. This will be looked at by Pega product management and based on the need and priority, will be added to a future release. Note that mesh automatically puts the link for internal users to work with the tool that tracks it.
Isn't it good to handle these type of things outside PRPC? Here is an interesting article on masking production data (http://www.brentozar.com/archive/2011/09/how-do-you-mask-data/). An ideal data masking tool should also address four issues mentioned there.
Accenture
IN
can we export the clipboard page instead of the data in blob. If so then we can write our own mask the data using an activity and call the api that export the clipboard page that has the masked data
Pegasystems
IN
You can try using BIX to get all the properties in XML format. If you don't need all properties, XML & CSV option is available with BIX.
Accenture
IN
We can convert Page into xml using public API toXML(), can we convert xml back to page? If this can be done then we will be able to write the script that will do the masking âº
Pegasystems
IN
yes we can convert XML back to clipboard page
//
The ClipboardPage java API has JSON and XML conversion methods - adoptJSONObject, adoptJSONArray, and adoptXMLForm for populating a clipboard page with JSON/XML data, getJSON and getXML for converting the contents of a clipboard page to an JSON/XML string value.
//
Accenture
IN
Thanks will try and share the result âºâº
Pegasystems Inc.
IN
Hi, The Engineering Customer Success (ECS) team does have a utility which can help in doing a Data Masking. You can configure what properties to be masked and with what kind of algorithm, then the data would get masked accordingly.
Accenture
IN
What is the activity name ?
And how to use it ?
Can you please share some more information on this, or link that has information about this?
Pegasystems Inc.
IN
Hi, This is a collaboration tool built by Pega Engineering Customer Success (ECS) team. The tool is not officially supported by Pegasystems Inc. It is not available for public, rather you can make a request to our group through an email and we can take it forward. You can drop an email to Jeeva Ramachandran ([email protected]) and me ([email protected]) about it along with the usage / purpose of it.