topic Re: Linking a feature class to a transactional database in ArcGIS Enterprise Questions

Linking a feature class to a transactional database

LoaiFarajallah — Fri, 08 May 2015 19:51:44 GMT

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?

Re: Linking a feature class to a transactional database

LoaiFarajallah — Mon, 11 May 2015 18:02:31 GMT

Any help?

Re: Linking a feature class to a transactional database

JakeSkinner — Tue, 12 May 2015 10:55:48 GMT

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?

Re: Linking a feature class to a transactional database

LoaiFarajallah — Thu, 14 May 2015 14:17:29 GMT

Exactly Jake

Re: Linking a feature class to a transactional database

BillDaigle — Thu, 14 May 2015 17:48:35 GMT

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.

Re: Linking a feature class to a transactional database

TobiasFimpel1 — Fri, 15 May 2015 03:38:35 GMT

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.