We performed a comparison between SAP Business Warehouse and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable aspect of the solution is the integration with SAP ERP."
"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."
"In terms of stability, comparatively, the solution is quite stable."
"The product is very stable."
"Having the integration with the reporting tool which is provided by SAP is great."
"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."
"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."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"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."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"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 of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
"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."
"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."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"They should reduce the product’s installation package size for easier downloading."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"They should improve the reporting tools."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"If they could bring in some tools for data integration, it would be really great."
"The design of the product is easily misunderstood."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 reviews. SAP Business Warehouse is rated 7.8, while Snowflake is rated 8.4. The top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". 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 Business Warehouse is most compared with Microsoft Azure Synapse Analytics, BigQuery, SAP BW4HANA, SAP NetWeaver Business Warehouse and Amazon Redshift, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our SAP Business Warehouse vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors and best 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.