Overview of SAP HANA features and how it’s being used today
There has been a lot of hype around SAP HANA since it became available nearly a decade ago, but what is it exactly and what role should it play in your organization today?.
Nearly a decade has passed since the introduction of SAP HANA. Now that the hype has died down and the product has stabilized, where does it fit into modern IT and application landscapes? Because HANA is more than one thing, that question depends heavily on the use case, the maturity of the SAP HANA features and functionality, as well as the competitive landscape.
Here’s how to start thinking clearly and skeptically about how HANA should be positioned in your organization today.
What HANA is today
The first order of business is to answer the question of what exactly HANA is. During its infancy, SAP originally pursued a single-tier strategy with HANA. The idea was to collapse the traditional stack that consisted of application and database servers into a single platform based on HANA.
HANA has since changed, and with good reason, but the enduring monument to that strategy is that SAP has thrown everything but the kitchen sink into the platform. HANA now includes dozens of components that fall into three broad categories:
Data processing and storage. These capabilities include the original hybrid columnar in-memory database engine, database management and graph database features, as well as geospatial database, document database and machine learning features. While the architecture of HANA’s database engine goes by many names, hybrid columnar in-memory is still the best description because it captures a clever architecture that is both partially columnar and partially in-memory. This allows for many of the advantages of columnar and in-memory approaches while avoiding the massive drawbacks of fully columnar and fully in-memory architectures.
Application platform. The application’s capabilities were originally based on the XS server-side JavaScript application server, but since the HANA 2.0 upgrade, the applications run on the SAP HANA Extended Application Services (XS advanced) server, which offers a more flexible, container-based platform based on Cloud Foundry. XS advanced supports Java and JavaScript, as well as Python, PHP and other languages — with the use of custom build-packs.
Data integration. These integration features enable HANA to interact with other data platforms, offering the possibility of a single federated data model. Smart Data Access and Smart Data Integration allow for varying degrees of federated or replicated access to external data in traditional databases, Spark controllers, the Hadoop Distributed File System and other platforms. These features also form the foundation for some of HANA’s data tiering options, which admins can use to store data on less expensive platforms.
Strengths, weaknesses and use cases
Because of the differing strengths of varying SAP HANA features, the question of positioning HANA in an organization comes down to the use cases.
While specific SAP HANA features must be evaluated separately, its traditional SQL-based data processing and storage features are the most advanced, widely used and stable. Meanwhile, customers seem to use the application platform, non-SQL database features and data integration features less often, as they lag a bit further behind in stability.
Because of the differing strengths of varying SAP HANA features, the question of positioning HANA in an organization comes down to the use cases. The following are a few use cases from SAP customers where HANA is a candidate:
Running S/4HANA or BW/4HANA. In this case, there isn’t a great deal of choice, and HANA shines when running these purpose-built applications that make use of its strongest features, namely the hybrid columnar in-memory engine.
General-purpose database management system (DBMS). While database use cases vary greatly in terms of workload, for many, HANA is in the competition for best of breed for database performance and scalability. The sweet spot for HANA is workloads that require both transactional and analytical characteristics.
Application platform. SAP customers will often consider HANA as a general purpose application platform for business applications that may or may not integrate with S/4HANA.
SQL Data Warehouse. HANA provides data warehousing modeling features. Its strength as a SQL database can make it a contender in this space.
Machine learning and data science platform. HANA has built-in machine learning and text analysis features.
How to make a decision
When deciding whether HANA is a good fit for any given use case, it is best to consider the level of maturity of the HANA capabilities for that particular use case compared to the other options. You should also consider the cost, the commitment of SAP to the functionality and the availability of people with the skill set necessary to make the capabilities of HANA perform at their highest potential
Ethan Jewett
Owner & Consultant – Coredatra LLC