We performed a comparison between BigQuery and SAP Business Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."There are some performance features like partitioning, which you can do based on an integer, and it improves the performance a lot."
"The integrated data storage features are good."
"It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."
"The main thing I like about BigQuery is storage. We did an on-premise BigQuery migration with trillions of records. Usually, we have to deal with insufficient storage on-premises, but in BigQuery, we don't get that because it's like cloud storage, and we can have any number of records. That is one advantage. The next major advantage is the column length. We have some limits on column length on-premises, like 10,000, and we have to design it based on that. However, with BigQuery, we don't need to design the column length at all. It will expand or shrink based on the records it's getting. I can give you a real-life example based on our migration from on-premises to GCP. There was a dimension table with a general number of records, and when we queried that on-premises, like in Apache Spark or Teradata, it took around half an hour to get those records. In BigQuery, it was instant. As it's very fast, you can get it in two or three minutes. That was very helpful for our engineers. Usually, we have to run a query on-premises and go for a break while waiting for that query to give us the results. It's not the case with BigQuery because it instantly provides results when we run it. So, that makes the work fast, it helps a lot, and it helps save a lot of time. It also has a reasonable performance rate and smart tuning. Suppose we need to perform some joins, BigQuery has a smart tuning option, and it'll tune itself and tell us the best way a query can be done in the backend. To be frank, the performance, reliability, and everything else have improved, even the downtime. Usually, on-premise servers have some downtime, but as BigQuery is multiregional, we have storage in three different locations. So, downtime is also not getting impacted. For example, if the Atlantic ocean location has some downtime, or the server is down, we can use data that is stored in Africa or somewhere else. We have three or four storage locations, and that's the main advantage."
"The initial setup process is easy."
"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."
"As a cloud solution, it's easy to set up."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"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."
"In terms of stability, comparatively, the solution is quite stable."
"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."
"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."
"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 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 warehouse is the solution's most valuable feature."
"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."
"An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high."
"Some of the queries are complex and difficult to understand."
"There are some limitations in the query latency compared to what it was three years ago."
"The solution hinges on Google patterns so continued improvement is important."
"As a product, BigQuery still requires a lot of maturity to accommodate other use cases and to be widely acceptable across other organizations."
"I rate BigQuery six out of 10 for affordability. It could be cheaper."
"The solution should reduce its pricing."
"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."
"The solution could offer better connectivity with other databases."
"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."
"There is room for improvement from a technical perspective."
"I would like to see a different end solution in order to read the data and attract internal users."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
"SAP Business Warehouse could integrate better with other ETL tools."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 25 reviews. BigQuery is rated 8.2, while SAP Business Warehouse is rated 7.8. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". On the other hand, the top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and Microsoft Azure Synapse Analytics, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, SAP BW4HANA, Amazon Redshift and SAP NetWeaver Business Warehouse. 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.