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 September 2025, in the Cloud Data Warehouse category, the mindshare of BigQuery is 7.7%, down from 7.9% compared to the previous year. The mindshare of SAP Business Warehouse is 1.9%, up from 1.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
BigQuery7.7%
SAP Business Warehouse1.9%
Other90.4%
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

"When integrating their system into the cloud-based solutions, we were able to increase their efficiency and overall productivity twice compared with their on-premises option."
"BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes."
"The solution is very useful nowadays for keeping a huge number of records."
"BigQuery excels at structuring data, performing predictions, and conducting insightful analyses and it leverages machine learning and artificial intelligence capabilities, powered by Google's Duarte AI."
"The initial setup is simple."
"Its integration with other tools like Atlan through a Google Chrome extension is highly beneficial."
"BigQuery's querying capabilities are very optimized for large datasets."
"This solution is highly scalable."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"I like that it integrates to open-source."
"The most useful feature is definitely the speed."
"Out-of-the-box reports are very useful."
"The warehouse is the solution's most valuable feature."
"SAP Business Warehouse is a scalable solution."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
 

Cons

"We'd like to have more integrations with other technologies."
"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."
"It can be slower and more problematic compared to other platforms such as Snowflake."
"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."
"Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process."
"The price could be better. Compared to competing solutions, BigQuery is expensive. It's only suitable for enterprise customers, not small and medium-sized businesses, as they cannot afford this kind of solution. In the next release, it would be better if they improved their AI bot. Although machine learning and artificial intelligence are doing wonders, there is still a lot of room to enhance them."
"When I execute a query, the dashboard doesn't always present the output seamlessly."
"It would be helpful if they could provide some dashboards where you can easily view charts and information."
"There is room for improvement from a technical perspective."
"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"SAP Business Warehouse could integrate better with other ETL tools."
"One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection."
"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."
"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."
 

Pricing and Cost Advice

"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."
"BigQuery pricing can increase quickly. It's a high-priced solution."
"I have tried my own setup using my Gmail ID, and I think it had a $300 limit for free for a new user. That's what Google is offering, and we can register and create a project."
"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"The price could be better. Usually, you need to buy the license for a year. Whenever you want more, you can subscribe to it, and you can use it. Otherwise, you can terminate the license. You can use it daily or monthly, and we use it based on a project's requirements."
"The pricing is good and there are no additional costs involved."
"The solution's pricing is cheaper compared to other solutions."
"BigQuery is inexpensive."
"I would not recommend it to small-scale companies. The price is too much."
"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."
"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."
"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 solution is quite expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
867,370 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
15%
Manufacturing Company
11%
Retailer
7%
Manufacturing Company
13%
Retailer
10%
Energy/Utilities Company
8%
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: July 2025.
867,370 professionals have used our research since 2012.