Masking JSON stored in Oracle Database

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
HI Community,

We have client with stored JSON's in Oracle Database, like that for example:

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

Photo of Marcin


  • 774 Points 500 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 2,882 Points 2k badge 2x thumb
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

Hope this helps

Photo of Marcin


  • 774 Points 500 badge 2x thumb
Thank you Hims
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,618 Points 1k badge 2x thumb
Hi Marcin,

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

+ you have only associate the custom algorithm to the column in the inventory
- 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