I am relatively new to an Enterprise deployment, in the past, I have published to my Arc Server and consumed the services via AGOL. I have been using ArcPro off and on for over a year and started messing around and testing ArcGIS Solutions. I in the past, because of service credits, not experimented with Hosted Feature Layers in AGOL so I have not put in the leg work to know the particular ins and outs of working with feature layers.
Am I better off using the same workflow as before of creating the data sets on my SDE and publishing to the Server and consuming the service in an ArcGIS Solution or use a Hosted Feature Service?
My guess from what I have gathered is that depends on the number of Schema modifications that are required to the data sets that come with the ArcGIS Solution. It appears that it is much more difficult to do a schema change on a Hosted Feature Layer than on an SDE dataset. I am just curious if there is a lot more to it than that?
Thanks
Here is a good white paper regarding this topic: https://assets.esri.com/content/dam/esrisites/en-us/media/whitepaper/data-in-arcgis-user-managed-and...
Here are some other links to review:
https://enterprise.arcgis.com/en/portal/latest/use/hosted-web-layers.htm