Our aim is to publish many feature layers from our SDE geodatabases. (ArcGIS v 10.9, SQL Server 2017)
We want the portal user to find data easily using tags and categories. We have applied metadata nicely within SDE. (Descriptions, Tags, etc) These layers are for querying and analysing only (not editing).
How do most large organisations publish their layers for these Portal users ??
1. Bulk publish (Sync) their SDE datastore connections and share accordingly
2. Create a few monster map documents and publish those from Pro.
3. Use a script to publish a single feature service for each layer.
Test so far prove that number 1 works OK. The tags and descriptions can be searched when finding layers.
Although I find the administration of the datastore a little cumbersome as I have to ensure the database connection username has access to the layer first.
Approach number 2 is not helpful because all the sub-layers of a feature service do not store their individual Tags or descriptions. So the user can't search for the individual layers.
Approach number 3. Is this worth pursuing ?
What do large ArcGIS Enterprise clients normally do here ?