topic Re: PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license? in Developers Questions

PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license?

DavidRalston — Thu, 14 Sep 2017 08:38:16 GMT

Linking arcgis and postgresql without and enterprise license

Re: PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license?

JayantaPoddar — Thu, 14 Sep 2017 09:14:12 GMT

Yes. That is possible. You can create a spatial database using PostGIS, and then connect to the PostgreSQL database from ArcCatalog (Add Database Connection). Connect to PostgreSQL from ArcGIS—Help | ArcGIS for Desktop

Re: PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license?

AZendel — Mon, 25 Sep 2017 14:50:11 GMT

But can you edit? From what I've read and tried, the answer is no.

Re: PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license?

JayantaPoddar — Mon, 25 Sep 2017 15:34:09 GMT

Hmmm... I think you got that right.

You can get Read-Only access to the PostGIS data using Query Layers.

For editing, you will need to enable Enterprise Geodatabase, for which ArcGIS Enterprise (Server) License is required.

Re: PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license?

NicoTripcevich — Fri, 13 Mar 2020 10:32:12 GMT

Is this still true? I'm trying in ArcPro 2.5.

Disappointing ESRI. QGIS wins again.

Re: PostGIS integration with ArcGIS - is it possible to load and edit data from a PostgreSQL database into ArcGIS without an enterprise license?

ThomasL — Mon, 12 Oct 2020 17:10:21 GMT

You can access PostgreSQL/PostGIS spatial databases without enabling them as an ESRI Enterprise Geodatabase:

"Unless you have specific needs for an ESRI Enterprise Geodatabase due to ArcGIS editing workflows, need for advanced geodatabase data types, relationship classes etc, you may be able to simply connect to the spatial database using ArcGIS Query Layersand not enable an Enterprise Geodatabase.

You just need to run the Add Incrementing ID Field tool against any spatial table in the PostGreSQL/PostGIS database if there is no suitable unique ID field for each record in the table. You will then be able to add a Query Layer including spatial columns to ArcGIS.

If your requirements are just "read-only" access of PostGIS data maintained by another software package, this setup may suffice.

I have run such a setup against large PostGIS databases with great success."

Source: Marco Boeringa at https://community.esri.com/thread/240840-arcgis-pro-create-enterprise-geodatabase-not-finishing