Delphix Products

We are trying to mask some XML, and some of the sensitive data is contained in a repeating key/value pair structure.

        <tns:ContentProperties>
          <tns:contentPropertyKey>Policy Account Number</tns:contentPropertyKey>
          <tns:contentPropertyValue>A240004266</tns:contentPropertyValue>
        </tns:ContentProperties>
        <tns:ContentProperties>
          <tns:contentPropertyKey>Policy Number</tns:contentPropertyKey>
          <tns:contentPropertyValue>924111602240</tns:contentPropertyValue>
        </tns:ContentProperties>
        <tns:ContentProperties>
          <tns:contentPropertyKey>State</tns:contentPropertyKey>
          <tns:contentPropertyValue>NE</tns:contentPropertyValue>
        </tns:ContentProperties>

In this case we'd like to mask the Account and policy, but not the state. since the actual data value is in the generic "contentPropertyValue" element, I cannot easily mask only the fields I want to.

Is there a good way of doing this in the masking engine?

Thanks

Peter
#Masking

Hi Peter, 

The masking engine does not have the capability of distinguishing between key value pairs. To mask that type of structure you are going to need to pre-process the file into an XML format that the masking engine can digest, mask it, and then post-process the file to return it to its original format - using something like XSLT. 

Best,
David

Hi Peter, Just to complete David’s answer, the pre and post process have to take place out of the masking engine as there no ability to declare a pre-script and post-script for file masking job like you have for database ones. Regards, Mouhssine