Wednesday, February 23, 2005
Direct SQL Access to ArcSDE Data
Posted on Wednesday, February 23, 2005 7:25:40 AM (Mountain Standard Time, UTC-07:00)  Comments [0] | 
Categories: .NET | ArcSDE

For some time we've been working with SDE's multi-version views in order to allow direct SQL access to versioned data stored in ArcSDE. We've used this exclusively for reporting, and it has worked really well. We've got a new project on the go where in we need to facilitate off-line (disconnected) editing of tabular data in a Geodatabase. I'm just in the R & D phase right now, but it looks like we'll be able to use these same views to do data editing. Granted, we can not facilitate editing of the shapes this way, but this application does not require that. The nice thing is that the data will still reside in a geodatabase, and thus will be accessible to all the tools etc built into ArcMap/Catalog.

The basic architecture follows a simple ADO.NET offline client application. The client app contacts a web-service and requests a set of data (as a DataSet), and then switches to off-line mode. The user makes edits as needed, and then re-connects, and the application sends the DataSet diffgram to the web service, which re-sync's the data. I'll post some code and links as I get further into this.

Comments are closed.