nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Esri documentation on how to connect to a PostgreSQL (non-gdb) database in Arc Pro v 2.7.0 in order to access the schema and perform queries only (rea

LeslieCooper

Hi friends, my mission is to connect to a PostgreSQL (non-geo) database in Arc Pro v 2.7.0 in order to access the schema and perform queries only (read only/no write permissions and I am not the DBA). I have been researching how to do this and am still unclear about the process. I would like to be able to present information clearly to the DBA (who is not in the GIS field) so they can perform any necessary requirements for the connection on their end but I'm unable to find a clear outline of it. I am currently trying to piece together the process using troubleshooting questions on forums, etc but it seems like there must be a better way! Help appreciated!

Find more posts tagged with

Accepted answers

George_Thompson

Hi Leslie - That is correct!

I have non-geodatabases in Postgres that I have data in and can access from ArcGIS Pro / Enterprise with no issues.

All comments

George_Thompson

You should be able to make a DB connection to the non-geodatabase Postgres DB from ArcGIS Pro. You just need a users with the appropriate permissions: https://pro.arcgis.com/en/pro-app/2.7/help/data/geodatabases/manage-postgresql/privileges-postgresql.htm

It may also be good to install PGAdmin on your local machine to test connecting.

LeslieCooper

Thanks for your reply. So it looks like I need to be granted superuser status by the DBA in order to create a gdb (which seems necessary?) in ArcPro to establish the connection to the db?

George_Thompson

If you are going to create an Enterprise Geodatabase, you will need the "postgres" user credentials. It will make the SDE user a superuser on the instance.

In order to just connect and view the tables (spatial / non-spatial), you just need grant the permissions in the link above in the section that says "Viewer"

LeslieCooper

Thanks again for replying, George. To clarify, I DO NOT need to create an enterprise database in order to query data and view schema, correct? Thanks.

George_Thompson

Hi Leslie - That is correct!

I have non-geodatabases in Postgres that I have data in and can access from ArcGIS Pro / Enterprise with no issues.

LeslieCooper

Excellent. Thanks!

Leslie

LeslieCooper

Hi George, I've established the connection to the postgres db successfully however when I try to create a query table I am unable to see the more than just table names in the db. The thought was that it may be a table name case issue but the names are lowercase and all fields within are lowercase. Is the problem that I am creating a query from a connection and not a gdb? Do I need to create a geodatabase from the postgres db connection first?

TIA!

Leslie

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.