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

BigQuery vs SAP Business Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

BigQuery
Ranking in Cloud Data Warehouse
5th
Average Rating
8.2
Reviews Sentiment
7.6
Number of Reviews
35
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.9
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of BigQuery is 9.3%, up from 6.7% 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 - PeerSpot reviewer
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.
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.

Quotes from Members

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

Pros

"The feature called calibrating the capacity is valuable."
"The initial setup process is easy."
"The most valuable features of BigQuery is that it supports standard SQL and provides good performance."
"The product's most valuable features include its scalability and the ability to handle complex queries on large datasets."
"The solution is very useful nowadays for keeping a huge number of records."
"The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness."
"BigQuery can be used for any type of company. It has the capability of building applications and storing data. It can be used for OLTP or OLAP. It has many other products within the Google space."
"The product’s most valuable feature is its ability to manage the database on the cloud."
"The warehouse is the solution's most valuable feature."
"Out-of-the-box reports are very useful."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"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."
"Having the back-end data set with the right information is the best qualification for this solution."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"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 most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
 

Cons

"We would like to be able to calibrate the solution to run on top of a raw file."
"The solution hinges on Google patterns so continued improvement is important."
"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."
"For greater flexibility and ease of use, it would be beneficial if BigQuery offered more third-party add-ons and connectors, particularly for databases that don't have built-in integration options."
"The product could benefit from improvements in user-friendliness, particularly in terms of the user interface."
"It would be beneficial to integrate additional tools, particularly from a business intelligence perspective."
"BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses."
"There are some limitations in the query latency compared to what it was three years ago."
"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."
"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."
"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."
"They should reduce the product’s installation package size for easier downloading."
"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."
"I would like to see a different end solution in order to read the data and attract internal users."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"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

"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's pricing is cheaper compared to other solutions."
"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"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."
"The product’s pricing could be more flexible for end users."
"Price-wise, I think that is very reasonable."
"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 pricing appears to be competitive for the intended usage scenarios we have in mind."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"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 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 moderately expensive, but definitely has its branding and price value for it."
"I would not recommend it to small-scale companies. The price is too much."
"Overall, the pricing is not fixed and is expensive."
"The solution is quite expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,406 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%
Computer Software Company
11%
Manufacturing Company
11%
Financial Services Firm
9%
Government
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.
What is your experience regarding pricing and costs for BigQuery?
The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity.
What needs improvement with BigQuery?
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 dir...
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...
 

Learn More

 

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: October 2024.
816,406 professionals have used our research since 2012.