Map SQL Query Layer Data

Question

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?

KevinRobert1 · Answer

It is our solution for now but we wanted to keep an active link to the DB so we wouldn't have to run the geocoder everytime the DB changes (new valve or change of status).

JoeBorgione · Answer

So you have a table that looks something like this:

ValveID            Address

V1                    1234 S Main St

...                      .....

Why not geocode the addresses and get a point feature class out of the?

What is geocoding?—Help | ArcGIS for Desktop