One of our Divisions is using SQL Server to store data in the native spatial format.
Can this be edited directly with ArcMap?
Do I need to install ArcSDE (create the Geodatabase) to enable editing with ArcMap.
If the data is already in the database - do I have to register it with the Geodatabase?
Anyone got the references to how to approach this?
Anyone know if there are any gotchas in relation to data created via another app, then edited in ArcMap?
I have a feeling the user created the data with MapInfo, and may plan to attempt to edit in both - which has the potential to go pair shaped if you ask me.
We won't be able to edit the SQL server data in ArcMap. If we will add data SQL server data in Table of content and try editing it, following error will be encountered in ArcMap:
"no editable layer"
"the workspace containing this data can not be edited"
>>Now to resolve this issue we can try following:
1. You can register the database as geodatabase and can edit the data in ArcMap.
For that you can use "enable enterprise geodatabase" tool.
Here is a link for reference:
Enable Enterprise Geodatabase
To enable enterprise geodatabase we need keycodes or authorization file. For that we need ArcGIS for server enterprise license.
2.In Arcmap, you can import or copy/paste the data from sql server database to file geodatabase -> perform editing -> import it back in SQL server database.
Also, I would appreciate if you could have a look at the below link:
You need ArcGIS for Server (or is it just ArcGIS Server now, again?), but you don't necessarily need an enterprise geodatabase. Although I haven't tested myself, The Evolution of Query Layers blog post indicates that non-geodatabase data can be edited in ArcMap and other clients when published as a feature-access enabled service. There are important footnotes/caveats. A couple pieces of information in the blog post are outdated, but overall nearly all of the content remains relevant and accurate.
similar thread: Can tables in a non-spatial database be edited in ArcMap
If you have ArcGIS Server, you can publish a feature service that contains data from an ALTIBASE, Dameng, IBM DB2 (Linux, Unix, or Windows), IBM Informix, Microsoft Azure SQL Database, Microsoft SQL Server, Oracle, PostgreSQL, SAP HANA, or Teradata database. You can set what type of edits can be made to the data through the feature service and give people access to the feature service so they can edit. See What is a feature service? and related topics in the ArcGIS Server help for more information.
I revisited this recently - it has been a few years and things change.
From what I can see, if you have data in SQL Server native, then you can use ArcGIS Query layers to read the data. There are a few caveats around having a unique integer ID, field types being compatible and having only one data type per table (point, line or polygon). Probably issues with coordinate system definitions as well.
To edit the data you need to publish it through ArcGIS Server as web feature layer.
This is one of the better references: