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; } } }

Connecting to Postgres database

TheGamer

Hi, is there an easy way to connect to a postgres database (hosted through AWS) to ArcGIS Online?

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

George_Thompson

You have to publish data to ArcGIS Online. There is not a way to connect an "external" DB (as far as I know). The published data is hosted in ArcGIS Online.

If you need this DB to be published, then I would recommend using ArcGIS Enterprise and referencing the services in ArcGIS Online.

TheGamer

@George_ThompsonI am making a ModelBuilder model which will use a table from the PostgreSQL and perform some calculations (tabulate intersection, joins, etc). If data changes in the database, will the changes automatically appear in ArcGIS Pro? If not, how can I make sure changes appear without reconnecting the database

George_Thompson

You would need to create and publish a DB view (via ArcGIS Enterprise or ArcGIS Server) if you want the changes to show up.

If you use a model, the data will be updated after the model is run, unless you script it to look for updates.

TheGamer

@George_Thompson can you tell me what libraries I would need to connect/update the database in ArcGIS Pro notebook? Also, I'm no longer use a model builder instead I will be connecting the table from the database with a feature class

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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