Hi There
Is it possible to update a table in a versioned SDE database from SharePoint? My table contains a register of assets that I want non-GIS people to be able to add items to.
I have done some investigation and testing of the editing experience interfacing SDE tables from SharePoint using Database Connections to Multi-Version Views (Viewed in SharePoint via SharePoint Designer built pages).
The SharePoint experience
??? New records can be added. The OBJECTID is mandatory and unfortunately has to be manually added. The OBJECTID is not auto-populated nd because it is mandatory can???t be left to SDE to auto-allocate the next ID the behind the scenes.
??? Old and new records from current edit session can be deleted
??? Old records can???t be Modified. New records can be modified just the once before they to lock-up. If the end-user makes a mistake adding a new GIS_ID or GIS_Source record it isn???t easy for them to correct it.
I haven't tried accessing the table from SharePoint as an 'External List' but suspect I'll encounter same issue.
So does anyone know if non-feature related tables residing within a versioned SDE database can indeed be edit externally via a non ESRI client such as SharePoint?
Any advice on alternative approach also greatly appreciated.
Regards
Hayden
