SAP IQ vs Snowflake Analytics comparison

Cancel
You must select at least 2 products to compare!
SAP Logo
458 views|359 comparisons
83% willing to recommend
Snowflake Computing Logo
493 views|330 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SAP IQ and Snowflake Analytics 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.
To learn more, read our detailed SAP IQ vs. Snowflake Analytics Report (Updated: May 2024).
772,649 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 is very robust for ad hoc DW queries and its columnar compression is unique and valuable.""Columnar storage allows high compression, high load rates and high query performance.""The product is easy to learn.""The initial setup is easy.""Valuable features for us include the compression, speed, fast response time, and easy object maintenance.""The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution.""Unbeatable speed and compression with a colummn-structured relational database.""The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."

More SAP IQ Pros →

"It can run complex workloads with varied compute.""One of the key advancements in Snowflake Analytics is data sharing.""It ensures the optimization of the application development while maintaining the user-friendly nature of its UI.""The Snowflake features I find most beneficial for data analysis are primarily related to analytics, particularly their features like materialized views and queues, which are especially useful for dashboarding purposes.""The advanced features like time travel, zero copy cloning and scalability have been most useful. Snowflake requires zero maintenance for Data Warehousing on the cloud system.""Very good flexibility and it offers computation completely decoupled from the storage.""It's not necessary to use a physical server.""The most valuable feature of Snowflake Analytics is the ability to control and manage the cost."

More Snowflake Analytics Pros →

Cons
"The tool gets stuck sometimes.""The room for improvement would be the marketing of the product, because this product is much better than advertised.""Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups.""I think the universe should be part of the Sybase IQ tool set.""The organization who owns the product does not support it well and appears not to be doing significant development for the future.""There is very little documentation available.""The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better.""Concurrency and functional error messaging."

More SAP IQ Cons →

"One area that could benefit from enhancement is the user interface for more visual ESM features.""The platform's data governance space needs more capability.""The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises.""Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable.""Integration into different Python and Jupyter notebooks needs to be improved.""The solution needs to consider including some updates in the future.""The product's cost is an area of concern where improvements are required.""Machine learning should be improved."

More Snowflake Analytics Cons →

Pricing and Cost Advice
  • "Evaluate all options; check to see if you need expensive add-ons."
  • "Negotiate based on the features required."
  • "Negotiation is very important."
  • "The only costs after standard licensing fees are for add-ons and upgrades."
  • "It's not that costly. So, the pricing is cheap."
  • More SAP IQ Pricing and Cost Advice →

  • "Snowflake Analytics is a little more costly than Azure."
  • "When using Snowflake, you pay based on your usage. They calculate how much CPU has been used. If you use excess warehouse storage, you are charged one credit per hour. If you are in Asia, you are charged $3 per credit. If you have 10 users running parallel with the same excess, you will be charged $30."
  • "The cost of Snowflake Analytics is low, any small organization can use it."
  • "The solution's price is high and I would rate it an eight out of ten."
  • "On a scale of one to ten, where one is a low price, and ten is a high price, I rate the pricing a seven. The solution's pricing is high."
  • "It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
  • "The tool is quite expensive."
  • "Snowflake Analytics is not an expensive solution, and its pricing is average."
  • More Snowflake Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    772,649 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves… more »
    Top Answer:The tool gets stuck sometimes. The databases freeze suddenly during testing.
    Top Answer:The pricing is on the higher side. I would rate it seven out of ten.
    Top Answer:I haven't noticed any limitations with the solution. There could be more analytics. We find that IBM has a lot of pro data analytics that we use. The distribution methodology isn't as strong as… more »
    Ranking
    Views
    458
    Comparisons
    359
    Reviews
    1
    Average Words per Review
    559
    Rating
    7.0
    6th
    Views
    493
    Comparisons
    330
    Reviews
    30
    Average Words per Review
    486
    Rating
    8.4
    Comparisons
    Snowflake logo
    Compared 29% of the time.
    SAP HANA logo
    Compared 17% of the time.
    SQL Server logo
    Compared 16% of the time.
    SAP BW4HANA logo
    Compared 14% of the time.
    Apache Hadoop logo
    Compared 11% of the time.
    Also Known As
    Sybase IQ
    Learn More
    Overview

    SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

    Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.

    To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.

    Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.

    Sample Customers
    ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
    Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
    Top Industries
    REVIEWERS
    Financial Services Firm55%
    Marketing Services Firm9%
    Healthcare Company9%
    Insurance Company9%
    VISITORS READING REVIEWS
    Financial Services Firm40%
    Computer Software Company10%
    Manufacturing Company6%
    Government5%
    REVIEWERS
    Computer Software Company31%
    Financial Services Firm31%
    Outsourcing Company15%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm9%
    Manufacturing Company9%
    Retailer8%
    Company Size
    REVIEWERS
    Small Business20%
    Midsize Enterprise10%
    Large Enterprise70%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise8%
    Large Enterprise81%
    REVIEWERS
    Small Business22%
    Midsize Enterprise25%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise17%
    Large Enterprise63%
    Buyer's Guide
    SAP IQ vs. Snowflake Analytics
    May 2024
    Find out what your peers are saying about SAP IQ vs. Snowflake Analytics and other solutions. Updated: May 2024.
    772,649 professionals have used our research since 2012.

    SAP IQ is ranked 21st in Relational Databases Tools with 19 reviews while Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 31 reviews. SAP IQ is rated 7.8, while Snowflake Analytics is rated 8.4. The top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". On the other hand, the top reviewer of Snowflake Analytics writes "A scalable tool useful for data lake and data mining processes". SAP IQ is most compared with Snowflake, SAP HANA, SQL Server, SAP BW4HANA and Apache Hadoop, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our SAP IQ vs. Snowflake Analytics 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.