Try our new research platform with insights from 80,000+ expert users

SAP BW4HANA vs Snowflake comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SAP BW4HANA
Ranking in Data Warehouse
8th
Average Rating
7.6
Reviews Sentiment
6.6
Number of Reviews
42
Ranking in other categories
No ranking in other categories
Snowflake
Ranking in Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
99
Ranking in other categories
Cloud Data Warehouse (1st), AI Synthetic Data (3rd)
 

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of SAP BW4HANA is 4.5%, down from 4.6% compared to the previous year. The mindshare of Snowflake is 15.2%, down from 19.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Csaba Grünblatt - PeerSpot reviewer
Performs all necessary data warehouse tasks and offers additional functionalities
SAP BW4HANA improved data reporting processes significantly. Performance on HANA database is good. Well-built data models ensure consistent and fast reporting. Reusable models enhance efficiency, even for SaaS services. In-memory computing, especially since HANA, has greatly improved performance in data analysis tasks. It eliminates the need for complex optimizations like creating indexes or aggregates. Queries that once took minutes now run in seconds, enabling real-time reporting, especially for SAP ECC on HANA. SAP BW4HANA's integration capabilities are streamlined with a simplified architecture and more virtual layers. You can directly load data into optimized layers, reducing the need for extra storage. The introduction of Open ODS Views allows for additional logic and master data inclusion, making integration faster and simpler. The learning curve for SAP BW4HANA is much faster now compared to ten years ago, thanks to abundant free resources like documentation, videos, blogs, and learning journeys provided by SAP. It is simpler to learn with these resources available compared to the past when you had to attend courses and rely on books. I would recommend SAP BW4HANA to users looking to implement it, especially if they want to keep their systems on-premise and already have SAP systems. Those with BW on HANA have two choices: BW4HANA or DataSphere, depending on their cloud strategy. If they are advanced in their cloud strategy and want to migrate off-premise, DataSphere is a good choice. However, for a robust solution on-premise or in a private cloud, BW4HANA is an excellent option. Overall, I would rate BW4HANA as a nine out of ten. It performs all necessary data warehouse tasks and offers additional functionalities. We use it traditionally, with complex transformations and models but with less emphasis on real-time processing and third-party sources.
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Provides a great analytics engine with all the capabilities."
"It is a stable solution."
"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 processes are the most valuable aspect of this solution."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"The solution saves time and cost."
"It is a stable solution...It is a scalable solution."
"The ability to instantly pull data is the most valuable feature."
"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 feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The integration capabilities of the product are good and you get what you pay for when it comes to Snowflake."
"Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
"Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses."
"Very easy to use and easy to query."
 

Cons

"I would like more integration."
"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."
"Other competitors provide better solutions that are more up to date with current technology."
"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 dashboard should be simplified and made easier for exploration and decision making."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"The monitoring for the remodeling feature is very difficult to understand."
"SAP BW/4HANA can generally be less flexible than other tools, depending on how it is set up."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"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."
"The solution needs more connectors."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"Snowflake has support for stored procedures, but it is not that powerful."
"The aspect of it that was more complicated was stored procedures. It does not support SQL language-based stored procedures. You have to write in JavaScript. If they supported SQL language and stored procedures, it would make migration from on-prem much simpler. In most cases, if an on-prem solution has stored procedures, they're usually written in SQL. They're not written as what most on-prem DBMS would refer to as an external stored procedure, which is what these feel like to most people because they're written in a language outside of SQL."
"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."
"The documentation could improve. They should provide architecture information."
 

Pricing and Cost Advice

"The price is high and currently only affordable for large organizations."
"We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses."
"It is an expensive product."
"For some, the rates offered by SAP can be costly while for others it may seem cheap. The price ultimately depends on how you have negotiated your contract with SAP."
"The solution is expensive."
"SAP BW/4HANA is expensive."
"As an investment, the solution is very expensive."
"This is an expensive solution and there are costs in addition to the standard licensing fees."
"The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year."
"We're based on credits. So, we're paying four and a half dollars of credit. There are no additional costs. I would rate it a two out of five in terms of pricing."
"It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
"Snowflake goes by credits. For a financial institution where you have 5,000 employees, monthly costs may run up to maybe $5,000 to $6,000. This is actually based on the usage. It is mostly the compute cost. Your computing cost is the variable that is actually based on your usage. It is pay-per-use. In a pay-per-use case, you won't be spending more than $6,000 to $7,000 a month. It is not more than that for a small or medium enterprise, and it may come down to $100K per year. Storage is very standard, which is $23 a terabyte. It is not much for any enterprise. If you have even 20 terabytes, you are not spending more than $400 per month, which may turn out to be $2,000 to $3,000 per annum."
"Snowflake is cost-effective. However, the cost can depend on how it's being used and how efficiently the code is written. If engineers don't write efficient code and usage is billed based on processing, it can become costly. If they write optimal code and choose the best solution, it can reduce costs in comparison to other options, such as Oracle."
"I have worked with multiple clouds, and cost-wise, it is a bit costlier than others, such as Redshift. Its price should be reduced."
"There is a separation of storage and compute, so you only pay for what you use."
"The pricing for Snowflake is competitive."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
17%
Financial Services Firm
9%
Computer Software Company
9%
Retailer
8%
Educational Organization
40%
Financial Services Firm
12%
Computer Software Company
8%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about SAP BW4HANA?
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 integrati...
What is your experience regarding pricing and costs for SAP BW4HANA?
We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses.
What needs improvement with SAP BW4HANA?
The interface could be more user-friendly, as we often need to do low-level coding to get things done.
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
Snowflake's pricing is on the higher side, rated as eight out of ten. If there were ways to reduce costs, it would be a positive improvement.
What needs improvement with Snowflake?
Cost reduction is one area I would like Snowflake to improve. The product is not very cheap, and a reduction in costs would be appreciated.
 

Comparisons

 

Also Known As

SAP BW/4HANA
Snowflake Computing
 

Overview

 

Sample Customers

Information Not Available
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about SAP BW4HANA vs. Snowflake and other solutions. Updated: March 2025.
845,040 professionals have used our research since 2012.