Delphix Products

Expand all | Collapse all

Masking Key Value Pair XML

Jump to Best Answer
  • 1.  Masking Key Value Pair XML

    Posted 05-17-2018 01:35:00 PM
    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


  • 2.  RE: Masking Key Value Pair XML
    Best Answer

    Posted 05-22-2018 10:48:00 PM
    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


  • 3.  RE: Masking Key Value Pair XML

    Posted 05-23-2018 03:55:00 AM
    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