We have non-spatial data stored on an SQL Server (Backflow Valve w. Adress Location) that we would like to map out for our field users to see (using AGO and Collector). How could we link that data geographically (Map) and keep an active link the the SQL Server to show most current db version?
So you have a table that looks something like this:
V1 1234 S Main St
Why not geocode the addresses and get a point feature class out of the?