Compare SAP Business Warehouse vs. Snowflake

Cancel
You must select at least 2 products to compare!
SAP Business Warehouse Logo
1,039 views|719 comparisons
Snowflake Logo
29,303 views|19,849 comparisons
Most Helpful Review
Use SAP Business Warehouse? Share your opinion.
Find out what your peers are saying about SAP Business Warehouse vs. Snowflake and other solutions. Updated: November 2020.
448,076 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 of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.""The warehouse is the solution's most valuable feature.""The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own.""Having the back-end data set with the right information is the best qualification for this solution.""The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice.""In terms of stability, comparatively, the solution is quite stable."

More SAP Business Warehouse 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
"The advanced structuring can be complicated and the interface is not very intuitive.""The solution could offer better connectivity with other databases.""More integration with Microsoft Office products (not just Excel) would be helpful.""I would like to see a different end solution in order to read the data and attract internal users.""A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution.""We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."

More SAP Business Warehouse 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
Information Not Available
"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 Cloud Data Warehouse solutions are best for your needs.
448,076 professionals have used our research since 2012.
Questions from the Community
Top Answer: In terms of stability, comparatively, the solution is quite stable.
Top Answer: The pricing is fairly high for the solution.
Top Answer: There are a lot of things that could be improved especially in terms of data cleansing, data management, data lineage, etc. The solution needs to offer more flexibility in terms of formulas and the… more »
Top Answer: Apache Hadoop is for data lake use cases. But getting data out of Hadoop for meaningful analytics is indeed need quite an amount of work. by either using spark/Hive/presto and so on. The way i look at… more »
Top Answer: The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.
Ranking
6th
Views
1,039
Comparisons
719
Reviews
6
Average Words per Review
687
Avg. Rating
7.5
1st
Views
29,303
Comparisons
19,849
Reviews
18
Average Words per Review
534
Avg. Rating
8.3
Popular Comparisons
Compared 8% of the time.
Compared 7% of the time.
Compared 7% of the time.
Compared 6% 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
REVIEWERS
Non Tech Company25%
Maritime Company13%
Pharma/Biotech Company13%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company32%
Media Company17%
Comms Service Provider11%
Manufacturing Company6%
REVIEWERS
Computer Software Company25%
Manufacturing Company25%
Media Company13%
Healthcare Company13%
VISITORS READING REVIEWS
Computer Software Company35%
Comms Service Provider14%
Financial Services Firm6%
Media Company6%
Company Size
REVIEWERS
Midsize Enterprise11%
Large Enterprise89%
REVIEWERS
Small Business32%
Midsize Enterprise9%
Large Enterprise59%
VISITORS READING REVIEWS
Small Business3%
Midsize Enterprise20%
Large Enterprise77%
Find out what your peers are saying about SAP Business Warehouse vs. Snowflake and other solutions. Updated: November 2020.
448,076 professionals have used our research since 2012.

SAP Business Warehouse is ranked 6th in Cloud Data Warehouse with 6 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 18 reviews. SAP Business Warehouse is rated 7.6, while Snowflake is rated 8.4. The top reviewer of SAP Business Warehouse writes "Has ready-made connectors where we can extract data from ". 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 and Microsoft Azure Synapse Analytics, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica, Teradata and Apache Hadoop. See our SAP Business Warehouse vs. Snowflake report.

See our list of best Cloud Data Warehouse vendors.

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.