SAP IQ Reviews

Vendor: SAP

4.0 out of 5

17 reviews
81% willing to recommend

1,167 followers

What is SAP IQ?UNIXBusinessApplication
Price:

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.

Get the SAP IQ Buyer's Guide and find out what your peers are saying about SAP IQ, SQL Server, Snowflake and more!

SAP IQ is the #16 ranked solution in top Data Warehouse solutions and #21 ranked solution in top Relational Databases. PeerSpot users give SAP IQ an average rating of 8.0 out of 10. SAP IQ is most commonly compared to SQL Server: SAP IQ vs SQL Server. SAP IQ is popular among the large enterprise segment, accounting for 81% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 39% of all views.

Helped 769,789 peers since 2012

Featured reviews

Mani Velayudhan

Manager, SAP Basis at The Scotts Miracle-Gro Company

Mar 1, 2023

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

Mohamed-Abdalla

IT Manager at PCWORLD Egypt

Jan 15, 2024

We have a military customer, a joint venture between the Ministry of Defense of Egypt and the TELUS Group, working with SAP IQ When a customer tries to change to business intelligence, they acquire a lot to orient the business with stakeholders, which is an important key and the decision maker in…

Read full review

it_user719802

Senior Database Administrator & BigData Administrator at a financial services firm with 10,001+ employees

Aug 16, 2017

It is very robust for ad hoc DW queries and its columnar compression is unique and valuable My organization was using different RDBMs for data warehouse systems. There were obvious problems in terms of performance. Sybase IQ resolved all the performance problems we had at that time. They should…

Read full review

SAP IQ market share

Product category:

As of April 2024, the market share of SAP IQ in the Relational Databases Tools category stands at 0.9%, marking an increase of 165.3% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Relational Databases Tools

Key learnings from peers

Valuable Features

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

Room for Improvement

"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"I think the universe should be part of the Sybase IQ tool set."