We performed a comparison between SAP Business Warehouse and Snowflake 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."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."
"Having the integration with the reporting tool which is provided by SAP is great."
"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."
"SAP Business Warehouse is a scalable solution."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."
"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."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"The product's most important feature is unloading data to S3."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"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."
"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."
"It's a product that is at the end of life so they will not improve it anymore."
"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."
"They should reduce the product’s installation package size for easier downloading."
"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."
"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."
"It doesn't enforce typical relational database constraints. Quite expensive."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"We would like to be able to do modeling with Snowflake. It should support statistical modeling."
"The cost of the solution could be reduced."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"Pricing is an issue for many customers."
"I would like to see a client version of the GUI."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 reviews. SAP Business Warehouse is rated 7.8, while Snowflake is rated 8.4. The top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, BigQuery, SAP BW4HANA, SAP NetWeaver Business Warehouse and Amazon Redshift, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our SAP Business Warehouse vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors and best 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.