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 most valuable feature is the dashboard."
"One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integration. We don't need to rely on historical data alone; we can provide reporting and features based on real-time information."
"The most valuable feature is that it's robust."
"I like that it's quite quick."
"From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
"The most valuable features are the speed of reporting and the HANA database."
"It is a very stable solution."
"The processes are the most valuable aspect of this solution."
"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 thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services."
"The solution is very easy to use."
"For us, the virtual warehousing is likely the most valuable aspect."
"The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
"The solution is stable."
"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 feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"I would like to be able to design new reports in a future release."
"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."
"Price wise, this solution is on the higher side."
"The solution does occasionally get a few bugs, but this is typical for any product."
"Not a ten because it's expensive and its ecosystem is not very open."
"It takes too long to escalate problems from the first level of support."
"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"One thing that could be enhanced in SAP BW4HANA is the user interface for process chains."
"We would like to see more security including more masking and more encryption at the database level."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"I can only access Snowflake from the web. It would be better if we could have an app that we can install locally on our laptops to connect to the server without needing to go to the web page. Apart from that, it's hard to point out any limitations in the tool."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"Snowflake can improve its machine learning and AI capabilities."
"The cost is a bit high."
"They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in."
"They don't have any SLAs in place. It would be better if they did."
SAP BW4HANA is ranked 8th in Data Warehouse with 37 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.