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 back-end data set with the right information is the best qualification for this solution."
"The most useful feature is definitely the speed."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"The warehouse is the solution's most valuable feature."
"We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution."
"The real-time information is great."
"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."
"The technical support is pretty good, particularly if you are a more technical user."
"The technical support on offer is excellent."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"The solution is stable."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"A user-friendly and reliable solution."
"This solution has helped our organization by being easy to maintain and having good technical support."
"Can be leveraged with respect to better performance, auto tuning and competition."
"The solution could offer better connectivity with other databases."
"The solution should be more open to the cloud."
"SAP Business Warehouse could integrate better with other ETL tools."
"The advanced structuring can be complicated and the interface is not very intuitive."
"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."
"They should reduce the product’s installation package size for easier downloading."
"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."
"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."
"Pricing is an issue for many customers."
"Snowflake has support for stored procedures, but it is not that powerful."
"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
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.