Compare SAP Business Warehouse vs. Snowflake

SAP Business Warehouse is ranked 6th in Cloud Data Warehouse with 3 reviews while Snowflake is ranked 2nd in Cloud Data Warehouse with 10 reviews. SAP Business Warehouse is rated 7.4, while Snowflake is rated 8.2. The top reviewer of SAP Business Warehouse writes "Provides rapid responses but needs better reporting and pattern/exception detection". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". SAP Business Warehouse is most compared with Amazon Redshift, Microsoft Azure SQL Data Warehouse and Snowflake, whereas Snowflake is most compared with Apache Hadoop, Microsoft Azure SQL Data Warehouse and Amazon Redshift. See our SAP Business Warehouse vs. Snowflake report.
Cancel
You must select at least 2 products to compare!
Snowflake Logo
17,496 views|12,527 comparisons
Most Helpful Review
Find out what your peers are saying about SAP Business Warehouse vs. Snowflake and other solutions. Updated: January 2020.
390,810 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 warehouse is the solution's most valuable feature.The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us.We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution.

Read more »

I like the idea that you can assign roles and responsibilities, limiting access to data.It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.The snapshot feature is good, the rollback feature is good and the interface is user-friendly.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 initial setup is straightforward. You just need to follow the documentation.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 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.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.

Read more »

Cons
The solution could offer better connectivity with other databases.The advanced structuring can be complicated and the interface is not very intuitive.One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection.You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy.

Read more »

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

Read more »

Pricing and Cost Advice
Information Not Available
You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.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.Pricing can be confusing for customers.

Read more »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
390,810 professionals have used our research since 2012.
Ranking
6th
Views
994
Comparisons
716
Reviews
3
Average Words per Review
438
Avg. Rating
7.3
2nd
Views
17,496
Comparisons
12,527
Reviews
8
Average Words per Review
669
Avg. Rating
8.3
Top Comparisons
Compared 13% of the time.
Compared 24% of the time.
Compared 13% of the time.
Also Known As
Snowflake Computing
Learn
SAP
Snowflake Computing
Overview

Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

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 Business Warehouse
Learn more about Snowflake
Sample Customers
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, VodafoneAccordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Top Industries
No Data Available
VISITORS READING REVIEWS
Software R&D Company38%
Financial Services Firm10%
Insurance Company7%
Comms Service Provider6%
Company Size
No Data Available
REVIEWERS
Small Business20%
Midsize Enterprise20%
Large Enterprise60%
VISITORS READING REVIEWS
Small Business4%
Midsize Enterprise17%
Large Enterprise79%
Find out what your peers are saying about SAP Business Warehouse vs. Snowflake and other solutions. Updated: January 2020.
390,810 professionals have used our research since 2012.
We monitor all Cloud 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.