Our organization has a CMMS that updates a feature class on SDE anytime that a work order is closed. I would like to create a visual dashboard from this data, but do not want to have to constantly update a hosted layer. What is the best workflow for this situation.
Our GIS admin added configured Portal and Enterprise.
You can publish a web service from the enterprise geodatabase (aka. ArcSDE geodatabase) via ArcGIS Server (which is included with ArcGIS Enterprise). Then register the web service with either your ArcGIS Online organization or with Portal for ArcGIS (also included with ArcGIS Enterprise) - this will depend on where your using Operations Dashboard for ArcGIS (in AGOL or Portal for ArcGIS). When you create your web map, I would also set a refresh interval on the web service layer.
FYI: At ArcGIS Enterprise 10.6, Operations Dashboard was a separate installation for Portal for ArcGIS.
Hope this helps,