Is there a way to register a SQL dataset in AGOL like you can on an Enterprise Portal so that features update/append automatically? Our company has both an outfacing AGOL to the public and an internal Enterprise for private internal use. We have registered SQL databases for the Enterprise that overwrite and append automatically. Is there a similar service that can work for ArcGIS Online?
This is kind of a side note: Our company has two time zones that data is tracked in. Thus, we have two SQL datasets with different coordinate systems to account for the areas being in different time zones. Both datasets track the exact same assets and thus have identical schema as far as data fields go. When I create dashboards to encompass both areas, I do not wish to have two separate features for the same type of asset (i.e. Asset1_TimeZone1, Asset1_TimeZone2, Asset2_TimeZone1, Asset2_TimeZone2, etc.) Rather to reduce the clutter on the dashboards, I append the asset class for both time zones into one feature class with a shared projected coordinate system.
The issue with this is that this can be quite time consuming when you have to manually append the features each time the two separate SQL datasets are updated (which is often). Is there a script or model builder web to automate this process, or better yet something that can do this behind the scenes on its own (have the SQL layers automatically get converted to merged/appended hosted feature layers, with a shared coordinate system, every time a change is made to the SQL dataset)? This could be in real time or at scheduled times (reminder: this is on AGOL web services, not an Enterprise Portal).
