Delphix Products

Expand all | Collapse all

Masking JSON stored in Oracle Database

Jump to Best Answer
  • 1.  Masking JSON stored in Oracle Database

    Posted 07-04-2018 05:00:00 PM
    HI Community,

    We have client with stored JSON's in Oracle Database, like that for example:
    https://blogs.oracle.com/jsondb/storing-json-in-the-oracle-database">https://blogs.oracle.com/jsondb/storing-json-in-the-oracle-database">https://blogs.oracle.com/jsondb/storing-json-in-the-oracle-database

    Is there any way to mask this kind of structure in database using ME ?

    Regards
    Marcin
    #Masking


  • 2.  RE: Masking JSON stored in Oracle Database
    Best Answer

    Posted 07-05-2018 05:21:00 PM
    Hello Marcin,
    Delphix does not natively support masking of JSON stored in the database yet but can be done in a few ways.
    The easiest way to mask JSON would be:
    1. Flatten it out to atomic columns
    2. Mask the and sensitive columns
    3. Re-populate the JSON.
    You can use Oracle Apex JSON package to do this 
     https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_json.htm#AEAPI29635

    Hope this helps

    Thanks
    Hims


  • 3.  RE: Masking JSON stored in Oracle Database
    Best Answer

    Posted 07-06-2018 09:08:00 AM
    Thank you Hims


  • 4.  RE: Masking JSON stored in Oracle Database
    Best Answer

    Posted 07-06-2018 12:38:00 PM
    Hi Marcin,

    an alternative solution could be developing a custom algorithm that works directly with the JSON content. 

    PRO:
    + you have only associate the custom algorithm to the column in the inventory
    CONS:
    - you have to develop the custom algorithm or ask for it to professional services (Delphix or a partner like us)
    - you have to download all the content from the DB column towards the Delphix Masking Engine and so if the content is very large, you could overflow the network.

    Best Regards.
    Gianpiero Piccolo