It seems what I want to do should be easy and obvious, but I can't find anything on it.
I have a flex app that is updating SQL Server data in response to user inputs and displaying that data in real time. I have a polygon shapefile that I want to display according to fields in that SQL Server data and have the map update in real time along with the SQL Server data.
Is there a way to join this data in Flex so that the SQL Server and the map can reside on different servers? If that's not possible and I join the shapefile to the SQL Server tables in a map document that I publish as a web service, will the map with the joined data update when the SQL Server table updates so that I can map changes live?