Hello.
We have several older data processing scripts that manually sync data from AGOL to our enterprise spatial databases (in older person's vernacular - SDE databases). Generally speaking, the scripts
- find the last date the script ran successfully
- find data in a hosted feature service that have a last edit date more recent than the last date the script ran successfully
- export that data as a file geodatabase (fgdb)
- inserts/updates data in SDE based on fgdb
I am starting a new project that needs to do the same basic process - one-way sync of data from AGOL to an SDE database, but before i follow the tried-and-true well-worn path, i am reconsidering the approach to see if there are other, better ways of completing the task. I've spent some time reading the REST API docs about sync functionality, but i haven't seen anything that specifies a sync client that's an SDE data table(s). Or any workflow examples that match what i'd like to do.
I'm wondering if there are better / alternative ways of performing the sync from AGOL to SDE than the manual approach we're using now.
Thank you
