...
Accela APO records must be kept synchronized with EAS addresses in near real time. Regardless of how we build this it is convenient to think of this as a sort of custom replication service. We've already done this successfully with DBIs AVS as described here and here. With Accela however, we are using an ESRI SDE table in an Oracle DB. While there are probably a number of ways to do this, it seems like the simplest approach is to use the ArcGIS rest API. I think we can do everything we need with query, add, and update.
Implementation
After some discussion, Mike and Paul have decided to try the simplest thing that could possibly work, To that end, I have written most of this code which you can see here. I do not have access to an arcgis server yet so I still have lots of testing to do . However, I have tested the a fair bit of the code and you can see the log file output below.
...
Before we can continue with any serious testing we need to do the following.
...
I'd also like to do the following before we get to much further down the road.
- design review
- code review
- discuss strategy for cut-over from AVS to Accela (see this line) (currently hard coding timestamp)
...