Using excel to access published tables

264
3
Jump to solution
07-28-2021 05:57 PM
James_Armstrong
Occasional Contributor

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

 

0 Kudos
1 Solution

Accepted Solutions
DerekLaw
Community Moderator

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,

View solution in original post

0 Kudos
3 Replies
MichaelGinzburg
Occasional Contributor
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-automatica...


0 Kudos
DerekLaw
Community Moderator

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,

View solution in original post

0 Kudos
James_Armstrong
Occasional Contributor

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