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.
"I like MySQL's feature that helps to automate things."
"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
"MySQL is a scalable tool. Scalability-wise, I rate the solution a nine out of ten...The solution's technical support is good. I rate the technical support a nine out of ten."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"The deployment process is pretty fast."
"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"It's stable and reliable."
"The solution offers advanced features that the company was struggling to implement."
"SAP HANA is a stable solution."
"The solution is very stable."
"The in-memory database is excellent."
"We appreciate that the current, redesigned version of this solution that is much more straightforward for new users, and has been well thought out with industry best practice standards in mind."
"It is a stable solution...It is a scalable solution."
"The most valuable features are the flexibility and the integration with other solutions in data quality."
"It isn't as reliable as an SQL Server."
"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."
"The GUI could improve to make MySQL better."
"I would like to see some improvements in the solution’s integration aspects."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"Scalability could be improved."
"MySQL could be improved by adding more automation."
"Improvements are required in character set support, scalability, and big data sets."
"The solution's development platform should be more flexible and scalable to adapt to other solutions."
"When we are using SAP HANA we have some difficulty with the customization. We would like to be able to add and make customized menus."
"This is an expensive solution."
"The user interface and CRM need to be more user-friendly."
"The SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface."
"The product lacks some flexibility in its settings and configurations."
"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."
"SAP HANA is not perfect and they could improve by having more options and more integration."
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 4th in Relational Databases Tools with 35 reviews while SAP HANA is ranked 3rd in Relational Databases Tools with 45 reviews. MySQL is rated 8.6, while SAP HANA is rated 8.6. 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, MariaDB, Oracle Database, SQL Server and Percona Server, whereas SAP HANA is most compared with Oracle Database, SQL Server, IBM Db2 Database, Apache Spark and Oracle Database In-Memory. 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.