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

SAP HANA vs SingleStore comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

SAP HANA
Average Rating
8.4
Number of Reviews
83
Ranking in other categories
Data Virtualization (2nd), Embedded Database (4th), Relational Databases Tools (3rd)
SingleStore
Average Rating
8.8
Number of Reviews
7
Ranking in other categories
Database as a Service (DBaaS) (7th), Vector Databases (12th)
 

Mindshare comparison

While both are Databases solutions, they serve different purposes. SAP HANA is designed for Embedded Database and holds a mindshare of 24.7%, down 29.7% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 1.2% mindshare, up 0.8% since last year.
Embedded Database
Database as a Service (DBaaS)
 

Featured Reviews

Md Ashraful  Islam - PeerSpot reviewer
Dec 7, 2023
Powerful in-memory processing capabilities and advanced analytics, enhancing real-time decision-making, but with challenges in reaching SAP for support
The use case revolves around the ERP system, covering standard modules that begin with procurement, extend through sales, encompass the entire spectrum of business processes, including commercial aspects, inventory management, and production, and conclude with sales and financial tracking…
Hitesh Kunchakuri - PeerSpot reviewer
Dec 18, 2023
A reasonably priced product that offers good speed and seamless support
Currently, I can't think of any areas that require improvement because SingleStore was recently launched in the market. The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings. The current SingleStore model provides output based on the RANK function. If a user searches for a liquor bottle, then with all the data the product has, it will search for the liquor bottle in the data, and based on a match, the product has an algorithm to rank the product because of which the paragraph that has the best match will be ranked as a 100, the next one as 99, following which the next product will be ranked as 98 and so on. The output from the solution will fetch you all the 100 products that are available in a store, but sometimes a user might require a product with a 97 or 98 percent match from the DB, meaning the product doesn't always work to provide a 100 percent match, an area I feel that can be optimized in the product. Currently, SingleStore's features are excellent as it can read documents, images, and everything. The product works seamlessly for me.

Quotes from Members

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

Pros

"Anyone currently using SAP will be transitioning to HANA."
"This is a feature-rich product and I like all of them."
"The best feature of SAP HANA is column computing. The computing speed of the solution is also very high, so developers can easily develop programs through SAP HANA."
"The most valuable features I have found are speed, dashboard, and reporting."
"It is very stable and very innovative. You can integrate many applications with it."
"We have found that the Fiori Apps are particularly good."
"The solution operates well."
"Using this solution has given us better details for reporting and analytics."
"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's initial setup phase was pretty straightforward, with no complex processes."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"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."
 

Cons

"The product is very demanding on memory requirements."
"The solution is very expensive for us."
"If the developers were to enhance or improve the application logic while processing the transactions, that would be great."
"The challenge right now is all databases are on S4 HANA architecture. You're running it for HANA, but not all the functionalities are available. If they can speed up getting all the databases on S4 HANA that would help."
"The initial setup of SAP HANA is complex. We did the implementation of one site, and a global deployment will take another three to four years."
"While SAP HANA is good, it would be better if it comes at a more affordable price."
"While new users to this solution have the benefit of the new design, existing ERP users may experience issues with migrating legacy data. We would like to see development of ready-made tools that allow for easy mapping when upgrading."
"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."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"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."
"We don't get good discounts in Pakistan."
 

Pricing and Cost Advice

"We are spending about 20,000 to 30,000 euros on the solution."
"The pricing is relatively high for both customers and partners."
"There is an annual license to use SAP HANA."
"The pricing is a bit on the high side."
"Its licensing is expensive for SMEs and large enterprises alike."
"SAP HANA is expensive, but unfortunately, we do not have any alternatives."
"The price of licensing is dependent on the size of the project, however, we have found that there is scope to negotiate the cost. If the solution is implemented on-premises there may be some extra costs for hosting etc."
"It is expensive, which isn't a problem for us because SAP HANA is processing the data so fast."
"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."
"SingleStore is a bit expensive."
"The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."
"I would advise users to try the free 128GB version."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
15%
Computer Software Company
13%
Financial Services Firm
9%
Government
6%
Financial Services Firm
30%
Computer Software Company
14%
Manufacturing Company
6%
Retailer
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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...
What do you like most about SingleStore DB?
The paramount advantage is the exceptional speed.
What is your experience regarding pricing and costs for SingleStore DB?
Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...
What needs improvement with SingleStore DB?
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation...
 

Comparisons

 

Also Known As

SAP High-Performance Analytic Appliance, HANA
No data available
 

Learn More

Video not available
 

Overview

 

Sample Customers

Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
6Sense, ADNOC, Adobe, Akamai, CARFAX, Cigna, Cisco, Comcast, DBS Bank, Dell, Dentsu, EY, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, Kakao, Kroger, LG, LiveRamp, Lumana, NBC, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, Siemens, SiriusXM, SK Telecom, SKAI, Sony, State Street Financial, STC, SunRun, TATA, Thorn, and ZoomInfo.
Find out what your peers are saying about Firebird, SQLite, Oracle and others in Embedded Database. Updated: October 2024.
814,649 professionals have used our research since 2012.