Hi,
I would like for my workspace to run automatically each time a row is added to a postgis table, but can't figure out how to do this.
I took a look at the Directory Watch Publisher and also at this article: https://knowledge.safe.com/articles/806/push-data-out-of-databases-to-fme-server-in-real-t.html but I don't really understand how to proceed.
Thank you
The directory watcher is to look for files in a directory, you cannot use it to look in a database table.
A possible solution to your specific scenario could be to write an insert trigger in PostGIS that somehow sent a message to FME Server, triggering a workspace subscription.
This is described in quite a lot of detail here:
https://knowledge.safe.com/articles/805/single-edits-postgres-push-data-from-the-database.html
This article could also be of interest to you:
https://dzone.com/articles/sending-sockets-postgresql
The directory watcher is to look for files in a directory, you cannot use it to look in a database table.
A possible solution to your specific scenario could be to write an insert trigger in PostGIS that somehow sent a message to FME Server, triggering a workspace subscription.
This is described in quite a lot of detail here:
https://knowledge.safe.com/articles/805/single-edits-postgres-push-data-from-the-database.html
This article could also be of interest to you:
Thank you for your help. This actually is the article I have been reading.
When I look at the "Single Feature Trigger Demo Overview" part I am interested in parts 3 to 5.
What I don't understand is that it is mandatory to create an HTTP request. Isn't there some kind of database listener in FME server?
Thank you for your help. This actually is the article I have been reading.
When I look at the "Single Feature Trigger Demo Overview" part I am interested in parts 3 to 5.
What I don't understand is that it is mandatory to create an HTTP request. Isn't there some kind of database listener in FME server?
As far as I know there is not, I suspect because this is handled very differently from one database to another.
As far as I know there is not, I suspect because this is handled very differently from one database to another.
Ok, thank you for your reply