SAP NetWeaver Business Warehouse vs Snowflake comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SAP NetWeaver Business Warehouse and Snowflake based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed SAP NetWeaver Business Warehouse vs. Snowflake Report (Updated: March 2024).
765,234 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It provides us with proof of data, we can centralize all of the information, check it, and then provide the information to our users.""Data modeling is a valuable feature.""It's an excellent over-all tool for managers to analyze their business.""The security and audit procedures are the most valuable features.""It is a robust system.""Transformation is a valuable feature of SAP NetWeaver. I can transform the data as per my needs or my client's needs. For example, flat tables can be transformed with respect to our requirements to combine multiple modules into one single table, and we can derive analytics.""A robust and efficient product."

More SAP NetWeaver Business Warehouse Pros →

"Working with Parquet files is support out of the box and it makes large dataset processing much easier.""Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services.""The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed.""The snapshot feature is good, the rollback feature is good and the interface is user-friendly.""The pricing is reasonable and matches the rest of the market.""The solution is very easy to use.""It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability.""The querying speed is fast."

More Snowflake Pros →

Cons
"Connectors are complex, and it is difficult to understand or know which connector should be used. For instance, if I want to connect APIs, I will not be able to do it directly. I would have to go to the portal integration to get the data. Therefore, having simplified connectors will make things much easier.""The program is difficult to learn to use""The product could provide more features.""There are performance issues in terms of scalability and availability.""Design and modeling could be simplified.""It is difficult when your native language is not English. It is difficult for us to explain our issue and also difficult for the technical team to explain a resolution to us.""I think more integration with other applications would be perfect."

More SAP NetWeaver Business Warehouse Cons →

"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better.""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.""Their UiPath, the workspace area, needs some work.""It's difficult to know how to size everything correctly.""The solution could improve the user interface and add functionality to the system.""They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that.""The pricing of the solution should be much easier to calculate or find by yourself.""We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."

More Snowflake Cons →

Pricing and Cost Advice
  • "Pricing is based on the number of user IDs and tyhe user ID works across a suite of products."
  • "The licensing cost is high for SAP NetWeaver compared to that for other products."
  • "All SAP products are expensive."
  • More SAP NetWeaver Business Warehouse 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.
    765,234 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
    Top Answer:The real-time streaming feature is limited with Snowflake and could be improved. Currently, Snowflake doesn't support unstructured data. With Snowflake, you need to be very particular about the type… more »
    Ranking
    14th
    out of 33 in Data Warehouse
    Views
    280
    Comparisons
    201
    Reviews
    3
    Average Words per Review
    314
    Rating
    8.0
    1st
    out of 33 in Data Warehouse
    Views
    12,615
    Comparisons
    7,271
    Reviews
    40
    Average Words per Review
    455
    Rating
    8.4
    Comparisons
    Also Known As
    NetWeaver Business Warehouse, NetWeaver BusinessObjects Warehouse
    Snowflake Computing
    Learn More
    Overview
    With NetWeaver Business Warehouse, you can quickly Capture, store, and consolidate your vital information with our real-time data warehouse platform. Tightly integrate your warehousing capabilities for a single version of the truth, decision-ready business intelligence, and accelerated operations.

    Snowflake is a cloud-based data warehousing solution for storing and processing data, generating reports and dashboards, and as a BI reporting source. It is used for optimizing costs and using financial data, as well as for migrating data from on-premises to the cloud. The solution is often used as a centralized data warehouse, combining data from multiple sources.

    Snowflake has helped organizations improve query performance, store and process JSON and XML, consolidate multiple databases into one unified table, power company-wide dashboards, increase productivity, reduce processing time, and have easy maintenance with good technical support.

    Its platform is made up of three components:

    1. Cloud services - Snowflake uses ANSI SQL to empower users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    2. Query processing - Snowflake's compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses does not compete for computing resources, nor do they affect the performance of each other.
    3. Database storage - Snowflake automatically manages all parts of the data storage process, including file size, compression, organization, structure, metadata, and statistics.

    Snowflake has many valuable vital features. Some of the most useful ones include:

    • Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports unlimited concurrent users and workloads, from interactive to batch.
    • Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • With seamless cross-cloud and cross-region connections, Snowflake eliminates ETL and data silos. Anyone who needs access to shared secure data can get a single copy via the data cloud. In addition, Snowflake makes remote collaboration and decision-making fast and easy via a single shared data source.
    • Snowflake’s Data Marketplace offers third-party data, which allows you to connect with Snowflake customers to extend workflows with data services and third-party applications.

    There are many benefits to implementing Snowflake. It helps optimize costs, reduce downtime, improve operational efficiency, and automate data replication for fast recovery, and it is built for high reliability and availability.

      Below are quotes from interviews we conducted with users currently using the Snowflake solution:

      Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "Data sharing is a good feature. It is a majorly used feature. The elastic computing is another big feature. Separating computing and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not doing any performance tuning, and the entire burden of performance and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."

      A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."

      A Solution Architect at a wholesaler/distributor comments, "The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."

      Sample Customers
      EMC Corporation, Takisada-Osaka Co. Ltd., Eldorado, Mozzart, The VELUX Group, AOK Bundesverband, Hilti Group, Nissha Printing Company Ltd., Asian Paints, Aareal Bank Group, Magazine zum Globus (Migros Group)
      Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
      Top Industries
      VISITORS READING REVIEWS
      Computer Software Company19%
      Manufacturing Company16%
      Transportation Company9%
      Comms Service Provider7%
      REVIEWERS
      Computer Software Company29%
      Financial Services Firm20%
      Healthcare Company6%
      Manufacturing Company6%
      VISITORS READING REVIEWS
      Educational Organization26%
      Financial Services Firm13%
      Computer Software Company10%
      Manufacturing Company6%
      Company Size
      REVIEWERS
      Small Business22%
      Large Enterprise78%
      VISITORS READING REVIEWS
      Small Business20%
      Midsize Enterprise7%
      Large Enterprise73%
      REVIEWERS
      Small Business24%
      Midsize Enterprise20%
      Large Enterprise55%
      VISITORS READING REVIEWS
      Small Business15%
      Midsize Enterprise33%
      Large Enterprise52%
      Buyer's Guide
      SAP NetWeaver Business Warehouse vs. Snowflake
      March 2024
      Find out what your peers are saying about SAP NetWeaver Business Warehouse vs. Snowflake and other solutions. Updated: March 2024.
      765,234 professionals have used our research since 2012.

      SAP NetWeaver Business Warehouse is ranked 14th in Data Warehouse with 9 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. SAP NetWeaver Business Warehouse is rated 7.8, while Snowflake is rated 8.4. The top reviewer of SAP NetWeaver Business Warehouse writes "Powerful solution with good security and audit procedure features". 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 NetWeaver Business Warehouse is most compared with SAP BW4HANA and SAP Business Warehouse, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our SAP NetWeaver Business Warehouse vs. Snowflake report.

      See our list of best Data Warehouse vendors and best Cloud 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.