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

"The most value for us was in terms of using it to issue tenders online. We host our server, but it is open to the public, so clients who want to buy those tenders were able to go online, put their tender documents up, and we could evaluate them using SAP."
"Integration is the most valuable feature we use SAP HANA for."
"I would rate the stability a 10 out of 10, and it absolutely deserves that mark."
"The data storage requirement is reduced from the original database to the HANA database."
"The most valuable SAP HANA features are that, compared to Oracle, there is less administrative work and less complex work to handle, making it very straightforward."
"SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
"The benefits include high database loading performance, superior reporting performance, and ease of use."
"The solution is stable."
"The paramount advantage is the exceptional speed."
"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."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
 

Cons

"This is an expensive solution."
"HANA could be improved by adding analytics and development models in the institution."
"The product is very demanding on memory requirements."
"You cannot apply mulit-join inside the calculation views, for example, when you are joining tables."
"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."
"The main issue is the ecosystem, which lacks the widespread support that SQL enjoys."
"I don't have direct access to SAP, and instead, I need to go through the SAP office in India."
"The user experience should be better. Its user interface is not good. I also don't like the transition concept."
"We don't get good discounts in Pakistan."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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

"SAP HANA is an expensive product."
"The tool has a high price. I rate the solution’s pricing, one on a scale of ten, where one is expensive and ten is cheap."
"We pay $200 on a monthly basis."
"We pay for a maintenance license, and the licensing cost is high. In general, it is a very expensive solution."
"There is an annual license to use SAP HANA."
"The price of the solution could be reduced, it is expensive."
"It comes with a significant cost."
"SAP HANA is more expensive than other solutions."
"SingleStore is a bit expensive."
"The product's licensing is not expensive. It is comparable."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"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,032 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
14%
Financial Services Firm
10%
Comms Service Provider
8%
Government
5%
Financial Services Firm
30%
Computer Software Company
10%
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,032 professionals have used our research since 2012.