Where is best place to host enterprise geodatabase?

PatrickMcKinney99

According to the documentation, Esri states "Connections from ArcGIS software to databases in the cloud must originate from machines in the same cloud. For best performance, connections should originate from machines in the same cloud region. In the majority of cases, connection and query performance is poor when you connect from ArcGIS clients installed on-premises to databases in the cloud or make connections between clients and databases in different cloud regions, and connections may time out."

I interpret this as, if you're going to have people in your organization connect to data in the enterprise geodatabase from computers on your network, then you should host your geodatabase on-premise and not in the cloud.

Can anyone confirm, or comment, on this interpretation? 

jcarlson

That's a good question! It's worth noting that a cloud-hosted GDB that is accessed through a published service does not experience the same hit to performance. You can even bulk-publish your database layers from a registered cloud connection, then manage user permissions in your Portal.

Are you planning to have users connecting directly to the database? If that's the case, then yes, on-premise is really the only way to go, as the performance hit with direct connections to the cloud are substantial.