Use managed Azure SQL database directly in ArcGIS Online?

[EricCompas]

We're creating an Experience Builder map using data from a managed Azure SQL database that's regularly updated. Is there a way to use this data source through a direct connection? And, if not, what's the recommended data import/synchronization workflow?

I do see that ArcGIS Pro 3.1 does support Azure SQL Managed Instances (https://enterprise.arcgis.com/en/system-requirements/latest/windows/databases-in-the-cloud.htm#ESRI_...). Can a map service be published from ArcGIS Pro to ArcGIS Online using Azure SQL as a data source?

Thanks for your help,

Eric

[George_Thompson · Accepted solution]

I do not believe that it is possible to publish a map service directly from Azure SQL to Online, where Online is a data store or connected. Online is designed to either host (i.e. copy all the data into Online) or reference (service is being hosted by an external server, like ArcGIS Server) for services.

You could create a hosted layer and have a process from Pro to update at some frequency.

[EricCompas]

Thanks, George. Is there a workflow for regular updates that avoids Pro, e.g. Online Notebook?

[George_Thompson]

Not an easy way that I know of.

One potential option would be to make a REST service from the Azure SQL, then consume that service in an Online Notebook and then you may be able to use ArcPy there.