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,