Masking JSON stored in Oracle Database

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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

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

Regards
Marcin
Photo of Marcin

Marcin

  • 566 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 2,126 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 
 https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_json.htm#AEAPI29635

Hope this helps

Thanks
Hims
(Edited)
Photo of Marcin

Marcin

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

Gianpiero Piccolo

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