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 features are the speed of reporting and the HANA database."
"I like how it blends no-code and ABAP code for complex transformations during data loading."
"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."
"I like the reporting features of the solution."
"The most valuable feature is that it's robust."
"It is a very stable solution."
"It is a stable solution...The initial setup was easy."
"It can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis memory."
"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."
"For us, the virtual warehousing is likely the most valuable aspect."
"The product is quite fast."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"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 adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"It is quite easy to manage."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"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."
"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."
"The UI is not user-friendly."
"We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports."
"The solution is not scalable. It does not have a data streaming feature as well."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"I would like to be able to design new reports in a future release."
"Connecting multiple sources is a challenge because you have to go through a lot of different setups."
"This solution could be improved by offering machine learning apps."
"Getting data out of the tool to third-party applications is difficult."
"It's not that flexible when compared to Oracle."
"If they could bring in some tools for data integration, it would be really great."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety."
"Some SQL language functions could be included."
"The solution could use a little bit more UI."
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 "An easy-to-operate and administer tool that needs to consider revising its existing licensing cost". 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 NetWeaver Business Warehouse, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Oracle Exadata. 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.