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.

[Premlal Digarse]

Hi Scott,

We have similar  case where data is stored in XML documents inside DB columns.

We were told that CA TDM portal can not do profiling for such cases to identify the sensitive fields.

Looking at your response above, it looks like CA tool , do support this, can you please suggest how do we do this profiling?

Regards

Prem