Delphix Products

 View Only

  • 1.  XML Attribute Masking

    Posted 09-06-2023 01:04:00 PM

    I am aware that it is possible to mask the data in an XML element but is it possible to mask the attribute of an element?

    Example: Is it possible to mask the highlighted value in the XML below?

    <row id='51-1120075'>

      <c1>US0010001*200146</c1>

    </row>



    ------------------------------
    Mahesh Chandran
    Delphix Community Members
    ------------------------------


  • 2.  RE: XML Attribute Masking

    Posted 09-06-2023 04:54:00 PM
    Hi Mahesh,

    I did a quick test with the XML format below, the 2nd block below is the masked data for First, Last, Building and Room.  Is this what you are looking for?

    [root@oratarget tmp]# cat xmlfile.xml
    <?xml version="1.0" encoding="UTF-8"?>
    <?xml-stylesheet type='text/xsl'?>
    <employees>
        <details>
            <firstname>Shiv</firstname>
            <lastname>Mishra</lastname>
            <title>Engineer</title>
            <division>Computer</division>
            <building>301</building>
            <room>11</room>
        </details>
        <details>
            <firstname>Yuh</firstname>
            <lastname>Datta</lastname>
            <title>developer</title>
            <division>Computer</division>
            <building>303</building>
            <room>02</room>
        </details>
        <details>
            <firstname>Rahil</firstname>
            <lastname>Khan</lastname>
            <title>Tester</title>
            <division>Computer</division>
            <building>304</building>
            <room>10</room>
        </details>
        <details>
            <firstname>Deep</firstname>
            <lastname>Parekh</lastname>
            <title>Designer</title>
            <division>Computer</division>
            <building>305</building>
            <room>14</room>
        </details>

    </employees>

    [root@oratarget tmp]# cat xmlfile.xml
    <?xml version="1.0" encoding="UTF-8" ?>
    <?xml-stylesheet type='text/xsl'?>
    <employees>
        <details>
    <firstname>Charlette</firstname>
    <lastname>Cheffer</lastname>
    <title>Engineer</title>
    <division>Computer</division>
    <building>478</building>
    <room>54</room>
        </details>
        <details>
    <firstname>Will</firstname>
    <lastname>Delapp</lastname>
    <title>developer</title>
    <division>Computer</division>
    <building>189</building>
    <room>63</room>
        </details>
        <details>
    <firstname>Meghan</firstname>
    <lastname>Rediger</lastname>
    <title>Tester</title>
    <division>Computer</division>
    <building>915</building>
    <room>12</room><
         /details>
        <details>
    <firstname>Jackie</firstname>
    <lastname>Rogacki</lastname>
    <title>Designer</title>
    <division>Computer</division>
    <building>072</building>
    <room>28</room></details>

    </employees>

    ROBΞRT HΞNNING

    Principal Solutions Engineer
    		(215) 764-0815
    		robert.henning@delphix.com
    		www.delphix.com
    		Greater Washington, DC
    facebook
    		twitter
    		linkedin





    Original Message


  • 3.  RE: XML Attribute Masking

    Posted 09-06-2023 07:19:00 PM

    The sample that you have provided, masks the data within the element. My question is about the attribute of a tag. Reiterating the example as mentioned in my post earlier,

    Is it possible to mask the highlighted value in the XML sample below?

    <row id='51-1120075'>

      <c1>US0010001*200146</c1>

    </row>



    ------------------------------
    Mahesh Chandran
    Delphix Community Members
    ------------------------------

    Original Message


  • 4.  RE: XML Attribute Masking

    Posted 09-06-2023 07:41:00 PM
    Edited by Robert Henning 09-06-2023 07:45:58 PM

    Hi Mahesh,

         Thanks for the clarification.  Out of the box when you create and provide the file format, only the elements have an algorithm associated in the inventory, (see screenshot below).

        

         Our Professional Services team has developed a suite of Masking algorithm SDK plugins, including an XML framework from what I've researched that should solve this use case.  I am notifying @Tino Pironti @Marcin Przepiorowski @Moushssine Saidi here to guide you in the right direction.

    Thanks for reaching out,

    ------------------------------
    Robert Henning
    Principal Solutions Engineer
    Delphix
    ------------------------------

    Original Message


  • 5.  RE: XML Attribute Masking
    Best Answer

    Posted 09-07-2023 04:34:00 AM

    I am not sure if the product XML feature can mask the attribute .. it would "show" in the user interface as an "element" with name "id" ..

    In any case Delphix PS offer a customised XML plugin that can mask any XML attribute and supports even complex Xpath queries.

    Please get in touch with your Delphix representative and request Professional Services extensible masking plugin called XML.



    ------------------------------
    Tino Pironti
    Masking SME
    Technical Manager
    Delphix
    ------------------------------

    Original Message


  • 6.  RE: XML Attribute Masking

    Posted 09-07-2023 09:15:00 AM

    Thank you Toni! As you mentioned, the "id" attribute was displayed as a separate element in the inventory and the masking was applied as expected.



    ------------------------------
    Mahesh Chandran
    Delphix Community Members
    ------------------------------

    Original Message


Related Content