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."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 setup is simple."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"I like that we can synch and run a large query. I also like that we can work with a large amount of data. You don't need to work separately, as it's a ready-made solution. It also comes with a built-in machine-learning feature. Once we start inputting the data, it will suggest some things related to the data, and we can come up with nice dashboards and statistics from a vast amount of data."
"The initial setup is straightforward."
"The interface is what I find particularly valuable."
"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 initial setup process is easy."
"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."
"Having the back-end data set with the right information is the best qualification for this solution."
"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 real-time information is great."
"Out-of-the-box reports are very useful."
"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."
"With the technical support, the response has been pretty good from the SAP side."
"The process of migrating from Datastore to BigQuery should be improved."
"So our challenge in Yemen is convincing many people to go to cloud services."
"There are many tools that you have to use with BigQuery that are different services also provided for by Google. They need to all be integrated into BigQuery to make the solution easier to use."
"There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans."
"It would be helpful if they could provide some dashboards where you can easily view charts and information."
"We'd like to see more local data residency."
"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."
"They could enhance the platform's user accessibility."
"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."
"It's a product that is at the end of life so they will not improve it anymore."
"The solution could offer better connectivity with other databases."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"SAP Business Warehouse could integrate better with other ETL tools."
"The solution should be more open to the cloud."
"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."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while SAP Business Warehouse is ranked 9th 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, SAP NetWeaver Business Warehouse and Amazon Redshift. 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.