BigQuery vs SAP Business Warehouse comparison

"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."

"The integrated data storage features are good."

"The most valuable features of BigQuery is that it supports standard SQL and provides good performance."

"The solution's reporting, dashboard, and out-of-the-box capabilities match exactly our requirements."

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

"The product's most valuable features include its scalability and the ability to handle complex queries on large datasets."

"The initial setup is straightforward."

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

"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."

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

"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 features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."

"SAP Business Warehouse is a scalable solution."

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

"In terms of stability, comparatively, the solution is quite stable."

"The product’s performance could be much faster."

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

"BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses."

"BigQuery can be very expensive if not used properly. Introducing AI tools that would allow you to optimize the data extraction process is an area of serious improvement."

"The processing capability can be an area of improvement."

"We'd like to see more local data residency."

"I noticed recently it's more expensive now."

"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."

"More integration with Microsoft Office products (not just Excel) would be helpful."

"The solution should be more open to the cloud."

"It's a product that is at the end of life so they will not improve it anymore."

"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."

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

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

"I would like to see a different end solution in order to read the data and attract internal users."

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

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

"The tool has competitive pricing."

"BigQuery pricing can increase quickly. It's a high-priced solution."

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

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

"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."

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

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

"I would not recommend it to small-scale companies. The price is too much."

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

"It's moderately expensive, but definitely has its branding and price value for it."