Linking a feature class to a transactional database

[LoaiFarajallah]

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?

[LoaiFarajallah]

Any help?

[JakeSkinner]

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?

[LoaiFarajallah]

Exactly Jake

[BillDaigle]

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. 

[TobiasFimpel1]

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.