I have a SQL Server table in my ArcGIS Online web app.
It is related to 2 other feature classes also in my map.
The source table is a non spatial table being related on a common field.
Not sure what more to add about the connection.
I've connected to the SQL Server table in ArcMap and related it to my feature classes then published it to ArcGIS Online
The SQL Server table is updated frequently, however these updates to the table are not reflected in my web app.
The updates are new values in existing columns.
I can see them in the .mxd locally, but they do not appear in the SQL Server table being used in my web app. I have not registered the connection on the ArcGIS Server host so the data is copied each time I publish the map service.
What can I do so that my SQL Server table updates with any new values entered into it from Microsoft Access?
Best Answer
The only way ArcGIS Server can dynamically access a data table is if the service is published with a data source which is registered with the ArcGIS Server cluster. If you don't have a registered data source, AGS will raise a warning in the publishing process, but will let you override that warning to make a static copy in a file geodatabase (which is copied to all nodes from which the service is published). This condition is not an error, because there are times when you really do want to not be bothered with registration (for example, when publishing based on a pre-built cache), but it is not always a desirable outcome.
Since you do want dynamic table contents, you will need to follow the procedure for registering a data source with ArcGIS Server. Since there are several ways to accomplish this, I suggest you start with the overview documentation then follow up with one of the "how to" pages appropriate to your environment.