topic Re: Geocoding from a SQL database in Data Management Questions https://community.esri.com/t5/data-management-questions/geocoding-from-a-sql-database/m-p/429791#M24567 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/connect-sqlserver.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/connect-sqlserver.htm">Connect to SQL Server from ArcGIS—Help | ArcGIS for Desktop</A>&nbsp;</P></BODY></HTML> Fri, 21 Oct 2016 22:22:06 GMT ChristianWells 2016-10-21T22:22:06Z Geocoding from a SQL database https://community.esri.com/t5/data-management-questions/geocoding-from-a-sql-database/m-p/429790#M24566 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Fri, 21 Oct 2016 22:09:34 GMT https://community.esri.com/t5/data-management-questions/geocoding-from-a-sql-database/m-p/429790#M24566 BrandonPowell1 2016-10-21T22:09:34Z Re: Geocoding from a SQL database https://community.esri.com/t5/data-management-questions/geocoding-from-a-sql-database/m-p/429791#M24567 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/connect-sqlserver.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/connect-sqlserver.htm">Connect to SQL Server from ArcGIS—Help | ArcGIS for Desktop</A>&nbsp;</P></BODY></HTML> Fri, 21 Oct 2016 22:22:06 GMT https://community.esri.com/t5/data-management-questions/geocoding-from-a-sql-database/m-p/429791#M24567 ChristianWells 2016-10-21T22:22:06Z