CA Plex data type of XML

Products

• CA Plex

Issue/Introduction

I need to store XML code in a database and I see that SQL Server does allow a data type of "xml". Can CA Plex generate a database field with this data type?

 

Environment

CA Plex all versions

Resolution

No, Plex is not able to generate a field in an SQL Server database table with a data type of XML.

You would need to parse the XML to retrieve individual field values and store those values in SQL Server database.