We performed a comparison between BigQuery and SAP NetWeaver 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."It has a well-structured suite of complimentary tools for data integration and so forth."
"What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."
"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."
"It's similar to a Hadoop cluster, except it's managed by Google."
"Even non-coders can review the data in BigQuery."
"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 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."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"A robust and efficient product."
"It provides us with proof of data, we can centralize all of the information, check it, and then provide the information to our users."
"Data modeling is a valuable feature."
"It's an excellent over-all tool for managers to analyze their business."
"Transformation is a valuable feature of SAP NetWeaver. I can transform the data as per my needs or my client's needs. For example, flat tables can be transformed with respect to our requirements to combine multiple modules into one single table, and we can derive analytics."
"It is a robust system."
"The security and audit procedures are the most valuable features."
"The process of migrating from Datastore to BigQuery should be improved."
"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."
"The initial setup could be improved making it easier to deploy."
"As a product, BigQuery still requires a lot of maturity to accommodate other use cases and to be widely acceptable across other organizations."
"So our challenge in Yemen is convincing many people to go to cloud services."
"We'd like to have more integrations with other technologies."
"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 solution should reduce its pricing."
"Connectors are complex, and it is difficult to understand or know which connector should be used. For instance, if I want to connect APIs, I will not be able to do it directly. I would have to go to the portal integration to get the data. Therefore, having simplified connectors will make things much easier."
"Design and modeling could be simplified."
"The product could provide more features."
"It is difficult when your native language is not English. It is difficult for us to explain our issue and also difficult for the technical team to explain a resolution to us."
"I think more integration with other applications would be perfect."
"There are performance issues in terms of scalability and availability."
"The program is difficult to learn to use"
More SAP NetWeaver Business Warehouse Pricing and Cost Advice →
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while SAP NetWeaver Business Warehouse is ranked 15th in Data Warehouse with 9 reviews. BigQuery is rated 8.2, while SAP NetWeaver 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 NetWeaver Business Warehouse writes "Powerful solution with good security and audit procedure features". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and Apache Hadoop, whereas SAP NetWeaver Business Warehouse is most compared with SAP BW4HANA and SAP Business Warehouse. See our BigQuery vs. SAP NetWeaver 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.