Azure SQL read scale-out and ArcGIS Publication Geodatabase

VishApte — Mon, 22 Feb 2021 00:26:35 GMT

Hi all,

I am in the process of architecting ArcGIS Enterprise 10.8.1 solution with Utility Network in Azure for a large Electricity distribution client. Client currently has on-premise solution with a geodatabase for editing (System of Record) and a geodatabase for publication (System of Engagement) Client wants to continue with similar architecture for ArcGIS Utility Network ie workload separation between network editors and web map/app users. Web App users will need to perform UN traces so publication database needs to maintain UN topology.

As I understand, geodatabase replication does not support Utility Network topology or anything that uses branch versioning. To meet client's requirements for the workload separation (UN editing vs web maps / web traces etc) we are thinking of proposing Azure SQL's read-only replica. As I understand, ArcGIS geodatabase connection strings support APPLICATIONINTENT=ReadOnly parameter. And that is all seems to be needed to access read-only replica in Azure SQL.

Does anyone have experience setting this up and can confirm if it works? Is this a valid/supported/certified configuration by ArcGIS Enterprise?

Thanks,

Vish

Re: Azure SQL read scale-out and ArcGIS Publication Geodatabase

Raj-Chavada — Fri, 02 Apr 2021 17:58:44 GMT

I am interested in this Architecture myself. Love to hear an overview or more details on how this can be setup.

Is the readonly replica a File Geodatabase?

Re: Azure SQL read scale-out and ArcGIS Publication Geodatabase

AGP — Wed, 17 Nov 2021 21:17:28 GMT

@VishApte, did you manage to set this up?

topic Re: Azure SQL read scale-out and ArcGIS Publication Geodatabase in Geodatabase Questions

Azure SQL read scale-out and ArcGIS Publication Geodatabase

Re: Azure SQL read scale-out and ArcGIS Publication Geodatabase

Re: Azure SQL read scale-out and ArcGIS Publication Geodatabase