We performed a comparison between MYSQL and. SAP HANA based on our users’ reviews in four categories. After reading the collected data, you can find our conclusion below.
Comparison of Results: Based on the parameters we compared, MYSQL seems to be the superior solution. Our reviewers feel that the question concerning whether or not SAP HANA is easy to deploy, the features that it lacks, and its expensive price tag make MYSQL the better investment.
"The feature I found most valuable is activity performance."
"The solution is easy to use."
"The tool is open-source and there is no cost involved in its use."
"I am totally satisfied with MySQL."
"A good traditional database that supports JSON."
"The solution is very stable."
"It's a mature solution that's been around for decades."
"The fact that it is free is what appeals to me the most."
"It is very stable and very innovative. You can integrate many applications with it."
"The solution is very stable."
"The most valuable feature of SAP HANA is the modeling of the databases."
"We have found that the Fiori Apps are particularly good."
"It's stable and reliable."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"It's user-friendly so long as you use it frequently."
"We can save data very easily."
"MySQL could be improved by adding more automation."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"I would like to see the automatic backup feature in the solution as well. Data is very important and we need to preserve it in a safe place. It would be good if MySQL can back up the data automatically."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"Integration is a key feature in need of improvement."
"The integration with other systems can be improved as can the integration between other databases."
"HANA could be improved by adding analytics and development models in the institution."
"The product lacks some flexibility in its settings and configurations."
"Uses a large amount of RAM and is costly."
"The SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface."
"I would like to see improvements in the connectivity of the solution with other BI software. Not every software can connect to it natively."
"SAP HANA is not perfect and they could improve by having more options and more integration."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"In my limited experience using SAP, the process of granting access to different modules is difficult. Specifically, the requirement to assign roles and key codes to users rather than being able to assign them individually made the process more complex. It would be beneficial if there was a way to assign key codes separately, rather than having to create multiple roles. This would make managing access easier."
MySQL is an open-source relational database management system (RDBMS) owned by Oracle. Before Oracle acquired the product, it was completely free for users. After the merge, the solution started offering paid services with more features, alongside a free version. MySQL can easily integrate with a wide variety of programming languages, which makes it one of the most flexible and reliable products among its competitors. This cost-effective solution helps users deliver high-performance and scalable database applications through several products. They include:
My SQL Features
The characteristics of each MySQL edition differ depending on what it offers and what clients it is catered towards. But the main features of the product include the following:
MySQL brings many benefits to organizations that use it for their data. The most common ones include:
Reviews from Real Users
According to a database engineer at a retailer with more than 10,000 employees, MySQL is a great open-source product that offers great scalability and compatibility.
Yong S., a solutions specialist, system integration, appreciates this product because it has different licensing options and is easy to set up.
SAP HANA, also known as SAP High-performance Analytics Appliance, is a multi-model database that stores data in its memory, allowing users to avoid disk storage. The product combines its robust database with services for creating applications. SAP HANA is faster than other database management systems (DBMS) because it stores data in column-based tables in main memory and brings online analytical processing (OLAP) and online transaction processing (OLTP) together.
The column-oriented in-memory database design allows users to run high-speed transactions alongside advanced analytics, all in a single system. This provides companies with the ability to process very large amounts of data with low latency and query data in an instant. By combining multiple data management capabilities, the solution simplifies IT, helps businesses with innovations, and facilitates digital transformation.
The solution is structured into five groups of capabilities, categorized as:
There are three more SAP products that work alongside SAP HANA and complete the experience for users together. SAP S/4HANA Cloud is a ready-to-run cloud enterprise resource planning (ERP). SAP BW/4HANA is a packaged data warehouse, based on SAP HANA, which allows users to consolidate data across the enterprise to get a consistent view of their data. Finally, SAP Cloud is a single database as a service (DBaaS) foundation for modern applications and analytics across all enterprise data. All three products can combine with SAP HANA to deliver to users an optimized experience regarding their data.
SAP HANA Features
Each architectural group of capabilities of SAP HANA has various features that users can benefit from. These include:
SAP HANA Benefits
SAP HANA provides many benefits for its users. These include:
Reviews from Real Users
According to a database consultant at a pharma/biotech company, SAP HANA is a very robust solution with good data access.
Bruno V., owner at LAVORO AUTOM INF E COM LTDA, likes SAP HANA because the product offers advanced features, helps reduce hours, and makes it easy to find what you need.
MySQL is ranked 3rd in Relational Databases Tools with 44 reviews while SAP HANA is ranked 4th in Relational Databases Tools with 42 reviews. MySQL is rated 8.0, while SAP HANA is rated 8.4. The top reviewer of MySQL writes "A great open-source product that offers great scalability and compatibility". On the other hand, the top reviewer of SAP HANA writes "Good integration capabilities, easy to implement, and reliable". MySQL is most compared with Firebird SQL, Oracle Database, MariaDB, SQL Server and Teradata, whereas SAP HANA is most compared with Oracle Database, SQL Server, IBM Db2 Database, Apache Spark and Teradata. See our MySQL vs. SAP HANA report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.