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) (2nd)
SingleStore
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
6
Ranking in other categories
Database as a Service (DBaaS) (11th), Vector Databases (15th)
 

Mindshare comparison

While both are Databases solutions, they serve different purposes. SAP HANA is designed for Embedded Database and holds a mindshare of 9.2%, up 7.6% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 3.0% mindshare, up 1.5% since last year.
Embedded Database Market Share Distribution
ProductMarket Share (%)
SAP HANA9.2%
SQLite23.4%
Firebird SQL17.8%
Other49.60000000000001%
Embedded Database
Database as a Service (DBaaS) Market Share Distribution
ProductMarket Share (%)
SingleStore3.0%
Amazon RDS14.8%
MongoDB Atlas12.7%
Other69.5%
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 valuable feature of SAP HANA is its performance and integration."
"It's user-friendly so long as you use it frequently."
"It's very convenient and very innovative."
"It's stable and reliable."
"SAP HANA has everything, and that is the advantage of SAP because you can get everything in one suite, whatever you need for your company."
"The functionality is of the solution is very good."
"One feature I find very valuable, is the response time of the application on the database memory."
"The most valuable feature of SAP HANA is the modeling of the databases."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The paramount advantage is the exceptional speed."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"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 ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
 

Cons

"In terms of improvement, the speed is not as good as we thought it would be. That is why we are trying different solutions that will be built with different technologies."
"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."
"It is challenging to integrate it with third-party tools."
"I would like more technical documentation. I would like it to be easier to find online help or have a better launch-based service. SAP has a lot of functions, so we need more best practices and more detailed documentation on industry solutions. For example, it would be good to have documentation on why a certain process needs to be set up and which kinds of configurations need to be set up."
"The SAP ERP processes are quite complex and it can be challenging."
"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 SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface."
"I cannot recommend this product to users. I feel that SAP's approach of mandating customers to go with SAP HANA is not a good point; they should make SAP HANA so good that customers willingly choose it."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"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."
"We don't get good discounts in Pakistan."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Having the ability to migrate servers using a single command would be extremely beneficial."
 

Pricing and Cost Advice

"SAP HANA is an expensive product."
"The pricing is a bit on the high side."
"The tool is expensive compared to other products, like Oracle R or Microsoft, but it offers a range of all the company's functions."
"We pay for a maintenance license, and the licensing cost is high. In general, it is a very expensive solution."
"We pay $200 on a monthly basis."
"The price of the solution could be reduced, it is expensive."
"Set up a consortium of consulting partners and hardware vendors to define your tech. Landscape TCO (total cost of ownership) and then approach the OEM for pricing (on-premise or on cloud or a hybrid model). Check if you can bring your own licenses for some of the existing application licenses on the new platform, to reduce TCO."
"Its licensing is expensive for SMEs and large enterprises alike."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"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."
"SingleStore is a bit expensive."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
881,227 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
14%
Financial Services Firm
10%
Comms Service Provider
8%
Computer Software Company
6%
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: December 2025.
881,227 professionals have used our research since 2012.