In 5.2 was a feature that allows to define the column as XML object by applying an XML format.
So first you need to have an example XML file which you upload as file format.
Then you assign in inventory for this column the configured file format > as a result the GUI changes and you can assign on the XML element level specific algorithms for masking.
This feature (masking XML in database column) was depreciated in version 5.3.?
------------------------------
Tino Pironti
Technical Services
Delphix
------------------------------
Original Message:
Sent: 06-18-2020 03:20:35 PM
From: Sandy Ford
Subject: Masking Microsoft SQL Server column with XML data
We have a db with an NVARCHAR(MAX) column that contains data in XML format. It looks like it sometimes has sensitive data.
Anybody have suggestions on best way to mask this? I don't see an out-of-the-box algorithm that will work. We are on Delphix Masking Engine 5.2 (yea...I know we need to upgrade!)
Thanks for any help!
------------------------------
Sandy Ford
Sr. SQL Database Administrator I
United Fire Group
------------------------------