Try our new research platform with insights from 80,000+ expert users

Oracle Database In-Memory vs SAP HANA comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 5, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Oracle Database In-Memory
Ranking in Embedded Database
3rd
Ranking in Relational Databases Tools
8th
Average Rating
8.8
Reviews Sentiment
8.3
Number of Reviews
30
Ranking in other categories
No ranking in other categories
SAP HANA
Ranking in Embedded Database
4th
Ranking in Relational Databases Tools
4th
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
84
Ranking in other categories
Data Virtualization (2nd)
 

Mindshare comparison

As of February 2025, in the Embedded Database category, the mindshare of Oracle Database In-Memory is 7.8%, down from 17.0% compared to the previous year. The mindshare of SAP HANA is 7.7%, down from 13.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Embedded Database
 

Featured Reviews

Md Al-Amin - PeerSpot reviewer
Ensures that users experience a good return on investment
Firstly, a user should prepare the operating system for installation, and then we have to copy the software to install the product. When dealing with scenarios related to Oracle Real Application Clusters, users need to add nodes and storage. The setup process is a little bit complex compared to DB2. The setup process of Oracle Database In-Memory takes around five to six hours to install Oracle Real Application Clusters, if everything is okay, apart from which the other processes will take a day. The solution is deployed on an on-premises model. The cloud-based solution is available for testing and development, and it need not be installed in your environment. A user just needs to do a few clicks and select the database, after which it automatically gets installed in the cloud. Only in the on-premises version of the product, there is a need to do some work in the tool.
Jayarami Reddy Pujeri - PeerSpot reviewer
Comprehensive system with real-time analytics for versatile industry applications
Our primary use case is working with various clients in industries such as pharmaceuticals and other services. We support clients as implementers of SAP HANA, providing expertise in functionality, finance, logistics, and processes The solution is very user-friendly and supports all kinds of…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product offers high scalability."
"The solution's most valuable feature is its performance optimization within our hardware environment."
"The solution's ROI is excellent."
"The solution is very fast."
"The scalability is very good."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"The speed at which it gets the data is great."
"SAP HANA is one of the best databases known for its performance...The new version of the solution is stable."
"SAP HANA's most valuable features are monitoring, reporting, and price and stock control."
"When we upgraded, we received more functions or more features."
"The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution is quite fast."
"The user interface is very good. You can do any kind of reporting analytics from the platform."
"The feature I found most valuable in SAP HANA is modeling. I also like that the solution has good integration and you can integrate it with any system, even third-party systems."
"It is a stable solution...It is a scalable solution."
 

Cons

"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"They should lower the price. My customers think that it's too expensive."
"Lacks sufficient integration with other tools."
"The high cost of the product is an area of concern where improvements are required."
"They should improve the solution's scalability for large databases."
"The solution is quite expensive."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"FI, or the financial module of SAP, has room for improvement. It has to have some better localization for the Middle East, especially in regards to taxes and the letter of credit cycle. I would like to see better localization from the HCM."
"They can improve their technology for the CRM subsystem. There are other products that are better and more effective for the CRM subsystem. Its price could be better. It is expensive."
"The SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface."
"When you do a report on a non-SAP platform, you face some compatibility problems."
"The pricing is expensive."
"The solution is very expensive for us."
"This is an expensive solution."
"In a future release, SAP HANA should add a module for taxation, such as income tax and withholding tax."
 

Pricing and Cost Advice

"Oracle Database In-Memory is expensive."
"The pricing is pretty good so I rate it an eight out of ten."
"The platform's licensing cost needs improvement."
"I rate the pricing a zero out of ten because Database In-Memory is too costly."
"The solution's pricing is high."
"It's quite costly and it comes with a fixed price."
"Database In-Memory is priced a bit higher than its competitors like Microsoft."
"The product is expensive."
"The price of the solution could be reduced, it is expensive."
"We pay for a maintenance license, and the licensing cost is high. In general, it is a very expensive solution."
"The tool has a high price. I rate the solution’s pricing, one on a scale of ten, where one is expensive and ten is cheap."
"People who are technical will accept the cost, but financially they will assess whether this solution will bring them revenue or not. People often ask, how will I profit when the cost is so high?"
"The price of SAP HANA is very expensive and it is paid annually."
"The price is high and could be a bit cheaper."
"Setup and licensing require planning and proper budgeting, as it is not cheap."
"The licensing cost for SAP HANA is approximately $200 per user per month."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
9%
Government
9%
Manufacturing Company
15%
Computer Software Company
12%
Financial Services Firm
10%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Database In-Memory?
We can integrate it with any data sources as well.
What is your experience regarding pricing and costs for Oracle Database In-Memory?
Oracle Database In-Memory is very expensive. Additionally, there are extra costs for some features.
What needs improvement with Oracle Database In-Memory?
Oracle Database In-Memory is more expensive than Azure, and the support from the Oracle team is not very good, especially since they do not have a support team in our region.
What are the biggest benefits of using SAP HANA?
Based on my work with SAP HANA, the biggest benefit that it can bring to your business is total data management. This product is by SAP - a company that serves almost all needs a client may have co...
Is SAP HANA’s customer and technical support reliable?
We have been using SAP HANA for a fairly short period of time and have only taken advantage of their customer support. So far, we have not had issues that required specialized help from technical s...
Is SAP HANA difficult to set up and start using?
SAP HANA is fairly easy to set up, however, I do not think a complete beginner can do it. You certainly need some preparation - either you need to have experience with similar solutions, or with ot...
 

Also Known As

No data available
SAP High-Performance Analytic Appliance, HANA
 

Overview

 

Sample Customers

Shanghai Customs
Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
Find out what your peers are saying about Oracle Database In-Memory vs. SAP HANA and other solutions. Updated: January 2025.
837,501 professionals have used our research since 2012.