What is SAP HANA?

Find out everything you need to know about SAP's in-memory database platform

SAP Innovation Center

SAP HANA is an in-memory database platform that allows data to be analysed at high speed by processing information stored in RAM memory, rather than having to access it from a hard disk or SSD. This enables other programs to work with vast quantities of data much more rapidly than they would otherwise be able to.

As its name suggests, SAP HANA was created by German software giant SAP and is still a proprietary product, with HANA standing for 'high performance analytic appliance'. However, many of the large enterprise hardware vendors, such as HPE, IBM and Dell Technologies, have products and services that are optimised for the software.

How does SAP HANA work?

SAP HANA, at its core, is a relational database management system. While that may sound rather boring and straight forward, if you want to carry out advanced data analytics at speed there's a lot more to get excited about under the bonnet.

HANA is built on another piece of SAP software, SAP In-Memory Database. This is a massively parallel processing data store that brings together column-based, row-based and object-based data storage methods. This foundation means that HANA can rapidly access and analyse data from most structured databases, as well as applications and systems, without any intervention or need for additional products to translate the information into a form that the software can read.

Depending on the source of the data, it can use three different types of data replication: Sybase (also known as Log-based); extract, transform, load (ETL)-based; and trigger-based. This replicated data is then stored in-memory (i.e. in RAM) so the applications connected to HANA can access it rapidly in real time.

What is SAP HANA used for?

SAP HANA is used for Big Data processing and analytics. Its function is to make the information stored in different databases and in different forms readily available to other applications.

While this may sound dry, it opens up a world of possibilities for new, disruptive businesses to emerge.

For example, French insurance firm Meteo Protect uses SAP HANA to generate weather insurance quotes for farmers based on the latest climate and weather data. The CEO, Gabriel Gross, credits HANA with enabling the company to go from being a startup pursuing a new form of "parametric insurance", to trading on Lloyd's of London insurance and reinsurance marketplace just seven years later.

It also opens up the possibility of optimising existing processes, like monitoring and optimising telecoms networks or energy usage.

What is the difference between SAP HANA and SAP S/4HANA?

The slightly confusingly-named SAP S/4HANA is an application designed to run on the SAP HANA in-memory database platform. Released in 2015, SAP S/4HANA is SAP’s latest enterprise resource planning (ERP) and business intelligence offering, using technologies such as machine learning, AI and advanced analytics to streamline business processes.

From improving production planning in manufacturing to simplifying accounting processes in finance, SAP S/4HANA can transform organisations’ business processes through intelligent automation. It can track and manage business resources, such as products, and manage and report on business commitments, such as payrolls and purchase orders. For a retailer, for example, it can provide real-time stock availability to customers, help with more effective and efficient supply-chain management, and use predictive analytics to identify and prevent delivery delays.

Related Resource

Accelerate your SAP S/4HANA journey with automation

Get to S/4HANA faster, at lower cost, with less risk

Download now

SAP S/4HANA is the fourth version of SAP Business Suite and is designed to be more user-friendly and intuitive than its predecessors. It can also solve more complex problems and handle much more data. While SAP S/4HANA is cloud-native, it is not limited to running on the cloud. It has flexible methods of deployment, including through public, private or hybrid cloud and on-premise.

What are the benefits of SAP HANA?

Did we mention that SAP HANA is fast? Because it really is, and this is its primary benefit. There are myriad other Big Data analytics services that can draw information from various sources, both structured and unstructured, and divine insights that can improve the way an organisation runs. But in the main, they can't do it in real time and at scale in the way that HANA does.

The platform is also updated with new features regularly every quarter for the cloud-based version and once a year for on-premise which most recently has included enhancements like AI and ML.

What are the drawbacks of SAP HANA?

The highest quality item on the shelf tends to be the most expensive, and in this case in-memory computing bears no exception. The cost per bit of SAP is higher than most database platforms, particularly for those that run SAP HANA on-premise or in hybrid environments which necessitate investment in hardware and RAM, significantly more expensive than other forms of memory.

Furthermore, HANA is only really compatible with SAP or SUSE Linux certified hardware. If not already owned, the up-front costs of migration continue to stack-up. For users wanting to run the software on any other kind of hardware, major issues come to the fore as licensing prices are very high.

For some, the advanced capabilities of the software are also a drawback. It can be difficult to extract value proportionate with investment. Some developers who continue with their usual ways of working with databases don’t use SAP HANA to its full potential, only using it as a fast in-memory database. For smaller enterprises that produce only small amounts of data, and for those producing unstructured data that can’t be stored in database format, this is also true. 

It’s clear that SAP HANA won’t be useful for everyone. Businesses must ensure they have the right use case for rapid analytics, as well as the right budget in place, before making the decision to invest.

Featured Resources

How to scale your organisation in the cloud

How to overcome common scaling challenges and choose the right scalable cloud service

Download now

The people factor: A critical ingredient for intelligent communications

How to improve communication within your business

Download now

Future of video conferencing

Optimising video conferencing features to achieve business goals

Download now

Improving cyber security for remote working

13 recommendations for security from any location

Download now

Most Popular

How to connect one, two or more monitors to your laptop

How to connect one, two or more monitors to your laptop

25 Feb 2021
How to find RAM speed, size and type

How to find RAM speed, size and type

26 Feb 2021
Ransomware operators are exploiting VMware ESXi flaws

Ransomware operators are exploiting VMware ESXi flaws

1 Mar 2021