Select to view content in your preferred language

Geocoding from a SQL database

1630
1
10-21-2016 03:09 PM
BrandonPowell1
Regular Contributor

We have customer data in our production SQL database. I'm wondering if there is a way to connect ArcMap to the SQL database table with our customer data and directly geocode the customer addresses and insert the spatial data back into the SQL database?

0 Kudos
1 Reply
ChristianWells
Esri Regular Contributor

Starting at 10.1 you can connect to SQL Server as a standalone database (non-geodatabase) you can read the addresses from there. After the addresses are geocoded, the entire table can be exported to the standalone database. Editing data, however, is limited to geodatabases.

Connect to SQL Server from ArcGIS—Help | ArcGIS for Desktop