We performed a comparison between SAP BW4HANA and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution is easier to maintain than traditional SAP products."
"It is a stable solution...The initial setup was easy."
"The ability to instantly pull data is the most valuable feature."
"The most valuable feature is the dashboard."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"It is a stable solution."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"Out of the box, this solution has a lot of standard features."
"The querying speed is fast."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
"The solution speeds up the process of onboarding."
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"The technical support is pretty good, particularly if you are a more technical user."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement."
"The solution does occasionally get a few bugs, but this is typical for any product."
"The tool is not cloud-compatible."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward."
"There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."
"The dashboard should be simplified and made easier for exploration and decision making."
"The data sharing capabilities across business units within the organization should be better."
"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."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"Snowflake can improve its machine learning and AI capabilities."
"The cost of the solution could be reduced."
"The price could be improved."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"The data science functionality could be improved in terms of the machine learning process."
SAP BW4HANA is ranked 8th in Data Warehouse with 36 reviews while Snowflake is ranked 1st in Data Warehouse with 94 reviews. SAP BW4HANA is rated 7.4, while Snowflake is rated 8.4. The top reviewer of SAP BW4HANA writes "Performs all necessary data warehouse tasks and offers additional functionalities". 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 BW4HANA is most compared with Microsoft Azure Synapse Analytics, SAP HANA, Amazon Redshift, SQL Server and SAP Business Warehouse, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Microsoft Azure Synapse Analytics. See our SAP BW4HANA vs. Snowflake report.
See our list of best Data Warehouse vendors.
We monitor all 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.