nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcMap 10.7.1 - client in Azure cloud in order to connect to SQL in Azure?

robert_at_work

Hi,

we have an ArcGIS Enterprise installation (10.7.1, Oracle SDE). We would like to do first steps into the cloud enviroment by creating a SQL dabase / service in Azure. Now the system requirements state:

10.7.1. - Link

"ArcGIS connections to Microsoft Azure must originate from machines within Microsoft Azure. "

Do I understand correctly - we won't be able to connect to any SQL DB/service in Azure as long as the clients are still "on prem"?

For 10.8.1 the phrasing is slightly different -

"Connections from ArcGIS software to databases in the cloud must originate from machines in the same cloud." - I could read as "if the client is in the cloud then it needs to be the same cloud as the database". I can also read as "if the database is in the cloud the client needs to be in the cloud as well" - so same as 10.7.1.

Can anyone shed some light on this? We will have ArcMap and ArcGISServer clients (10.7.1.) on prem for the foreseeible future. Can we move the (SDE) database into the cloud or not?

Thank you, Rob

Finde mehr Beiträge mit dem Tag

Microsoft Azure

Accepted answers

ChristopherPawlyszyn

I think it'd be safer to say there's no mechanism in place to prevent an on-premise client from connecting to a cloud-hosted database, but the technical limitation is that performance will suffer due to the increased latency. That technical limitation is the reason that Esri is unable to support such a configuration.

As a proof of concept it may work, but I would be extremely hesitant to implement a hybrid architecture in production due to the reasons I outlined above.

All comments

ChristopherPawlyszyn

The major problem you'll run into with on-prem clients accessing cloud RDBMS instances is the increased latency. The database connections are very chatty, so any increased network latency will be very noticeable with your desktop-based workflows. Some organizations have ExpressRoute links that reduce the latency to a reasonable threshold, but that also adds complexity to the networking side of things.

As a general rule of thumb, I would try a proof of concept where you access the cloud-hosted database from desktop clients and try some typical workflows and see if the increase in transaction times is tolerable.

Another aspect is that if the latency increases (due to ISP routing issues or changes in the network path), technical support cannot help with troubleshooting/identifying the issue since it is expressly discouraged in the documentation. The recommendation is that all components exist within the same datacenter/cloud provider region for the lowest latency and highest chance of success.

Some customers have also implemented a scheduled synchronization of on-prem and cloud enterprise geodatabases, which comes at the expense of lag time before the cloud database is up-to-date, but allows for the hybrid structure you're proposing.

robert_at_work

Hi Christopher,

thank you for your explantion. So - from a technical point of view ArcMap 10.7.1. can connect to SQL in Azure? There is no technical limitation that AcMap 10.7.1 client needs to be in Azure as well?

With regards to lantency - we just want to get started with Azure and test different options. The easiest step to start with is to move the database into the cloud.

Thanks Robert

ChristopherPawlyszyn

As a proof of concept it may work, but I would be extremely hesitant to implement a hybrid architecture in production due to the reasons I outlined above.

NiekGoorman1

Hi, we've had a 10.7.1 ArcGIS Enterprise install running on Azure VMs with SQL SDEs hosted in Azure as well. You can connect to it from other locations fine (e.g. ArcGIS Desktop) but it will be slow. For some SDE-intensive work I temporarily spun up an Azure VM to speed things up.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.