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

SAP HANA vs SingleStore comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

SAP HANA
Average Rating
8.4
Reviews Sentiment
6.3
Number of Reviews
93
Ranking in other categories
Data Virtualization (2nd), Embedded Database (2nd), Relational Databases Tools (3rd), Database Management Systems (DBMS) (4th)
SingleStore
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
6
Ranking in other categories
Database as a Service (DBaaS) (17th), Vector Databases (17th)
 

Mindshare comparison

While both are Databases solutions, they serve different purposes. SAP HANA is designed for Embedded Database and holds a mindshare of 9.7%, up 7.8% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 2.9% mindshare, up 1.6% since last year.
Embedded Database Market Share Distribution
ProductMarket Share (%)
SAP HANA9.7%
SQLite21.6%
Firebird SQL16.6%
Other52.099999999999994%
Embedded Database
Database as a Service (DBaaS) Market Share Distribution
ProductMarket Share (%)
SingleStore2.9%
Amazon RDS13.5%
MongoDB Atlas12.3%
Other71.3%
Database as a Service (DBaaS)
 

Featured Reviews

HP
SAP Analytics Lead at Miracle Software Systems, Inc
Performs well with high database and reporting performance
We face difficulties replicating the AC DOCA table, which is a huge table, from S/4HANA to SAP HANA BAS, Business Application Studio, or HANA Studio using SLT. For developing Power BI reports using the AC DOCA table, we are replicating full data daily. We want to implement delta load, and while we used OData service for one client, the delta OData service link is not properly updating delta records. Licensing costs with SAP HANA are very high. Due to high pricing, many clients are moving from BW on SAP HANA and S/4HANA to Azure SQL. I have worked with several clients who have moved all data flows to Azure and developed Power BI queries on top of Azure. Many clients are also using Google Cloud Platform (GCP). The certification costs are also very high, more than ₹1,40,000 INR. Previously, it was ₹30,000 to ₹40,000. I want to pursue three certifications but am unable to do so due to the cost.
VK
Solution Architect at Wipro Limited
An excellent choice for diverse data processing needs with exceptional in-memory capabilities, robust failover mechanisms, easy scalability and high performance
Scalability is its key strength. Adding servers for scalability is a straightforward process involving simply incorporating a few additional servers and recycling the cluster triggers automatic repartitioning and redistribution of data. For instance, if the initial database creation involved a hundred servers and later, four more servers are added, specific commands can be executed to increase the partitions to one hundred twenty. The data is then efficiently redistributed across the expanded partitions without the need for manual data movement, ensuring a seamless and efficient scalability process. In my current organization, approximately three projects involve the usage of SingleStore, with a team size ranging from ten to twenty individuals.

Quotes from Members

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

Pros

"In comparison with other DMS solutions, it offers good performance."
"The UX experience is very good."
"Implementing SAP HANA offers financial benefits to the organization."
"The solution is very stable."
"We've had good experiences with technical support."
"The solution is easy to scale."
"Using this solution has given us better details for reporting and analytics."
"One feature I find very valuable, is the response time of the application on the database memory."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The paramount advantage is the exceptional speed."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
 

Cons

"It would be nice to know when SAP plans to stop its maintenance of a previous version of SAP ECC ERP because, at this point, anyone utilizing SAP will have no choice but to go on S/4HANA Database."
"The inclusion of a well-performing Time Machine is vital."
"I would like to see improvements in the connectivity of the solution with other BI software. Not every software can connect to it natively."
"The relationship with a partner that sells SAP could be better. We depend much more on our own development, and the partner is for selling us the solutions, so we need them to be able to supply help and answers. The partner isn't very helpful, and we have to rely on our own knowledge and research."
"HANA could be improved by adding analytics and development models in the institution."
"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."
"In practice, SAP HANA is very powerful, but I see areas where it could be improved to make life easier for users and teams, such as having too many Fiori apps with overlapping functionality, navigation not being intuitive for finance users, and users still needing to switch between Fiori and SAP GUI."
"The surface side or Attack dashboard needs improvement because there are some gaps after sales services."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"We don't get good discounts in Pakistan."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
 

Pricing and Cost Advice

"Price-wise, the product falls on the higher side of the spectrum. There is no need to pay for maintenance and support additionally. Support is available for bug fixes in the product."
"There is a yearly subscription to use SAP HANA. There is a fee for maintenance."
"SAP HANA is expensive, but unfortunately, we do not have any alternatives."
"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 an expensive product."
"Setup and licensing require planning and proper budgeting, as it is not cheap."
"The price of this product is good."
"Its licensing is expensive for SMEs and large enterprises alike."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"The product's licensing is not expensive. It is comparable."
"SingleStore is a bit expensive."
"I would advise users to try the free 128GB version."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
882,410 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
14%
Financial Services Firm
9%
Comms Service Provider
8%
Retailer
5%
Financial Services Firm
30%
Computer Software Company
9%
Comms Service Provider
8%
Retailer
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise62
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
 

Questions from the Community

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...
Ask a question
Earn 20 points
 

Comparisons

 

Also Known As

SAP High-Performance Analytic Appliance, HANA
No data available
 

Overview

 

Sample Customers

Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
400+ customers including: 6sense, Adobe, Akamai, Ant Money, Arcules, CARFAX, Cigna, Cisco, Comcast, DELL, DBS Bank, Dentsu, DirectlyApply, EY, Factors.AI, Fathom Analytics, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, impact.com, Kroger, LG, LiveRamp, Lumana, Nvidia, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, SegMetrics, Siemens, SiteImprove, SiriusXM, SK Telecom, SKAI, SONY, STC, SunRun, TATA, Thorn, ZoomInfo.
Find out what your peers are saying about SQLite, SAP, Firebird and others in Embedded Database. Updated: January 2026.
882,410 professionals have used our research since 2012.