topic Re: Publishing a view from registered postgres database with full functionality in ArcGIS Enterprise Portal Questions

Publishing a view from registered postgres database with full functionality

DaraUnglaube — Tue, 25 Mar 2025 16:47:29 GMT

Greetings.

We have ArcGIS Enterprise (version 11.2) connected to our PostgreSQL (version 16.1) with PostGIS (version 3.4.0) database. Our goal is to publish views from this registered database with full functionality (such as identify, search, and zoom to feature), without the need for edit capabilities.

While we have successfully published a view to Enterprise through ArcGIS Pro as a feature service (with a postgres full access super user), we have encountered a significant issue: the functionality for identifying, searching, and zooming to features is lost after publication. In contrast, when we publish spatial tables from the same PostgreSQL database, those tables maintain their full functionality.

However, the majority of our data is tabular that needs to be summarized, have regular updates based on hourly changes, or only a portion can be published publicly and then those tables need to be linked to the associated spatial data for viewing.

Is there a way to effectively publish a view from our registered database while retaining the desired functionalities (identify, search, zoom to feature, etc.)? Any guidance or insights you could provide would be greatly appreciated.

Thank you in advance for your time.

Re: Publishing a view from registered postgres database with full functionality

JakeSkinner — Wed, 26 Mar 2025 20:59:43 GMT

Hi @DaraUnglaube, one thing to note, PostgreSQL 16 is not currently supported with Enterprise:

https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm

Re: Publishing a view from registered postgres database with full functionality

MarceloMarques — Wed, 26 Mar 2025 21:43:35 GMT

@DaraUnglaube PostgreSQL 16 will only be supported and certified with the upcoming release of ArcGIS Pro 3.5 and ArcGIS Enterprise 11.5.

Re: Publishing a view from registered postgres database with full functionality

MarceloMarques — Wed, 26 Mar 2025 23:04:48 GMT

@DaraUnglaube

"we have successfully published a view to Enterprise through ArcGIS Pro as a feature service"

Database Views cannot be used in ArcGIS Feature Services. You need to publish a Map Service instead. See the documentation below.

Views in an enterprise geodatabase—ArcGIS Pro | Documentation

You cannot edit the data through the view using ArcGIS clients or services, even if you register the view with the geodatabase.
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-saphana/views-in-geodatabase.htm#:~:text=You%20cannot%20edit%20the%20data%20through%20the%20view%20using%20ArcGIS%20clients%20or%20services%2C%20even%20if%20you%20register%20the%20view%20with%20the%20geodatabase.

Note:
Views are not automatically registered with the geodatabase, even if the view is defined on geodatabase tables and feature classes and even if you create the view using the Create Database View geoprocessing tool. The view is not registered with the geodatabase unless you explicitly register it.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-saphana/views-in-geodatabase.htm#:~:text=database%20management%20system.-,Note%3A,-Views%20are%20not
------------------------------------------------------------------
Hence, you need to create the database view using the Pro GP tool, then you can run the Register With Geodatabase geoprocessing tool to make the view a geodatabase object. Then, add the view to a new Pro document and publish as a Map Service, then close/open Pro, connect to the ArcGIS Server, add the map service to a new Pro map, and see if identify, search, zoom to feature, etc. is enabled for the service.
------------------------------------------------------------------

Re: Publishing a view from registered postgres database with full functionality

DaraUnglaube — Tue, 29 Apr 2025 16:52:01 GMT

Greetings. A quick update on this behavior. We have been working with ESRI support and they were able to replicate our issue. They went to submit a bug report and a portion of this error has already been reported as a bug. It is listed on https://support.esri.com/en-us/bug/the-popup-is-not-working-for-data-published-from-postgr-bug-000163958