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?
Any help?
Hi Loai,
Can you explain how you have the data joined? Are you joining the attribute table from the transactional database to the point feature class using ArcMap?
Exactly Jake
Is your transactional database registered as a datastore within ArcGIS server? If not, the publishing process is likely copying the data from the join to the server.
Loai,
One alternative you could try is to use an ArcMap Query Layer and then publish that as a layer in your map service. That has worked for me before.