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

Dremio vs SAP Business Warehouse comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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

Dremio
Ranking in Cloud Data Warehouse
6th
Average Rating
8.6
Reviews Sentiment
7.1
Number of Reviews
8
Ranking in other categories
Data Science Platforms (9th)
SAP Business Warehouse
Ranking in Cloud Data Warehouse
14th
Average Rating
7.8
Reviews Sentiment
6.3
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of August 2025, in the Cloud Data Warehouse category, the mindshare of Dremio is 10.1%, up from 6.9% compared to the previous year. The mindshare of SAP Business Warehouse is 1.7%, up from 1.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

KamleshPant - PeerSpot reviewer
Solution offers quick data connection with an edge in computation
It's almost similar, yet it's better than Starburst in spinning up or connecting to the new source since it's on SaaS. It is a similar experience between the based application and cloud-based application. You just get the source, connect the data, get visualization, get connected, and do whatever you want. They say data reflection is one way where they do the caching and all that. Starburst also does the caching. In Starburst, you have a data product. Here, the data product comes from a reflection perspective. The y are working on a columnar memory map, columnar computation. That will have some edge in computation.
Srini-Dhanaraj - PeerSpot reviewer
The solution enables seamless connection, but it is expensive, and the information is one day old
Out-of-the-box reports are very useful. The product provides a seamless connection between the SAP operation system and the data warehouse. It also moves the data from the operating system to the data warehouse in a 3D format. The report generation is easy. It’s a drag-and-drop process. People who want to do a project need not reinvent the wheel. Everything is designed, built, and delivered out of the box. All we have to do is interact with the customers to understand the kind of reports they need and check whether they are already available in the out-of-the-box report. If they are available, we just have to enable them and give the URLs to the customers. The Integration between the SAP operating system and data warehouse is excellent. The UI is good.

Quotes from Members

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

Pros

"Everyone uses Dremio in my company; some use it only for the analytics function."
"We primarily use Dremio to create a data framework and a data queue."
"Dremio is very easy to use for building queries."
"Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it."
"Overall, you can rate it as eight out of ten."
"Dremio gives you the ability to create services which do not require additional resources and sterilization."
"Dremio allows querying the files I have on my block storage or object storage."
"It's almost similar, yet it's better than Starburst in spinning up or connecting to the new source since it's on SaaS."
"SAP Business Warehouse is a scalable solution."
"Out-of-the-box reports are very useful."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"With the technical support, the response has been pretty good from the SAP side."
"In terms of stability, comparatively, the solution is quite stable."
"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"I like that it integrates to open-source."
 

Cons

"We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily."
"They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people."
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake."
"There are performance issues at times due to our limited experience with Dremio, and the fact that we are running it on single nodes using a community version."
"They need to have multiple connectors."
"They need to have multiple connectors. Starburst is rich in connectors, however, they are lacking Salesforce connectivity as of today."
"I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."
"Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement."
"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"There is room for improvement from a technical perspective."
"It's a product that is at the end of life so they will not improve it anymore."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"The solution could offer better connectivity with other databases."
"So far, the initial setup process in our company has not been easy enough for us to understand."
 

Pricing and Cost Advice

"Dremio is less costly competitively to Snowflake or any other tool."
"Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
"I would not recommend it to small-scale companies. The price is too much."
"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
"The solution is quite expensive."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"It's moderately expensive, but definitely has its branding and price value for it."
"Overall, the pricing is not fixed and is expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
30%
Computer Software Company
9%
Manufacturing Company
7%
Healthcare Company
5%
Manufacturing Company
15%
Retailer
9%
Government
7%
Energy/Utilities Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Dremio?
Dremio allows querying the files I have on my block storage or object storage.
What is your experience regarding pricing and costs for Dremio?
The licensing is very expensive. We need a license to scale as we are currently using the community version.
What needs improvement with Dremio?
They need to have multiple connectors. Starburst is rich in connectors, however, they are lacking Salesforce connectivity as of today. They don't have Salesforce connectivity. However, Starburst do...
What is your experience regarding pricing and costs for SAP Business Warehouse?
The solution is quite expensive. We paid a yearly subscription fee.
What needs improvement with SAP Business Warehouse?
Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and bo...
 

Overview

 

Sample Customers

UBS, TransUnion, Quantium, Daimler, OVH
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Find out what your peers are saying about Dremio vs. SAP Business Warehouse and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.