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

MySQL 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:
 

ROI

Sentiment score
6.5
Calculating MySQL ROI is challenging due to its open-source nature, but it offers substantial cost-effectiveness and productivity benefits.
Sentiment score
2.8
SAP HANA offers varying ROI and performance improvements, but integration challenges affect its full potential in ERP transitions.
We do not feel we're getting value for the investment due to the additional resources needed for integration and maintenance.
 

Customer Service

Sentiment score
6.8
MySQL relies on community-driven support, providing forums and documentation, with varying ratings for Oracle's enterprise-level assistance.
Sentiment score
9.5
SAP HANA customer service excels, but technical support varies, with inconsistent expertise and mixed user experiences, needing improvement.
We have no issues and usually receive timely responses.
The support is lacking and not worth the premium price.
 

Scalability Issues

Sentiment score
6.9
MySQL offers scalable solutions for small to large applications with optimization and hardware upgrades enhancing performance and capacity.
Sentiment score
8.6
SAP HANA scales efficiently, supporting diverse user volumes and enterprise needs, despite increased costs, ensuring robust performance and minimal downtime.
Our operations have grown from a hundred data operations a day to as many in a couple of seconds.
 

Stability Issues

Sentiment score
7.8
MySQL is praised for stability, though issues may arise with large tables; proper resources and configuration are essential.
Sentiment score
7.4
SAP HANA is considered stable and reliable with improvements in version 2.0, though some minor glitches were reported.
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar.
 

Room For Improvement

MySQL faces criticism for InnoDB complexity, limited features, scalability issues, and needs enhanced clustering, documentation, and cloud integration.
SAP HANA faces cost, usability, integration, and performance challenges, requiring better user experience, training, and support enhancements.
It could be more beneficial if MySQL can enhance its data masking functionality in the same way it has improved data encryption.
The main issue is the ecosystem, which lacks the widespread support that SQL enjoys.
 

Setup Cost

MySQL offers open-source free editions, but enterprise editions with advanced features and support incur additional costs, requiring commercial licenses.
SAP HANA is seen as costly, yet valued for speed and integration, with cloud options potentially more affordable.
It's a recurring subscription model, which is expensive compared to legacy systems with just a maintenance fee.
 

Valuable Features

MySQL is popular for its performance, scalability, ease of use, open-source model, and strong community support across platforms.
SAP HANA excels in real-time processing, integration, and analytics, offering speed, efficiency, and robust data management for enterprises.
With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment.
This architecture allows for faster data processing and real-time analytics that were not possible with traditional databases.
 

Categories and Ranking

MySQL
Ranking in Relational Databases Tools
3rd
Average Rating
8.2
Reviews Sentiment
7.5
Number of Reviews
148
Ranking in other categories
Open Source Databases (1st)
SAP HANA
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), Embedded Database (4th)
 

Mindshare comparison

As of February 2025, in the Relational Databases Tools category, the mindshare of MySQL is 8.4%, down from 9.0% compared to the previous year. The mindshare of SAP HANA is 12.0%, up from 10.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Naresh Kumar - PeerSpot reviewer
Lightweight and is available at a friendly price
In terms of our organization's data management strategy, especially if I talk about PLM software, which is about data management and can be regarded as the core data management of the products that we make. When we are designing something, specifically a new product, it is a critical area, especially considering that I am in the energy sector. In the energy sector, when we are building huge turbines and other things, the data might have intellectual property aspects attached to it. Even within the company, one region cannot see other regions to the extent to which the product offers security. In my company, we use PDM and PLM from Teamcenter effectively. MySQL is not a tool my company uses in production. When we create some small demos, we use MySQL. For production, we would use only Oracle because it is the most stable tool in the market. When we install Teamcenter, we don't need to touch the database. We just need to make some references to figure out this is the database, and it automatically creates everything. The basic thing about PDM and PLM systems is that the user should never touch the database because people may corrupt the data model or do anything that will have a very bad impact on the system. Database modifications only have to be made to the PLM system. We are not supposed to interact with the database directly. The tool is very lightweight, less expensive, and sometimes it is free. It is a very usable tool that is preferred by a lot of people. Only for production use, I may ask people not to use it. Integration of MySQL is like how we don't directly integrate PLM with Oracle. We have to use PLM's APIs to talk to the database. As a part of the best practices, we should not directly integrate anything with the PLM database. Feature-wise, the integration capabilities of the product are easy to use. It is like any other tool where if there is a table, there is a property. If you want to map a property using any middleware, then we can easily do that. I recommend the product to others. For medium-sized companies, MySQL is one of the best solutions. Medium-sized companies can choose not to go for Oracle, which is very expensive. In terms of the value or benefits derived by our company from the use of the product, I would say that it is not very expensive and provides performance along with scalability. The product can cater to the needs of customers ranging from 2,00,000 to 6,00,000 to 10,00,000 records. Even 20,00,000 records are fine, but after that, users may get into trouble. It is the best tool for mid-sized companies with a reasonable amount of data. I rate the tool an eight out of ten.
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…
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
832,138 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Financial Services Firm
11%
Manufacturing Company
7%
Government
7%
Manufacturing Company
15%
Computer Software Company
12%
Financial Services Firm
10%
Energy/Utilities Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...
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...
 

Comparisons

 

Also Known As

No data available
SAP High-Performance Analytic Appliance, HANA
 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
Find out what your peers are saying about MySQL vs. SAP HANA and other solutions. Updated: January 2025.
832,138 professionals have used our research since 2012.