Sharepoint Data - Sparse Columns / Column Sets

AdamNellessen — Mon, 29 Sep 2014 20:06:30 GMT

Before upgrading to Sharepoint 2013, I was able to make a database connection to our Sharepoint SQL Server and the data contained in the AllUserData table was available. Unfortunately, Sharepoint 2013 utilizes Sparse Columns or Column Sets. The sparse column (tp_ColumnSet) can be viewed in SQL Server Management Studio as an XML column. In ArcMap or ArcCatalog, the columns (bit1, datetime1, int1, nvarchar1 etc...) are created correctly from the tp_ColumnSet field. The problem, however, comes when more than one field is contained in tp_ColumnSet. The table displays correctly until the first entry with two or more columns, in which case the following error displays:

The data cannot be downloaded locally to manipulate the XML column as the data is continuously being updated. I was wondering if there was a workaround to direct the column tp_ColumnSet to correctly parse out the contained data even with two or more columns present.

topic Sharepoint Data - Sparse Columns / Column Sets in ArcGIS for SharePoint Questions

Sharepoint Data - Sparse Columns / Column Sets