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

Using excel to access published tables

James_Armstrong · 2021-07-29T00:57:11+00:00

Im not sure what (if any) would be the best way to go: * Data coming from PostSQL database * Publishing the feature datasets to Portal (10.9) from database. * We have some tables and related tables in database, these can be published as well * Data in tables changes and needs to be updated periodically We would like to be…

James_Armstrong

Im not sure what (if any) would be the best way to go:

Data coming from PostSQL database
Publishing the feature datasets to Portal (10.9) from database.
We have some tables and related tables in database, these can be published as well
Data in tables changes and needs to be updated periodically

We would like to be able to connect to the table data using excel so non-GIS staff can edit as needed.

Should we try to set and use excel to connect directly to PostSQL. (ODBC connection?)
IS there a way to use excel to connect to the published data (Portal)? SO far we have not found one.

Any suggestions, advice, or direction will be most appreciated.

James Armstrong

Najděte více příspěvků označených jako

Accepted answers

DerekLaw

Hi @James_Armstrong,

> Im not sure what (if any) would be the best way to go:

Data coming from PostSQL database
Publishing the feature datasets to Portal (10.9) from database.
We have some tables and related tables in database, these can be published as well
Data in tables changes and needs to be updated periodically

For the above workflow, you could create query layers in ArcGIS Pro, Query layers.

> IS there a way to use excel to connect to the published data (Portal)?

ArcGIS for Office enables MS Excel users to connect to an ArcGIS portal and view its data, but it does not support the ability to edit data.

Hope this helps,

All comments

MichaelGinzburg

Portal distributes data by REST services.

You can try to use webservice() Excel function.

https://www.microsoft.com/en-us/microsoft-365/blog/2013/03/21/use-webservice-functions-to-automatically-update-excel-2013-spreadsheets-with-online-data/

DerekLaw

Hi @James_Armstrong,

> Im not sure what (if any) would be the best way to go:

Data coming from PostSQL database
Publishing the feature datasets to Portal (10.9) from database.
We have some tables and related tables in database, these can be published as well
Data in tables changes and needs to be updated periodically

For the above workflow, you could create query layers in ArcGIS Pro, Query layers.

> IS there a way to use excel to connect to the published data (Portal)?

ArcGIS for Office enables MS Excel users to connect to an ArcGIS portal and view its data, but it does not support the ability to edit data.

Hope this helps,

James_Armstrong

Derek, I kinda knew that already, but just wanted to be sure I hadn't missed anything. I like the idea of the Query View. I believe this would work well and I also believe I could connect to the actual database in PostSQL using Excel. If this is true, then perhaps the specific staff members could update the tables and these updates would be reflected in the query view.

Thanks for the nudge

James

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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