Delphix Products

 View Only
  • 1.  Document type masking Algorithm-Not working

    Posted 07-07-2023 03:29:00 AM

    Hi Dear Members/Experts,

    I recently came across the requirement to mask JSON (CLOB) column in one of the tables and tried using Document type masking algorithm while creating one JSON file. Imported it and used in Inventory as an algorithm and the further file format section assigned out-of-the-box algorithms against one of the filed existing in that file which required masking in the CLOB rows.

    Could anyone please assist with below scenario:

    we need to filter out the output for this MSG_TXT column (containing JSON) with where clause (through custom SQL option in the rule set) and once Delphix filter out the row meeting where clause, masking is needed on filtered results.

    Filtered results of rows having similar length and format for all rows in JSON format and I tried masking it but didn't work for me. Here is the filter result sample:

    This is how I imported the JSON format file under file-format section of settings page to use it as algorithm for masking:

    This is how I used it for masking:

    further in file-format section, applied the masking:

    But the job is failing and not working, not sure if I have opted the correct steps.

    Attached is the filtered rows sample , required masking and the file I Imported to use under File-format section for document type masking (JSON_fileformat.txt--saving here in txt format as JSON attachment not accepted).

    Kindly assist and happy to share more information, if required.

    Regards,

    Raman



    ------------------------------
    Raman Gulati
    Data Governance Systems Specialist
    Bupa Australia Pty Ltd.
    ------------------------------

    Attachment(s)

    docx
    SAMPLE_Source_data.docx   17 KB 1 version
    txt
    JSON_fileformat.txt   1 KB 1 version


  • 2.  RE: Document type masking Algorithm-Not working

    Posted 07-07-2023 08:31:00 AM

    Hi Raman,

    I'm moving this to the Products community where it will have the right people looking at it. I will also keep an eye out.

    Thank you for posting.

    Michael



    ------------------------------
    Michael Torok
    Digital Customer Experience, Senior Director
    Delphix
    ------------------------------



  • 3.  RE: Document type masking Algorithm-Not working

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

    Hi Raman,

    I was also told that you have a ticket open with Support. Our team is engaged and will most definitely follow up there. 

    Would you please come back to this thread with any information you can share on how this gets resolved? I am sure the larger community would appreciate it.

    Of course any community help here is welcome and encouraged.

    Thank you!

    Michael



    ------------------------------
    Michael Torok
    Digital Customer Experience, Senior Director
    Delphix
    ------------------------------



  • 4.  RE: Document type masking Algorithm-Not working

    Posted 07-10-2023 04:43:00 PM

    Hello Raman,

    Please ask for the JSON and util jar (plugins) to Delphix support team.

    Once you get those plugins login to API and upload those plugins to the masking engine. (HTTP://<<URL>>/masking/api-client/#!/plugin/getAllPlugins

    Please find attached PDF for the configuration

    If you need any help kindly call me on +91 9689996500 WhatsApp number



    ------------------------------
    Pankaj Asegaonkar
    Masking/Virtualization Specialist
    +91 9689996500
    ------------------------------



  • 5.  RE: Document type masking Algorithm-Not working

    Posted 07-14-2023 06:34:00 AM

    Hello Raman 

    Did you get the Plugins from support team ?



    ------------------------------
    Pankaj Asegaonkar
    Masking/Virtualization Specialist
    +91 9689996500
    ------------------------------



  • 6.  RE: Document type masking Algorithm-Not working

    Posted 07-16-2023 07:32:00 PM

    Hi Pankaj/Team,

    Thanks for following up!

    Just wanted to let everyone in the group know that Delphix Document type masking algorithm is useful for JSON column/values masking.

    Its working for me pretty straight forward and I am able to mask the nested sensitive information in the CLOB column, which is really a nice feature and efficient way to mask JSON fields.

    Thanks again for support!

    Sincerely,

    Raman



    ------------------------------
    Raman Gulati
    Data Governance Systems Specialist
    Bupa Australia Pty Ltd.
    ------------------------------