Hi Marcin,
From the documentations for both 5.3.7 and 6.0 the JSON file isn't yet supported as a source masking
https://maskingdocs.delphix.com/5.3.7/Getting_Started/Data_Source_Support/https://maskingdocs.delphix.com/Getting_Started/Data_Source_Support/You will have to build a challenging solution to get the json column masked :
1/ extract the json outside from db to file
2/ convert json to supported format for delphix masking (fixed, delimited or xml)
3/ Mask files
4/ convert back masked files to json
5/ update you database with the new masked json
Personally will not go with such a project.
Hope, that delphix will be more reactive on this scope to provide a native support for JSON as it becomes one of most used standards
Regards,
Mouhssine
------------------------------
Mouhssine SAIDI
Community Member
Delphix Community Members
------------------------------
Original Message:
Sent: 02-19-2020 09:01:19 AM
From: Marcin Kwasninski
Subject: Masking PostgreSQL with JSON and JSONB data type
Hi Everyone,
We have PostreSQL 9.6 with JSON and JSONB data to mask, can Delphix Masking 5.3.7 are able to mask this type of Data ?
Regards
Marcin