I am working on ArcGIS operation Dashboard. There is an widget on the top left corner “ Model Manager”. Here the Model manager will read the data from ForecastStage_MPT and ForecastTimePT database tables. These 2 database tables are in MS SQL server database. The data in these 2 tables are populated from NOAA. A script has been developed which will take the data from the NOAA website and populate the ForecastStage_MPT and ForecastTimePT database tables. My task is to read the data from the database tables into the ArcGIS operation dashboard model manager widget automatically. Do you have any idea how to read the MS SQL server database tables into the model manager widget? I am sending you 3 attachments and see if you can give me some directions.
Yes, you can upload your sql data to your layer (feature service), just use post rest api call for (appluedits or add feature) inside windows service.
Here is the fellow :
- export your sql data to csv files .
- import csv files to your arcgis online account.
- now you have a layer or feature service contains your sql data , make your layer editable.
- you can updates layers content by using API method like apllyedits and add features.