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

BigQuery vs SAP Business Warehouse comparison

Google and SAP are both solutions in the Cloud Data Warehouse category. Google is ranked #4 with an average rating of 8.3, while SAP is ranked #14 with an average rating of 7.4. Google holds a 7.3% mindshare in CDW, compared to SAP’s 1.1% mindshare. Additionally, 100% of Google users are willing to recommend the solution, compared to 89% of SAP users who would recommend it.
BigQuery
Read 40 BigQuery reviews
  • 3,615 Views
  • 2,899 Comparison Views
100% willing to recommend
SAP Business Warehouse
Read 25 SAP Business Warehouse reviews
  • 734 Views
  • 429 Comparison Views
89% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive SummaryUpdated on Dec 18, 2024

SAP Business Warehouse and BigQuery compete in the data warehousing category. BigQuery seems to have the upper hand due to its scalability and integration with Google services, making it adept at handling large-scale data efficiently.

Features: SAP Business Warehouse provides robust analytics, data integration, and process automation suitable for businesses needing comprehensive reporting. BigQuery is known for its scalability, fast SQL queries, and seamless integration with the Google Cloud ecosystem. It also offers real-time data processing, which is beneficial for rapid insights.

Room for Improvement: SAP Business Warehouse could improve its real-time processing capabilities and ease of deployment. It may also benefit from more flexible system integrations. For BigQuery, enhancing support for complex data types and reducing dependency on Google's ecosystem would be beneficial. More competitive pricing options could improve its market appeal.

Ease of Deployment and Customer Service: SAP Business Warehouse generally requires more time for deployment due to customization and legacy system integration needs. It offers strong post-installation support. BigQuery, with its serverless architecture, allows fast and straightforward deployment, complemented by extensive Google Cloud support.

Pricing and ROI: SAP Business Warehouse often involves higher initial costs related to licensing and implementation, but it offers significant ROI for large organizations. BigQuery's pay-as-you-go pricing model provides flexibility with immediate scalability, proving cost-effective for cloud-based solutions with potential for compelling ROI.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed BigQuery vs. SAP Business Warehouse Report (Updated: March 2025).
Buyer's Guide
BigQuery vs. SAP Business Warehouse
March 2025
Download the complete report
Helped 842,145 peers since 2012

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
4th
Average Rating
8.2
Reviews Sentiment
7.3
Number of Reviews
40
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 March 2025, in the Cloud Data Warehouse category, the mindshare of BigQuery is 7.3%, down from 7.9% compared to the previous year. The mindshare of SAP Business Warehouse is 1.1%, down from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

VikashKumar1 - PeerSpot reviewer
Easy to maintain and provides high availability
Since I used BigQuery over the GCP cloud environment, I'm not sure whether we can go through internal IDEAs like IntelliJ or DBeaver that we use to connect with databases. Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process. Sometimes, we face some issues, bugs, and defects. We must first connect with a VPN to check data issues while working from home. Then, it allows you to connect to the cloud. After logging into the cloud, it searches for the service we are looking for, and then we go to BigQuery. This is a long process. After that, we analyze the issues in a table. Instead, it would be very helpful if it could provide a tool that we can install on our MacBook or Windows system. Once we open this tool, we can connect directly to the BigQuery server and easily perform tasks.
Read full review
JavedKhan1 - PeerSpot reviewer
Offers powerful analytics and integration capabilities but requires improved upgrade processes
SAP Business Warehouse could have been better. There is room for improvement from a technical perspective. So, from a technical perspective, when we are upgrading a Business Warehouse server or we are migrating from one place to another, the capability required for this upgradation has many manual activities. It took us around a month to streamline our server. Let’s say there are some transaction codes. Transaction code is a set of programs, and when you want to run a program from the backend, you need to hit the transaction code. It is called a T-code. So during the upgrade, many transaction codes get affected, and as a security consultant, it is my responsibility to recheck those transaction codes which are affected. Sometimes more than 100 codes may get affected, sometimes 500, and sometimes more as well. So, it takes a hell lot of time to integrate them again. That is a limitation or defect within the SAP Business Warehouse. SAP Business Warehouse should come up with proper solutions. Upgradation is an automatic activity. It should happen by itself. We just need to initiate it, and the backend SAP server is automatically upgraded. But it should handle the transactional code as well. They should not get absolutely, and any authorization object should not get deleted from the transaction codes. So, that functionality SAP Business Warehouse should come up with.
Read full review

Quotes from Members

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

Pros

"BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes."
"It stands out in efficiently handling internal actions without the need for manual intervention in tasks like building cubes and defining final dimensions."
"Even non-coders can review the data in BigQuery."
"BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights."
"The initial setup is simple."
"The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds."
"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 processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes."
More BigQuery pros
"The most valuable aspect of the solution is the integration with SAP ERP."
"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."
"In terms of stability, comparatively, the solution is quite stable."
"Having the integration with the reporting tool which is provided by SAP is great."
"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."
"With the technical support, the response has been pretty good from the SAP side."
"SAP Business Warehouse is a scalable solution."
"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."
More SAP Business Warehouse pros
 

Cons

"We would like to be able to calibrate the solution to run on top of a raw file."
"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."
"They could enhance the platform's user accessibility."
"When I execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming."
"BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses."
"Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process."
"The primary hurdle in this migration lies in the initial phase of moving substantial volumes of data to cloud-based platforms."
"It would be beneficial if BigQuery could be made more affordable."
More BigQuery cons
"So far, the initial setup process in our company has not been easy enough for us to understand."
"They should reduce the product’s installation package size for easier downloading."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"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."
"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."
"I would like to see a different end solution in order to read the data and attract internal users."
"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."
"More integration with Microsoft Office products (not just Excel) would be helpful."
More SAP Business Warehouse cons
 

Pricing and Cost Advice

"The pricing is good and there are no additional costs involved."
"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"The solution's pricing is cheaper compared to other solutions."
"1 TB is free of cost monthly. If you use more than 1 TB a month, then you need to pay 5 dollars extra for each TB."
"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."
"The tool has competitive pricing."
"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."
"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."
More BigQuery pricing and cost advice
"Overall, the pricing is not fixed and is expensive."
"The solution is quite expensive."
"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."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"I would not recommend it to small-scale companies. The price is too much."
"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."
report
See which vendors are best for you
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
See recommendations
842,145 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
17%
Financial Services Firm
14%
Manufacturing Company
12%
Retailer
7%
Manufacturing Company
12%
Financial Services Firm
10%
Government
9%
Computer Software Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about BigQuery?
The initial setup process is easy.
See all answers
What is your experience regarding pricing and costs for BigQuery?
The price is perceived as expensive, rated at eight out of ten in terms of costliness. Still, it offers significant cost savings.
See all answers
What needs improvement with BigQuery?
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. In general, if I know SQL and start playing around, it will star...
See all answers
What do you like most about SAP Business Warehouse?
Out-of-the-box reports are very useful.
See all answers
What is your experience regarding pricing and costs for SAP Business Warehouse?
The solution is quite expensive. We paid a yearly subscription fee.
See all answers
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...
See all answers
 

Comparisons

Snowflake vs BigQuery Logo
Snowflake vs BigQuery
Compared 30% of the time
Oracle Autonomous Data Warehouse vs BigQuery Logo
Oracle Autonomous Data Warehouse vs BigQuery
Compared 16% of the time
Teradata vs BigQuery Logo
Teradata vs BigQuery
Compared 14% of the time
Vertica vs BigQuery Logo
Vertica vs BigQuery
Compared 14% of the time
Apache Hadoop vs BigQuery Logo
Apache Hadoop vs BigQuery
Compared 7% of the time
More BigQuery Competitors
Microsoft Azure Synapse Analytics vs SAP Business Warehouse Logo
Microsoft Azure Synapse Analytics vs SAP Business Warehouse
Compared 25% of the time
Amazon Redshift vs SAP Business Warehouse Logo
Amazon Redshift vs SAP Business Warehouse
Compared 23% of the time
Snowflake vs SAP Business Warehouse Logo
Snowflake vs SAP Business Warehouse
Compared 22% of the time
Teradata vs SAP Business Warehouse Logo
Teradata vs SAP Business Warehouse
Compared 16% of the time
SAP BW4HANA vs SAP Business Warehouse Logo
SAP BW4HANA vs SAP Business Warehouse
Compared 15% of the time
More SAP Business Warehouse Competitors
 

Product Reports

Buyer's Guide
BigQuery
March 2025
BigQuery reportDownload BigQuery product report
Buyer's Guide
SAP Business Warehouse
February 2025
SAP Business Warehouse reportDownload SAP Business Warehouse product report
 

Overview

BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. ... You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.

Google

Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

SAP
 

Sample Customers

Information Not Available
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Buyer's Guide
BigQuery vs. SAP Business Warehouse
March 2025
Free Report: BigQuery vs. SAP Business Warehouse
Find out what your peers are saying about BigQuery vs. SAP Business Warehouse and other solutions. Updated: March 2025.
DOWNLOAD NOW
842,145 professionals have used our research since 2012.
See our BigQuery vs. SAP Business Warehouse report.
See our list of best Cloud Data Warehouse vendors.

We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.