Join SQL table to shapefile in ArcMap

andrejjakubicka — Tue, 11 Dec 2012 14:10:27 GMT

Hello
I'm a totally newbie to GIS and my boss wants me to do some demo project.
I was supposed to create new layer, create some new polylines on it and here comes the point: after doing this, he wants me to join some SQL table or view where we store some non-spatial data (such as some url links to call our other services...). I was able to join this view to the shapefile (rigth-click on layer -> Joins and Relates -> Join), after adding query layer through database connection
But my question is: how to ensure, that after i create a new object(polyline, point) on this layer, that this new data are inserted into joined SQL table? e.g. objectId, description and so on, Or update some objects in ArcMap and consequently update in SQL table
Our GIS specialist is temporarily outsourced, so I've been googling around for about 2 weeks already and still no results found on my issue.

any help appreciated, thanks in advance

Andrej

Re: Join SQL table to shapefile in ArcMap

AlexeyTereshenkov — Wed, 12 Dec 2012 12:25:29 GMT

Hi,

Query layers are used for read-only access which means you cannot edit the source data (SQL tables) via query layers. I'd go for using geodatabase relationship classes or database triggers if you want to go non-geodatabase way.

topic Re: Join SQL table to shapefile in ArcMap in Data Management Questions

Join SQL table to shapefile in ArcMap

Re: Join SQL table to shapefile in ArcMap