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 Sep 29, 2024
 

Categories and Ranking

Oracle Database In-Memory
Ranking in Embedded Database
3rd
Ranking in Relational Databases Tools
8th
Average Rating
8.8
Number of Reviews
29
Ranking in other categories
No ranking in other categories
SAP HANA
Ranking in Embedded Database
4th
Ranking in Relational Databases Tools
3rd
Average Rating
8.4
Number of Reviews
83
Ranking in other categories
Data Virtualization (2nd)
 

Mindshare comparison

As of November 2024, in the Embedded Database category, the mindshare of Oracle Database In-Memory is 28.2%, down from 39.3% compared to the previous year. The mindshare of SAP HANA is 24.7%, down from 29.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Embedded Database
 

Featured Reviews

Duy AnhMai - PeerSpot reviewer
Sep 12, 2024
Improved data processing speeds with enhanced security and processing efficiency
We use Oracle Database In-Memory to deploy applications for commercial purposes, store data securely, and ensure efficient data processing Oracle Database In-Memory has improved data storage and processing efficiency, which is crucial for handling large amounts of data in our products and…
Md Ashraful  Islam - PeerSpot reviewer
Dec 7, 2023
Powerful in-memory processing capabilities and advanced analytics, enhancing real-time decision-making, but with challenges in reaching SAP for support
The use case revolves around the ERP system, covering standard modules that begin with procurement, extend through sales, encompass the entire spectrum of business processes, including commercial aspects, inventory management, and production, and conclude with sales and financial tracking…

Quotes from Members

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

Pros

"We can integrate it with any data sources as well."
"Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"The scalability is very good."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The scalability of the solution is very good. It's able to support large amounts of data."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The solution is very fast."
"We use SAP HANA for Master Data Governance."
"Eases management of databases."
"The most valuable feature of SAP HANA is the interaction it provides with external suppliers and clients."
"When we upgraded, we received more functions or more features."
"Using this solution has given us better details for reporting and analytics."
"The UX experience is very good."
"We have found the solution to be customizable and it is beneficial it comes as a bundled package. Additionally, it is user-friendly."
"I like the integration process. Also, the data is trusted by our management, and we use the data from transactions for analysis."
 

Cons

"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"The product could benefit from enhancements in its graphical user interface."
"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."
"The pricing could be improved. It would ideal if it was more reasonable."
"The platform’s pricing needs improvement."
"Lacks sufficient integration with other tools."
"They should improve the solution's scalability for large databases."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"In terms of improvement, the speed is not as good as we thought it would be. That is why we are trying different solutions that will be built with different technologies."
"A documents preview could be helpful."
"Technical support should be more customer-friendly."
"There's an issue in the partition. When you record more than two million records, partitioning does not work well. In Oracle it's easy. SAP must resolve this issue in order to be more competitive with Oracle."
"SAP HANA's long run time to extract data could be improved upon."
"It is challenging to integrate it with third-party tools."
"The JDBC connectors are very slow."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
 

Pricing and Cost Advice

"It's quite costly and it comes with a fixed price."
"The platform's licensing cost needs improvement."
"The solution's pricing is high."
"The product is expensive."
"Database In-Memory is priced a bit higher than its competitors like Microsoft."
"There is a need to make a yearly payment towards the licensing costs, after which there is any to pay towards the support cost attached to the solution."
"Oracle Database In-Memory is expensive."
"The pricing is pretty good so I rate it an eight out of ten."
"We pay $200 on a monthly basis."
"The tool is expensive compared to other products, like Oracle R or Microsoft, but it offers a range of all the company's functions."
"It is expensive."
"The pricing is relatively high for both customers and partners."
"Setup and licensing require planning and proper budgeting, as it is not cheap."
"SAP HANA is more expensive than other solutions."
"While the cost of the license may seem high, it is important to note that the benefits of the solution far outweighs the cost."
"SAP HANA is affordable. I rate it a seven out of ten."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
815,854 professionals have used our research since 2012.
 

Top Industries

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

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
 

Learn More

 

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: October 2024.
815,854 professionals have used our research since 2012.