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 useful feature has been he ability to feed data into multiple systems in various formats."
"With the technical support, the response has been pretty good from the SAP side."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"Out-of-the-box reports are very useful."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
"Having the integration with the reporting tool which is provided by SAP is great."
"In terms of stability, comparatively, the solution is quite stable."
"The speed of data loading and being able to quickly create the environment are most valuable."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"The solution speeds up the process of onboarding."
"It was relatively easy to use, and it was easy for people to convert to it."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"The solution is very stable."
"The solution is very easy to use."
"There is room for improvement from a technical perspective."
"The solution should be more open to the cloud."
"The advanced structuring can be complicated and the interface is not very intuitive."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"It's a product that is at the end of life so they will not improve it anymore."
"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."
"They should reduce the product’s installation package size for easier downloading."
"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."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"Some SQL language functions could be included."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 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.