Skip to main content
  • EN

I have a feature class stored in an ArcSDE database
which is edited by a couple of users via a web application. I want to push this
information to a separate postGIS database. It’s important that the
new/edited/deleted objects are pushed to the postGIS as quick as possible.

 


So, I’m wondering if it’s possible to do this via FME Server? Are there any
features/tools for “listening” to a database, and execute a small workspace
each time the database is edited (or something similar)?

Hi,

Maybe this serie of articles can help.

https://knowledge.safe.com/articles/806/push-data-out-of-databases-to-fme-server-in-real-t.html

Hi,

Maybe this serie of articles can help.

https://knowledge.safe.com/articles/806/push-data-out-of-databases-to-fme-server-in-real-t.html

Yes... the quickest way would be to use a trigger as indicated by the article Itay has shared. You could have a separate table in the same database that stores any updates history. When an update occurs the trigger fires... pushing to the FME Server and to this history table.

 

As a backup it might make sense for a schedule task that runs in the evening to check that the history table updates were all processed and change a flag in the history table. This would at least catch those times when a network hiccup occurs.

 

 

Reply


Community Stats

30,352
Posts
115,344
Replies
38,087
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.