I am attempting to build an Operations Dashboard in our ArcGIS Online account using data from a SQL Server database. I’ve successfully added the data from SQL to ArcMap using the New Query tool, and published it to my AGOL account as a service. However, the data now on AGOL is static, it represents the data at the time I published it. The SQL database is constantly being updated (911 calls). Is it possible to get the data on my AGOL account to automatically update to represent the most current data stored in the SQL table?
*Note: the organization does not have an ArcGIS Server.