Try our new research platform with insights from 80,000+ expert users

SAP IQ vs Snowflake Analytics comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

SAP IQ
Average Rating
8.0
Number of Reviews
21
Ranking in other categories
Relational Databases Tools (24th), Data Warehouse (16th)
Snowflake Analytics
Average Rating
8.4
Number of Reviews
35
Ranking in other categories
Web Analytics (1st), Cloud Data Warehouse (8th)
 

Featured Reviews

Tejas Raj - PeerSpot reviewer
Columnar database, so pulling records is easy but there isn't enough documentation for installation
I've seen very few SAP IQ systems in recent years. So people are moving away from SAP IQ In the last three years, I've rarely encountered customers using it. Fewer systems with SAP IQ usage among our customers. Most of them have moved on to HANA. There are parallel products, and there are also viable alternatives from AWS, so many have migrated to those.
Manoj Kambli - PeerSpot reviewer
For processing data, it can be easily optimized and supports structured and unstructured data
In terms of cost. Many customers face issues with the expenses on Snowflake. The pricing visibility is complex. If you understand pricing, you can estimate costs, but if not, it can be challenging. They need to provide better cost visibility upfront. For example, credits are not always utilized properly, which isn't easy for new users. A more user-friendly cost calculator would help, as the current one requires expertise to use effectively. These things are not easy for someone who is new to Snowflake, unlike Azure's calculators, which give good visibility into the cost. It does have a calculator, but you need to be skilled in using it. Otherwise, it's hard to estimate the total cost for future loads. For additional features, there could be its own AI model like Google has Gemini. Snowflake can come up with those kinds of features for Analytics. If you can just type in your prompt and get answers, especially for Analytics people on the client side, they will love that. Like, in Google's Gemini, you type the prompt and get the answers based on the data available. If they come up with that kind of AI and UI, it will be easier for clients to analyze their data. They can just type a query like, "What is my highest selling product?" They don't have to write a complex query.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product is easy to learn."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The initial setup is easy."
"IQ is a very high-performance and high-transaction database."
"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."
"It's not necessary to use a physical server."
"It is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning."
"Scaling is very high – there's no problem for scaling purposes. The learning curve is very small. And there are a lot of advanced features like handling duplicates, security, data governance, data sharing, and data cloning."
"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."
"Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options."
"Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake."
"The most valuable feature of Snowflake Analytics is its performance."
"The solution auto-scales and it provides concurrency."
 

Cons

"I think the universe should be part of the Sybase IQ tool set."
"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"There is very little documentation available."
"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 tool gets stuck sometimes."
"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."
"Implementing everything on-premise is challenging because it require proper support from advisors, DBAs, and others."
"Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable."
"Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks."
"Integration into different Python and Jupyter notebooks needs to be improved."
"Snowflake Analytics should probably have more built-in tools for master data management."
"The platform could work easier for AI implementation compared to one of its competitors."
"One area that could benefit from enhancement is the user interface for more visual ESM features."
 

Pricing and Cost Advice

"Negotiation is very important."
"The cost of implementation is about $3,000."
"Evaluate all options; check to see if you need expensive add-ons."
"The only costs after standard licensing fees are for add-ons and upgrades."
"Negotiate based on the features required."
"It's not that costly. So, the pricing is cheap."
"It's not costly if you configure it properly to ensure optimal performance. People don't configure it properly, which is why costs go up."
"The pricing is on the higher side."
"The solution's price is high and I would rate it an eight out of ten."
"It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
"Snowflake Analytics is a little more costly than Azure."
"Snowflake Analytics is not an expensive solution, and its pricing is average."
"I have been using free trial version."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
43%
Computer Software Company
9%
Manufacturing Company
8%
Government
5%
Computer Software Company
14%
Retailer
10%
Financial Services Firm
9%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about SAP IQ?
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 mo...
What is your experience regarding pricing and costs for SAP IQ?
The cost of implementation is about $3,000. However, the cost is not much compared to the performance benefits.
What needs improvement with SAP IQ?
The only negative aspect of IQ is the cost, which can be challenging for companies in Peru.
What is your experience regarding pricing and costs for Snowflake Analytics?
I would rate the pricing of Snowflake Analytics a two out of ten, where one is cheap, and ten is expensive. Especially when compared to competitors and what they offer, the pricing is good. Users p...
What needs improvement with Snowflake Analytics?
Snowflake Analytics should probably have more built-in tools for master data management, data purification, and enhancement. Instead of using third-party tools, it would probably be good if it coul...
 

Comparisons

 

Also Known As

Sybase IQ
No data available
 

Learn More

Video not available
 

Overview

 

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
Find out what your peers are saying about SAP IQ vs. Snowflake Analytics and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.