Esri study shows HANA Cloud is a good choice for your ArcGIS Enterprise Geodatabase

[TomTurchioe]

I've been blogging about SAP HANA Cloud, SAP HANA database as a great option for your enterprise geodatabase since 2021.  As long as HANA Cloud is in the same region and the same hyperscalar as SAP S/4HANA in RISE with SAP , you will get optimal performance by minimizing network latency.  I am elated that Esri has run this preliminary test and will run a more extensive test scaling user load at a later date.  They have confirmed what I've been blogging about for 4+ years!  If you want to check out all of my blogs on ArcGIS - SAP integration on SAP Community, you can read my blogs, you can view them all here. and here.

The blog in the ArcGIS Architecture Center (see my first blog on SAP Community for more information on Esri's work) describes a test Esri conducted to simulate a medium size gas utility running a standard set of real world workflows consisting of 15 editors and 200 web viewers.  The Utility Network consists of a dataset with a geographic extent of roughly 55,000 square miles, and with an overall size of approximately 45 GB. The dataset contained roughly nine million features, 700 sub-networks, and 300,000 gas meters.  Esri has run these same set of tests against #RISE with SAP and you can find details in that blog on how Esri runs these tests, what the workflows are and what other HANA related tests they've run.

Here are the performance graphs from the test that Esri just ran.  There is plenty of headroom (CPU, memory and disk) and workflows are executing in a timely fashion - workflows aren't building up because the system is running with good performance.  SAP HANA Cloud, SAP HANA database is using < 4% CPU (6th graph from the top on the left).

If you compare these results to the results from the RISE with SAP study that Esri ran in April, you will see there is plenty of headroom both on HANA Cloud and on the ArcGIS servers.  Even though this is a 1x expected load (15 editors and 200 web users), I expect when Esri runs 2x, 4x and higher number of users, HANA Cloud will behave similarly to the graphs below which show 8x the number of users against HANA cloud-resident in RISE with SAP .  This graph also shows Single VPC which means HANA cloud-resident and ArcGIS Enterprise in the same VPC.

ArcGIS on HANA in RISE with SAP

Performance is important, but what else does this mean to utilities who are in RISE with SAP and need to put their ArcGIS Enterprise landscape and geodatabase in the cloud?  It means that HANA Cloud is a viable choice that brings along with it the ability to expose SAP S/4HANA Plant Maintenance master and transactional data in workflows via ArcGIS Enterprise.  Not only does this produce more efficient workflows and business processes but this also means ArcGIS powerful spatial analytics can be applied to that master and transactional data within the context of asset location, DERs and power consumption (due to EV charging for instance).  With these two systems of record for a utility in the SAP Business Technology Platform , this opens the door to GeoAI and leveraging that data with SAP Business Data Cloud.

Even more compelling is that as SAP customers embrace SAP S/4HANA Cloud, extended edition, they can integrate their spatial, master and transactional data the same way because SAP HANA Cloud, SAP HANA database has the ability to connect to SAP S/4HANA Cloud, extended edition.. That means ArcGIS Enterprise can query ABAP CDS views to obtain master and transactional data on the fly - just like ArcGIS on SAP HANA and RISE with SAP S/4HANA.  What makes this possible is both SAP HANA (as of HANA 2 SPS8) and SAP HANA Cloud, SAP HANA database now support the ABAP ODBC driver which can connect to both on-prem and cloud resident S/4HANA instances as well as S/4HANA Cloud.

With SAP and Esri customers successfully leveraging the SAP - ArcGIS integration in both cloud, cloud resident and on-prem landscapes and Esri showing HANA Cloud performs well, now is the time put your geodatabases on SAP HANA Cloud, SAP HANA database and realize the same value that OGE, NiSource and others are.

Note: the screenshots are from the Esri studies linked to in this blog.  All rights belong to their respective owners.