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 #13 with an average rating of 7.6. Google holds a 9.1% mindshare in CDW, compared to SAP’s 1.4% mindshare. Additionally, 100% of Google users are willing to recommend the solution, compared to 89% of SAP users who would recommend it.

BigQuery

Read 39 BigQuery reviews

3,998 Views
3,216 Comparison Views

100% willing to recommend

SAP Business Warehouse

Read 25 SAP Business Warehouse reviews

814 Views
494 Comparison Views

89% willing to recommend

BigQuery

SAP Business Warehouse

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.

To learn more, read our detailed BigQuery vs. SAP Business Warehouse Report (Updated: January 2025).

Buyer's Guide

BigQuery vs. SAP Business Warehouse

January 2025

Download the complete report

Helped 831,265 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

Ranking in other categories

No ranking in other categories

SAP Business Warehouse

Ranking in Cloud Data Warehouse

13th

Average Rating

7.8

Reviews Sentiment

6.3

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of January 2025, in the Cloud Data Warehouse category, the mindshare of BigQuery is 9.1%, up from 7.8% compared to the previous year. The mindshare of SAP Business Warehouse is 1.4%, down from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

Featured Reviews

Sathishkumar Jayaprakash

Engineer at HTC Global Services (INDIA) Private

Efficient large dataset handling with seamless service integration

BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases. It integrates well with other GCP products, and creating subscriptions in the UI is straightforward. The whole ecosystem of GCP products makes BigQuery beneficial for our data-handling tasks. Additionally, it is more cost-effective compared to alternatives like AWS.

Read full review

JavedKhan1

SAP Security/GRC Manager at Tata Consultancy

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

"The initial setup process is easy."

"BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases."

"The most valuable aspect of BigQuery is its ability to handle high data workloads without causing friction with our online systems."

"BigQuery excels at data analysis. It processes vast amounts of information using its advanced architecture and sophisticated querying capabilities, making it crucial for critical insights and safe for handling sensitive data."

"There are some performance features like partitioning, which you can do based on an integer, and it improves the performance a lot."

"BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes."

"We like the machine learning features and the high-performance database engine."

"One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions."

More BigQuery pros

"The most valuable aspect of the solution is the integration with SAP ERP."

"Out-of-the-box reports are very useful."

"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."

"In terms of stability, comparatively, the solution is quite 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."

"Having the back-end data set with the right information is the best qualification for this solution."

"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."

"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

"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."

"When it comes to queries or the code being executed in the data warehouse, the management of this code, like integration with the GitHub repository or the GitLab repository, is kind of complicated, and it's not so direct."

"With other columnar databases like Snowflake, you can actually increase your VM size or increase your machine size, and you can buy more memory and it will start working faster, but that's not available in BigQuery. You have to actually open a ticket and then follow it up with Google support."

"There is a limitation when copying data directly from BigQuery; it only supports up to ten MB when copying data to the clipboard."

"We would like to be able to calibrate the solution to run on top of a raw file."

"The main challenges are in the areas of performance and cost optimizations."

"It would be better if BigQuery didn't have huge restrictions. For example, when we migrate from on-premises to on-premise, the data which handles all ebook characters can be handled on-premise. But in BigQuery, we have huge restrictions. If we have some symbols, like a hash or other special characters, it won't accept them. Not in all cases, but it won't accept a few special characters, and when we migrate, we get errors. We need to use Regexp or something similar to replace that with another character. This isn't expected from a high-range technology like BigQuery. It has to adapt all products. For instance, if we have a TV Showroom, the TV symbol will be there in the shop name. Teradata and Apache Spark accept this, but BigQuery won't. This is the primary concern that we had. In the next release, it would be better if the query on the external table also had cache. Right now, we are using a GCS bucket, and in the native table, we have cache. For example, if we query the same table, it won't cost because it will try to fetch the records from the cached result. But when we run queries on the external table a number of times, it won't be cached. That's a major drawback of BigQuery. Only the native table has the cache option, and the external table doesn't. If there is an option to have an external table for cache purposes, it'll be a significant advantage for our organization."

"When I execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming."

More BigQuery cons

"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."

"SAP Business Warehouse could integrate better with other ETL tools."

"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."

"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."

"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."

"There is room for improvement from a technical perspective."

"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 should be more open to the cloud."

More SAP Business Warehouse cons

Pricing and Cost Advice

"The product’s pricing could be more flexible for end users."

"Its cost structure operates on a pay-as-you-go model."

"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."

"The price is a bit high but the technology is worth it."

"The platform is inexpensive."

"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."

"BigQuery is inexpensive."

"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."

More BigQuery pricing and cost advice

"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."

"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."

"The solution is quite expensive."

"Overall, the pricing is not fixed and is expensive."

"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."

"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."

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

831,265 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

Manufacturing Company

11%

Financial Services Firm

Government

Computer Software Company

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 execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming. Moreover, pricing, the abse...

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

Compared 35% of the time

Teradata vs BigQuery

Compared 14% of the time

Vertica vs BigQuery

Compared 13% of the time

Oracle Autonomous Data Warehouse vs BigQuery

Compared 12% of the time

More BigQuery Competitors

Microsoft Azure Synapse Analytics vs SAP Business Warehouse

Compared 28% of the time

Amazon Redshift vs SAP Business Warehouse

Compared 21% of the time

Snowflake vs SAP Business Warehouse

Compared 19% of the time

Teradata vs SAP Business Warehouse

Compared 11% of the time

More SAP Business Warehouse Competitors

Product Reports

Buyer's Guide

BigQuery

January 2025

Download BigQuery product report

Buyer's Guide

SAP Business Warehouse

December 2024

Download SAP Business Warehouse product report

Learn More

Google

SAP

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.

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.

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

January 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: January 2025.

DOWNLOAD NOW

831,265 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.