This is something I have needed to do for years and it seems with each new release of Server software we get closer and closer. I have a perfectly working ArcGIS Server 10.1(SP1) installed and a ArcSDE geodatabase connected and working and no problems. I can create and edit feature classes, but I REALLY need to display a data value from another SQL server/Database. All I want to be able to do is create a join on a table from this other database to show the current values of a joined record. For example I have a list of Wells in a Geodatabase and in another SQL server I have the current levels that are updated daily. I would like to be able to create a ArcGIS.com map that will have a popup on the well and then pull the current level from the other SQL database. I can do this all day long in ArcMAP but I need to make a real world map to do this. I have been able to create a LinkedServer in the GeoDB to query the other database and I can also create a VIEW and do a join of the database between the GeoDatabase table and the other server, but I have not been able to create a map service that will not fail to publish.
Is there any ways, back door, work arounds that would not require me to upload data and republish maps so that we can view real time data?
Thanks!