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."The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"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 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."
"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 features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"The most valuable aspect of the solution is the integration with SAP ERP."
"Very easy to use and easy to query."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The solution's customer service is good."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"The solution speeds up the process of onboarding."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"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."
"SAP Business Warehouse could integrate better with other ETL tools."
"I get all the information quickly, but it is one day old."
"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."
"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 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."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"It doesn't enforce typical relational database constraints. Quite expensive."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"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."
"The solution could use a little bit more UI."
"They don't have any SLAs in place. It would be better if they did."
"Their UiPath, the workspace area, needs some work."
SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 25 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 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, Amazon Redshift and SAP NetWeaver Business Warehouse, 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.