Is there a way to edit a SQL DB Table (as a standalone table) in ArcGIS Pro?

[sperez]

Hello!

Basically, I'm wanting to use ArcGIS Pro to complete a few field calculations in a SQL database table, using the corresponding fields in a separate feature class. However, it seems I cannot edit this SQL table in ArcGIS Pro. 

To explain what I've done thus far:

1. I've connected to my respective SQL DB in Catalog.

2. I've pulled in a table containing location data and plotted it using LAT/LONG, then exported it as a feature class. 

3. I then used a spatial join with other layers to conduct my field calculations. I removed this spatial join once my calcs were complete. 

4. I then joined the SQL DB table to my cleaned up feature class and started an edit session.

This is where I ran into my issue. Even after starting an edit session, the 'Calculate Field' option is greyed out, nor can I click into a cell to edit an attribute. I ensured I had read/write access at the DB level, as well as the item level. Do I need to register the table with a geodatabase to achieve this, or am I'm missing something simple here?

[DanPatterson]

Temporary join? Add Join (Data Management)—ArcGIS Pro | Documentation

or permanent? Join Field (Data Management)—ArcGIS Pro | Documentation

And are you trying to edit a field in the destination table or the join table?

A permanent join should allow you to edit any field

[George_Thompson · Accepted solution]

You are not able to edit directly from ArcGIS Pro on a database, unless you register the table with the Enterprise Geodatabase or publish as a service.

https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_...

Hope this helps!

[sperez]

George,

This is what I suspected. Thank you for confirming and for providing the helpful link! Now time to convince my DBA into allowing me to register the table with an Enterprise GDB...

[AndreaB_]

Hi all,

I'm doing something very similar and was happy to find this question already posted. I thought I could publish the SQL table as a service according to that documentation and then I could edit it. But I can't get that to work. I tried just the table by itself and I get: error "0001 Map does not have layers". I don't have any spatial data to add to the map from the SQL database. I tried adding another layer from a different geodatabase and then the error was "00062: Map contains data that does not use the same connection to an enterprise geodatabase". ArcGIS Pro 3.2.4. @George_Thompson have you done this before - does it work? 

Thank you,

A

[George_Thompson]

I have not tested with just a table; I usually have a spatial layer. You could try to create a spatial layer in the same database with 1 record, turn it off when publishing. Here is some more information on publishing from a database: https://enterprise.arcgis.com/en/server/latest/publish-services/linux/prepare-data-for-feature-servi...

What version of Enterprise are you publishing the table to?

[AndreaB_]

ArcGIS Enterprise 11.1 Windows. Going to 11.3 very soon.

How would I create a spatial layer in the SQL database?

[George_Thompson]

You can copy in a layer from a file geodatabase that has some spatial information. It will create it in SQL Server which you can then bring into Pro and publish.