We performed a comparison between SAP HANA and SQL Server based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Because SAP HANA’s users say its pricing, support, and ease of deployment could all be greatly improved, SQL Server ultimately wins out in this comparison.
"Anyone currently using SAP will be transitioning to HANA."
"The most valuable feature of SAP HANA is the interaction it provides with external suppliers and clients."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"If you want to scale with new processes and new reports, that's fairly easy."
"Integration is the most valuable feature we use SAP HANA for."
"It is very stable and very innovative. You can integrate many applications with it."
"SAP HANA is vertically and horizontally scalable."
"Eases management of databases."
"The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query."
"It will do clustering, so you can have two database servers looking at the same data simultaneously."
"It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"For my business requirements, the performance is good."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
"The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"The inclusion of a well-performing Time Machine is vital."
"Per SAP, you can do both transactional and analytical processes in SAP HANA. Though that's true, the speed is slower when you combine the two functions, so this is what I'd like SAP to improve in SAP HANA. In the next release, I want to see better diagrams in SAP HANA and a more user-friendly interface."
"There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature."
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project."
"SAP HANA is a very proprietary tool and there's not as much support available for it as there is for an SQL Server (which is more popular)."
"The only downside of the product is that it is an expensive solution that needs to consider lowering its prices to improve the product."
"Unlike other databases, it lacks management features that legacy databases like Oracle or SQL servers have. They need to make the solution easier to manage and offer tools that make management more effective. A lot of things you have on traditional databases you have to develop into HANA."
"The performance and integration with other products are areas in need of improvement."
"It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."
"SQL Server could improve the integration with nonrational database solutions, such as MongoDB."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"We have had problems implementing a data warehouse using SQL Server."
"Better integration with other platforms would be an improvement."
"I would say that people should know how to get a SQL setup in place since it might be an area where they lack when it comes to the solution."
"The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."
"The performance needs some improvement and it needs more features integrated into it."
SAP HANA is ranked 3rd in Relational Databases Tools with 81 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. SAP HANA is rated 8.4, while SQL Server is rated 8.4. The top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SAP HANA is most compared with Oracle Database, MySQL, IBM Db2 Database, Apache Spark and SAP Adaptive Server Enterprise, whereas SQL Server is most compared with MariaDB, Oracle Database, LocalDB, IBM Db2 Database and Teradata. See our SAP HANA vs. SQL Server 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.