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.
