A quick review of the HANA Platform - both Cloud native and on-prem
May 19, 2023

A quick review of the HANA Platform - both Cloud native and on-prem

Tom Turchioe | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Software Version

SAP HANA, enterprise edition

Overall Satisfaction with SAP HANA Cloud

Critigen/Locana is a Systems Integrator who are experts in ArcGIS / S4 / ECC integration. We also make Lemur which is an SAP Endorsed app that integrates with SAP Asset Manager.

Pros

  • Data Integration
  • Multi-model processing
  • high speed DBMS capable of large data volumes
  • Data virtualization

Cons

  • It's not easy to get data out of the HANA platform
  • Tuning in edge cases is difficult
  • Some small missing features have to be worked around
  • perception that it is "expensive" - this is a messaging issue, not a real issue
  • perception that it only runs ERP - SAP is a victim of it's own success in this regard
  • perception that it isn't an industrial strength DBMS when, in fact, it is
We are currently helping a handful of customers standup their as-built digital twin - the ArcGIS Utility Network (UN) - on the HANA platform. The UN is a system of record and services editors - the people who build out networks. Since the UN is services based, there is no data warehouse (aka publication geodatabase) needed as analysts want to leverage the capabilities of the UN. This means the single copy of data in the UN geodatabase is subject to analytic as well as transactional processing. The HANA architecture was designed to handle both OLAP and OLTP loads at the same time with minimal impact or no loss in performance. Analysts like Gartner have placed HANA Cloud in the leader quadrant for this capability - which directly benefits the way a utility network geodatabase is used - to service both analytics and transactional processing.
Utility customers benefit from the graph and spatial capabilities that the HANA platform provides. The spatial capabilities are OGC 1.1 compliant and meet the SQL/MM 2003 standards. This means any spatial system that is OGC compliant can store and query data in the HANA platform. I'm looking to find a way to leverage the other HANA platform capabilities. I'd also say the platform's capabilities for data integration, data federation are really powerful and should not be overlooked.
The ability to push work into the platform benefits performance. It also benefits data governance because the architecture is designed to minimize the need to move data. The information view (calc view) capability enables creation of virtual schemas like snow flake and cubes. Software like ArcGIS will automatically push work into the HANA platform (both cloud and on-prem) which greatly accelerates performance. Both companies (Esri and SAP) continue to look for ways to exploit HANA capabilities - often automatically.
I have deep knowledge of other disk based DBMSs. They are venerable technology, but the attempts to extend them to current architectures belie the fact they are built on 40 year old technology. There are some good columnar in-memory databases but they lack the completeness of capability present in the HANA platform.
For calls to support by our customers, the quality of support has been excellent.

Do you think SAP HANA Cloud delivers good value for the price?

Yes

Are you happy with SAP HANA Cloud's feature set?

Yes

Did SAP HANA Cloud live up to sales and marketing promises?

Yes

Did implementation of SAP HANA Cloud go as expected?

Yes

Would you buy SAP HANA Cloud again?

Yes

It is the ideal place to put an ArcGIS geodatabase especially the utility network. This is due to the data federation and data virtualization capabilities. HANA Cloud's ability to execute queries at scale and speed is very, very good. With respect to HANA Cloud vs. HANA Enterprise (on-prem), the additional connectors provided with HANA Cloud at no additional charge make it straightforward to integrate HANA Cloud into hyperscalar's data meshes - like AWS. In a lot of ways, HANA Cloud is a better value than on-prem because it includes all of the options including SDA/SDI and the connectors

Comments

More Reviews of SAP HANA Cloud