Data profiling on XML tags

[RaviTeja CH]

We identified a column which has XML data present as records inside the table(MS SQL). For this column we would like to do data profiling and come up with the discovery sheet. Is there a way to run data profiling on XML columns?

Will there any masking execution time differences for XML and normal columns (Name, Phone)?

[Scott Schmitz]

Hi @RaviTeja CH

TDM Portal will recognize & tag the XMLData type and classifiers will attempt to match the values within it.   Those tags will be allocated at the field level rather than the XML elements.   You will need to inspect records in those tagged fields to verify what those PII-containing elements are.    See screenshot for example:  ("AdventureWorks2019" sample database,  Person.Person table)



TDM will be able to mask the data elements, and execution time should be consistent with other techniques, taking into account that masking procedures will execute one tag at a time if there are multiple tags to mask in the column.