topic Use managed Azure SQL database directly in ArcGIS Online? in ArcGIS Online Questions

Use managed Azure SQL database directly in ArcGIS Online?

EricCompas — Fri, 27 Oct 2023 15:35:07 GMT

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_SECTION1_7C4A982A87794DDFB8761322B7004AFA). Can a map service be published from ArcGIS Pro to ArcGIS Online using Azure SQL as a data source?

Thanks for your help,

Eric

Re: Use managed Azure SQL database directly in ArcGIS Online?

George_Thompson — Fri, 27 Oct 2023 15:40:01 GMT

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.

Re: Use managed Azure SQL database directly in ArcGIS Online?

EricCompas — Fri, 27 Oct 2023 15:50:09 GMT

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

Re: Use managed Azure SQL database directly in ArcGIS Online?

George_Thompson — Tue, 31 Oct 2023 14:43:47 GMT

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.