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

BigQuery 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

BigQuery
Ranking in Cloud Data Warehouse
3rd
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
41
Ranking in other categories
No ranking in other categories
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 October 2025, in the Cloud Data Warehouse category, the mindshare of BigQuery is 8.0%, up from 7.8% compared to the previous year. The mindshare of SAP Business Warehouse is 2.1%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
BigQuery8.0%
SAP Business Warehouse2.1%
Other89.9%
Cloud Data Warehouse
 

Featured Reviews

Luís Silva - PeerSpot reviewer
Handles large data sets efficiently and offers flexible data management capabilities
The features I find most valuable in this solution are the ability to run and handle large data sets in a very efficient way with multiple types of data, relational as SQL data. It is kind of difficult to explain, but structured data and the ability to handle large data sets are key features. The data integration capabilities in BigQuery were, in fact, an issue at the beginning. There are two types of integrations. As long as integration is within Google, it is pretty simple. When you start to try to connect external clients to that data, it becomes more complex. It is not related to BigQuery, it is related to Google security model, which is not easy to manage. I would not call it an integration issue of BigQuery, I would call it an integration issue of Google security model.
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

"What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."
"We like the machine learning features and the high-performance database engine."
"We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect."
"BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases."
"Even non-coders can review the data in BigQuery."
"BigQuery's querying capabilities are very optimized for large datasets."
"The solution is very useful nowadays for keeping a huge number of records."
"As a cloud solution, it's easy to set up."
"I like that it integrates to open-source."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."
"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."
"The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"The product is very stable."
"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."
"The most useful feature is definitely the speed."
 

Cons

"They could enhance the platform's user accessibility."
"When I open many of the Google Cloud products, I am in an environment that I do not feel familiar with; it is a little overwhelming."
"The primary hurdle in this migration lies in the initial phase of moving substantial volumes of data to cloud-based platforms."
"So our challenge in Yemen is convincing many people to go to cloud services."
"I rate BigQuery six out of 10 for affordability. It could be cheaper."
"We would like to be able to calibrate the solution to run on top of a raw file."
"When I open many of the Google Cloud products, I am in an environment that I do not feel familiar with; it is a little overwhelming."
"It can be slower and more problematic compared to other platforms such as Snowflake."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"It's a product that is at the end of life so they will not improve it anymore."
"There is room for improvement from a technical perspective."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"The solution could offer better connectivity with other databases."
"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."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"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."
 

Pricing and Cost Advice

"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."
"The pricing is good and there are no additional costs involved."
"Its cost structure operates on a pay-as-you-go model."
"The pricing is adaptable, ensuring that organizations can tailor their usage and costs based on their specific requirements and configurations within the Google Cloud Platform."
"One terabyte of data costs $20 to $22 per month for storage on BigQuery and $25 on Snowflake. Snowflake is costlier for one terabyte, but BigQuery charges based on how much data is inserted into the tables. BigQuery charges you based on the amount of data that you handle and not the time in which you handle it. This is why the pricing models are different and it becomes a key consideration in the decision of which platform to use."
"We are above the free threshold, so we are paying around 40 euros per month for BigQuery."
"The product’s pricing could be more flexible for end users."
"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"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."
"Overall, the pricing is not fixed and is expensive."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"The solution is quite expensive."
"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."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
868,787 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
14%
Manufacturing Company
12%
Retailer
7%
Manufacturing Company
12%
Retailer
10%
Energy/Utilities Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise9
Large Enterprise20
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise4
Large Enterprise15
 

Questions from the Community

What do you like most about BigQuery?
The initial setup process is easy.
What is your experience regarding pricing and costs for BigQuery?
I believe the cost of BigQuery is competitive versus the alternatives in the market, but it can become expensive if the tool is not used properly. It is on a per-consumption basis, the billing, so ...
What needs improvement with BigQuery?
I have not used BigQuery for AI and machine learning projects myself. I know how to use it, and I can see where it would be useful, but so far, in my projects, I have not included a BigQuery compon...
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

Information Not Available
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 BigQuery vs. SAP Business Warehouse and other solutions. Updated: September 2025.
868,787 professionals have used our research since 2012.