Compare SAP BW4HANA vs. Snowflake

Cancel
You must select at least 2 products to compare!
SAP BW4HANA Logo
3,985 views|2,844 comparisons
Snowflake Logo
34,806 views|24,549 comparisons
Most Helpful Review
Find out what your peers are saying about SAP BW4HANA vs. Snowflake and other solutions. Updated: May 2021.
501,151 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The most valuable feature is that it's robust.""The processes are the most valuable aspect of this solution.""Out of the box, this solution has a lot of standard features.""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 solution is easier to maintain than traditional SAP products.""The most valuable feature is the dashboard.""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 most valuable aspect of this solution is that the infrastructure is easy to understand."

More SAP BW4HANA Pros »

"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.""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.""They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.""The initial setup is straightforward. You just need to follow the documentation.""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.""It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.""I like the idea that you can assign roles and responsibilities, limiting access to data.""The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."

More Snowflake Pros »

Cons
"I cannot integrate it with my other tools. It's not possible to do something in the predictive analysis. Mobile reporting is also not available.""Connecting multiple sources is a challenge because you have to go through a lot of different setups.""In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present.""The solution does occasionally get a few bugs, but this is typical for any product.""The dashboard should be simplified and made easier for exploration and decision making.""Not a ten because it's expensive and its ecosystem is not very open.""Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive.""It takes too long to escalate problems from the first level of support."

More SAP BW4HANA Cons »

"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.""Support needs improvement, as it can take several days before you get some initial support.""The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.""The solution could improve the user interface and add functionality to the system.""Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.""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.""If you go with one cloud provider, you can't switch.""Availability is a problem."

More Snowflake Cons »

Pricing and Cost Advice
"This is an expensive solution and there are costs in addition to the standard licensing fees.""We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything.""As an investment, the solution is very expensive."

More SAP BW4HANA Pricing and Cost Advice »

"Pricing can be confusing for customers.""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.""You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.""It is not cheap.""The pricing for Snowflake is competitive.""On average, with the number of queries that we run, we pay approximately $200 USD per month.""Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month.""The price of Snowflake is very reasonable."

More Snowflake Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
501,151 professionals have used our research since 2012.
Questions from the Community
Top Answer: Some of the main features of this solution are that it uses HANA and it has good performance.
Top Answer: As an investment, the solution is very expensive. We pay 72% every year to SAP. Additionally, we pay for support for the solution and a vendor to do maintenance.
Top Answer: Other competitors provide better solutions that are more up to date with current technology. For example, machine learning and artificial intelligence.
Top Answer: Many features: 1) Separate warehouse and the control user gets on it. 2) Auto caching features 3) Json and XML handling 4) Minimal DBA activity
Top Answer: In the beginning, we didn't know what we were doing, and we racked up huge compute costs, shockingly and quickly. But the sales team was extremely helpful and showed us where we were doing everything… more »
Top Answer: It would be better if they had a data profile tool that tells me where the gaps are in my time series data. We are anxiously waiting for them to release their data catalog and analytics capabilities… more »
Ranking
5th
out of 30 in Data Warehouse
Views
3,985
Comparisons
2,844
Reviews
10
Average Words per Review
529
Rating
7.8
1st
out of 30 in Data Warehouse
Views
34,806
Comparisons
24,549
Reviews
34
Average Words per Review
616
Rating
8.4
Popular Comparisons
Also Known As
SAP BW/4HANA
Snowflake Computing
Learn More
Overview

Streamline processes and support innovations with a single, trusted source for real-time insights. Based on SAP HANA, our next-generation data warehouse solution can help you capitalize on the full value of all your data from SAP applications or third-party solutions, as well as unstructured, geospatial, or Hadoop-based.

Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.

Offer
Learn more about SAP BW4HANA
Learn more about Snowflake
Sample Customers
Information Not Available
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Top Industries
VISITORS READING REVIEWS
Computer Software Company39%
Comms Service Provider18%
Manufacturing Company7%
Energy/Utilities Company6%
REVIEWERS
Computer Software Company44%
Manufacturing Company11%
Financial Services Firm11%
Wholesaler/Distributor11%
VISITORS READING REVIEWS
Computer Software Company30%
Comms Service Provider15%
Financial Services Firm7%
Insurance Company5%
Company Size
REVIEWERS
Small Business38%
Large Enterprise62%
REVIEWERS
Small Business29%
Midsize Enterprise22%
Large Enterprise49%
VISITORS READING REVIEWS
Small Business11%
Midsize Enterprise15%
Large Enterprise74%
Find out what your peers are saying about SAP BW4HANA vs. Snowflake and other solutions. Updated: May 2021.
501,151 professionals have used our research since 2012.

SAP BW4HANA is ranked 5th in Data Warehouse with 11 reviews while Snowflake is ranked 1st in Data Warehouse with 36 reviews. SAP BW4HANA is rated 7.8, while Snowflake is rated 8.4. The top reviewer of SAP BW4HANA writes "Good capabilities, direct approach, and the right reporting tool for SAP companies". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". SAP BW4HANA is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Apache Hadoop, Oracle Database Appliance and Microsoft Parallel Data Warehouse, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Firebolt, Amazon Redshift, Vertica and Yellowbrick Cloud Data Warehouse. 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.