Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service?
Does anyone have any experience with such a thing?
The reason for this is that I have an Oracle database that is separate from the SDE database, and there are number of business rules that we want to run first, before inserting the geometry into SDE.
So the basic workflow would be:
1. Point features via ArcGIS Server via ArcSDE loaded onto web map
2. User moves point or edits attributes
3. Edits to points first get written to Oracle, then, via trigger to ArcSDE