SAP IQ vs Snowflake Analytics comparison

Cancel
You must select at least 2 products to compare!
SAP Logo
458 views|359 comparisons
81% 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: March 2024).
770,428 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
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution.""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.""Columnar storage allows high compression, high load rates and high query performance.""It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.""Unbeatable speed and compression with a colummn-structured relational database.""Valuable features for us include the compression, speed, fast response time, and easy object maintenance."

More SAP IQ Pros →

"The platform not only provides ease of use but also stands out for its speedy execution, conveying a sense of robustness and reliability that I find appealing.""What we found most valuable in Snowflake Analytics are its attributes that are very convenient for business use such as data sharing, cloning, time travel, and fail-safe. It's a good product all in all.""I am impressed with the product's data-sharing feature.""The solution auto-scales and it provides concurrency.""It is quite a convenient tool.""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.""One of the key advancements in Snowflake Analytics is data sharing.""The most valuable feature of Snowflake Analytics is its performance."

More Snowflake Analytics Pros →

Cons
"Concurrency and functional error messaging.""The organization who owns the product does not support it well and appears not to be doing significant development for the future.""The room for improvement would be the marketing of the product, because this product is much better than advertised.""I think the universe should be part of the Sybase IQ tool set.""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.""The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."

More SAP IQ Cons →

"Snowflake's Snowpark is an area of concern where improvements are required.""The solution’s scalability could be improved.""The technical support is not very good.""The platform could work easier for AI implementation compared to one of its competitors.""The distribution methodology isn't as strong as Bethesda or SAP HANA. It's not as strong as other competitors.""The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms.""Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake.""The solution needs to consider including some updates in the future."

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."
  • 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.
    770,428 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 solution’s pricing is high, but coverage is good with high implementation with customer requirements.
    Top Answer:The product should add more business intelligence factors.
    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 30% of the time.
    SAP HANA logo
    Compared 18% of the time.
    SAP BW4HANA logo
    Compared 15% of the time.
    SQL Server 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 Firm39%
    Computer Software Company10%
    Manufacturing Company7%
    Government4%
    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 Business22%
    Midsize Enterprise11%
    Large Enterprise67%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise8%
    Large Enterprise81%
    REVIEWERS
    Small Business22%
    Midsize Enterprise25%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise18%
    Large Enterprise62%
    Buyer's Guide
    SAP IQ vs. Snowflake Analytics
    March 2024
    Find out what your peers are saying about SAP IQ vs. Snowflake Analytics and other solutions. Updated: March 2024.
    770,428 professionals have used our research since 2012.

    SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews while Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews. SAP IQ is rated 8.0, 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, SAP BW4HANA, SQL Server 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.