Delphix Products

 View Only

  • 1.  Masking PostgreSQL with JSON and JSONB data type

    Posted 02-19-2020 08:01:00 AM
    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


  • 2.  RE: Masking PostgreSQL with JSON and JSONB data type

    Posted 02-19-2020 08:29:00 AM
    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


  • 3.  RE: Masking PostgreSQL with JSON and JSONB data type
    Best Answer

    Posted 02-19-2020 11:03:00 AM

    Hi Marcin, Mouhssine,

    with Delphix version 6.0.2 the maskingSDK will become available. This SDK is based on Java and allows customers / partners to write custom transformations.

    Currently we have the idea to write a logic using this SDK that can digest json as input and mask each node with a selectable algorithm. 



    ------------------------------
    Tino Pironti
    Delphix Community Members
    ------------------------------

    Original Message


  • 4.  RE: Masking PostgreSQL with JSON and JSONB data type

    Posted 02-20-2020 09:05:00 AM
    Does anyone have any idea around when 6.0.2 will be released?

    ------------------------------
    Rich Van Veen
    Security Professional
    Wells Fargo
    ------------------------------

    Original Message


  • 5.  RE: Masking PostgreSQL with JSON and JSONB data type

    Posted 02-20-2020 10:12:00 AM
    Planned date for 6.0.2 is May 2020

    ------------------------------
    Tino Pironti
    Technical Services
    Delphix
    ------------------------------

    Original Message


  • 6.  RE: Masking PostgreSQL with JSON and JSONB data type

    Posted 02-24-2020 07:09:00 AM
    Thanks very much, Tino.

    ------------------------------
    Rich Van Veen
    Security Professional
    Wells Fargo
    ------------------------------

    Original Message


Related Content