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

DuckDB vs SAP HANA comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 5, 2025

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

DuckDB
Ranking in Embedded Database
5th
Average Rating
9.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
SAP HANA
Ranking in Embedded Database
4th
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
84
Ranking in other categories
Data Virtualization (2nd), Relational Databases Tools (4th)
 

Mindshare comparison

As of February 2025, in the Embedded Database category, the mindshare of DuckDB is 11.3%, up from 1.8% compared to the previous year. The mindshare of SAP HANA is 7.7%, down from 13.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Embedded Database
 

Featured Reviews

AM
Highly efficient data processing, optimizes infrastructure, and offers good integrations
DuckDB is very fast. If we don't have enough memory, we can use swap. For instance, if we use a fast storage space, the system volume in Kubernetes could be a fast swap for DuckDB if we have memory limits. In our framework, DuckDB is five times faster than Spark in some cases. It has an extensive SQL dialect, many SQL Windows functions, and good integration with Polars. We can easily use SQL and Pandas framework in Python to process data.
Jayarami Reddy Pujeri - PeerSpot reviewer
Comprehensive system with real-time analytics for versatile industry applications
Our primary use case is working with various clients in industries such as pharmaceuticals and other services. We support clients as implementers of SAP HANA, providing expertise in functionality, finance, logistics, and processes The solution is very user-friendly and supports all kinds of…

Quotes from Members

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

Pros

"DuckDB is very fast."
"The in-memory database is excellent."
"The product handles high volumes very well and provides good integration."
"The solution is extremely stable. That's the most important aspect of the solution, for our organization. There is no downtime, and the performance is very good."
"We have found that the Fiori Apps are particularly good."
"The in-memory computing and the efficient response time are very good features."
"The functionality is of the solution is very good."
"The most valuable feature of SAP HANA is its performance and integration."
"It's very convenient and very innovative."
 

Cons

"Sometimes we have memory issues that cause job failures, which we don't fully understand why, but we can rerun the jobs without problems."
"Needs graphical programming without coding."
"High availability and disaster recovery are very poor in HANA."
"The solution's development platform should be more flexible and scalable to adapt to other solutions."
"The solution is very expensive for us."
"It's a complex initial setup."
"I'd just like to see some more improvements done on the training, both on the functional training and technical training sides as a part of the complete solution."
"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."
"The product is very demanding on memory requirements."
 

Pricing and Cost Advice

Information not available
"The solution's license is very expensive so I rate pricing a one out of ten."
"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."
"SAP HANA is affordable. I rate it a seven out of ten."
"The price of SAP HANA is very expensive and it is paid annually."
"There is a yearly subscription to use SAP HANA. There is a fee for maintenance."
"SAP HANA is very expensive here in China. My company bought the SAP ERP suite, which includes SAP HANA. For others who use SAP HANA as an analytical database, CPU numbers will affect the pricing, so as a solution, it's costly."
"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."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Manufacturing Company
15%
Computer Software Company
12%
Financial Services Firm
10%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for DuckDB?
We use the open-source version of DuckDB and don't have costs associated with it. There is a company that provides commercial software, but we use the open-source library, not the services.
What needs improvement with DuckDB?
Sometimes we have memory issues that cause job failures, which we don't fully understand why, but we can rerun the jobs without problems. There were also problems with binary formats in the previou...
What is your primary use case for DuckDB?
We use the concept of a feature store. We need the engine, and we use Feast as our feature store framework to build our feature store. We use the DuckDB engine as a data engine, which helps us move...
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...
 

Comparisons

 

Also Known As

No data available
SAP High-Performance Analytic Appliance, HANA
 

Overview

 

Sample Customers

Information Not Available
Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
Find out what your peers are saying about Firebird, SQLite, Oracle and others in Embedded Database. Updated: February 2025.
837,501 professionals have used our research since 2012.