On one side, I want to publish a map service for buildings in a selected area (point features).
However, one attribute value for each building needs to come from an external transactional database (which is populated by a web-based system).
I managed to link the feature class to the database by linking the attribute table to a view in the transactional database.
The problem is that when I publish the map as a service, the data isn't changing as I change values in the transactional database!
Is there a way to make this link dynamic?