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

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

sperez — Thu, 10 Nov 2022 00:51:12 GMT

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?

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

DanPatterson — Thu, 10 Nov 2022 01:20:46 GMT

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

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

George_Thompson — Thu, 10 Nov 2022 15:13:47 GMT

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_A188C2B1C8C54C7DA3233892FC742552

Hope this helps!

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

sperez — Wed, 16 Nov 2022 18:18:55 GMT

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...

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

AndreaB_ — Thu, 15 May 2025 21:33:59 GMT

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,

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

George_Thompson — Thu, 15 May 2025 21:35:20 GMT

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-services.htm#ESRI_SECTION1_C30D73392D964D51A8B606128A8A6E8F

What version of Enterprise are you publishing the table to?

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

AndreaB_ — Thu, 15 May 2025 21:40:04 GMT

ArcGIS Enterprise 11.1 Windows. Going to 11.3 very soon.

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

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

George_Thompson — Fri, 16 May 2025 10:25:55 GMT

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.