SAP IQ vs Snowflake Analytics comparison

SAP IQ

Read 19 SAP IQ reviews

458 Views
355 Comparison Views

83% willing to recommend

Snowflake Analytics

Read 31 Snowflake Analytics reviews

482 Views
324 Comparison Views

100% willing to recommend

SAP IQ

Snowflake Analytics

Comparison Buyer's Guide

Download the report

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).

Buyer's Guide

SAP IQ vs. Snowflake Analytics

May 2024

Download the complete report

Helped 787,817 peers since 2012

Categories and Ranking

SAP IQ

Average Rating

7.8

Number of Reviews

Ranking in other categories

Relational Databases Tools (21st), Data Warehouse (17th)

Snowflake Analytics

Average Rating

8.4

Number of Reviews

Ranking in other categories

Web Analytics (1st), Cloud Data Warehouse (6th)

Mindshare comparison

As of June 2024, in the Cloud Data Warehouse category, the mindshare of SAP IQ is 0.6%, up from 0.6% compared to the previous year. The mindshare of Snowflake Analytics is 0.2%, down from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

Unique Categories:

Relational Databases Tools

0.6%

Data Warehouse

2.7%

Web Analytics

7.0%

Featured Reviews

Mani Velayudhan

Manager, SAP Basis at The Scotts Miracle-Gro Company

Mar 1, 2023

Easy to use, highly stable, but integration could improve

SAP IQ closely resembles OpenText, which I use in conjunction with the SAP ECC ERP system. However, for BW, I utilize SAP NLS instead of OpenText, which functions as a storage unit for my data. The process is straightforward as I move the data from SAP HANA to NLS. Generally, there isn't much activity with SAP NLS, and I only retrieve data from it occasionally upon request. It isn't a system that presents any daily challenges, and mostly, it remains inactive, managing my legacy data in the background. Overall, I'm satisfied with its performance, and I don't have any current plans to modify the system. We are using SAP IQ because it was available from SAP to support archiving. SAP BW, was SAP NLS. They never recommended an OpenText or there was no path to archiving in SAP BW. The standard setters use SAP NLS and SAP NLS runs on SAP IQ. My advice to others is if they have SAP BW, then they should use SAP IQ, but if they have SAP BW, but have other SAP systems that might not need SAP IQ, they can look for other options. I rate SAP IQ a seven out of ten. Overall the solution is easy to use and highly stable.

Read full review

Keerthivas Raja

Data Governance/Data Engineering Manager at National Bank of Fujairah PJSC

Mar 6, 2024

Enhanced our data warehousing capabilities, learning curve is very small and data sharing and data sampling are very easy

There are a few areass of improvement. * Databricks may be superior for machine learning, Snowflake is still maturing in that area. Also, 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. * Python integration is still an upcoming capability within Snowflake. * Additionally, loading data from the cloud to Snowflake is straightforward, but we still lack the capability to do the reverse – from Snowflake to the cloud.

Read full review

Quotes from Members

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

Pros

"Columnar storage allows high compression, high load rates and high query performance."

"The initial setup is easy."

"Unbeatable speed and compression with a colummn-structured relational database."

"The product is easy to learn."

"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."

"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."

"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."

"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."

"It can run complex workloads with varied compute."

"One of the valuable features is the solution’s time travel capability. The solution is highly stable. The solution is highly scalable. The initial setup is straightforward, and the deployment process is quick and efficient. I recommend the solution. Overall, I rate it a perfect ten."

"It is quite a convenient tool."

"Its performance speed is very good."

"I am impressed with the product's data-sharing feature."

"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."

More Snowflake Analytics pros

Cons

"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."

"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."

"There is very little documentation available."

"I think the universe should be part of the Sybase IQ tool set."

"The room for improvement would be the marketing of the product, because this product is much better than advertised."

"Concurrency and functional error messaging."

"There are issues while loading data from Snowflake Analytics to the Power BI reporting."

"One area that could benefit from enhancement is the user interface for more visual ESM features."

"Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake."

"The product's cost is an area of concern where improvements are required."

"The solution needs to consider including some updates in the future."

"The platform's data governance space needs more capability."

"Snowflake's Snowpark is an area of concern where improvements are required."

"The UI could be more user-friendly."

More Snowflake Analytics cons

Pricing and Cost Advice

"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."

"Negotiation is very important."

"Negotiate based on the features required."

"It's not that costly. So, the pricing is cheap."

"I have been using free trial version."

"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."

"The solution's pricing is affordable."

"The solution's price is high and I would rate it an eight out of ten."

"The cost of Snowflake Analytics is low, any small organization can use it."

"It is not overly expensive. I would rate the pricing a six out of ten, with ten being expensive."

"I rate the product's licensing cost a five or six on a scale of one to ten, where one is low price, and ten is high price."

More Snowflake Analytics pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

787,817 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

41%

Computer Software Company

10%

Manufacturing Company

Government

Computer Software Company

16%

Financial Services Firm

Manufacturing Company

Retailer

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...

See all answers

What is your experience regarding pricing and costs for SAP IQ?

It's not that costly. So, the pricing is cheap.

See all answers

What needs improvement with SAP IQ?

The tool gets stuck sometimes. The databases freeze suddenly during testing.

See all answers

What do you like most about Snowflake Analytics?

Its performance speed is very good.

See all answers

What is your experience regarding pricing and costs for Snowflake Analytics?

The pricing is on the higher side. I would rate it seven out of ten.

See all answers

What needs improvement with Snowflake Analytics?

Some functionalities available through SQL are inaccessible in Python or Java within Snowflake. Snowflake must enhance its support for these programming languages to offer full flexibility and capa...

See all answers

Comparisons

Snowflake vs SAP IQ

Compared 30% of the time

SQL Server vs SAP IQ

Compared 17% of the time

SAP HANA vs SAP IQ

Compared 17% of the time

SAP BW4HANA vs SAP IQ

Compared 14% of the time

Apache Hadoop vs SAP IQ

Compared 11% of the time

More SAP IQ Competitors

Azure Data Factory vs Snowflake Analytics

Compared 26% of the time

Adobe Analytics vs Snowflake Analytics

Compared 22% of the time

Mixpanel vs Snowflake Analytics

Compared 17% of the time

Amplitude vs Snowflake Analytics

Compared 11% of the time

Glassbox vs Snowflake Analytics

Compared 9% of the time

More Snowflake Analytics Competitors

Product Reports

Buyer's Guide

SAP IQ

May 2024

Download SAP IQ product report

Buyer's Guide

Snowflake Analytics

May 2024

Download Snowflake Analytics product report

Also Known As

Sybase IQ

No data available

Learn More

SAP

Snowflake Computing

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

Buyer's Guide

SAP IQ vs. Snowflake Analytics

May 2024

Free Report: SAP IQ vs. Snowflake Analytics

Find out what your peers are saying about SAP IQ vs. Snowflake Analytics and other solutions. Updated: May 2024.

DOWNLOAD NOW

787,817 professionals have used our research since 2012.

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.