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

SAP IQ pros and cons

Vendor: SAP
4.0 out of 5
1,168 followers
Post review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Columnar storage in SAP IQ allows for high compression, high load rates, and superior query performance.
Compression, speed, fast response time, and easy object maintenance are valuable features highlighted by users.
SAP IQ's robustness for ad hoc DW queries and its unique columnar compression are highly regarded.
The technology offers unbeatable speed and compression through its column-structured relational database.
SAP IQ efficiently manages data by limiting expansion in SAP HANA and enables archiving with SAP NLS while maintaining data accessibility.

CONS

There are consistency problems in the metadata of SAP IQ, risking loss of metadata consistency.
Multiplex in SAP IQ is very problematic.
The organization owning SAP IQ appears not to support it well, with little significant development for the future.
There is very little documentation available for SAP IQ.
The primary negative aspect is the cost, which can be challenging for companies in Peru due to economic conditions.
 

SAP IQ Pros review quotes

it_user1055472 - PeerSpot reviewer
Jul 29, 2019
Unbeatable speed and compression with a colummn-structured relational database.
it_user727509 - PeerSpot reviewer
Aug 29, 2017
The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution.
Mani Velayudhan - PeerSpot reviewer
Mar 1, 2023
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.
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,053 professionals have used our research since 2012.
Fredy Alfaro - PeerSpot reviewer
Oct 3, 2024
IQ is a very high-performance and high-transaction database.
it_user719802 - PeerSpot reviewer
Aug 16, 2017
It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.
Fredy Alfaro - PeerSpot reviewer
Nov 7, 2024
All data is compressed and indexed, allowing for fast execution of transactions.
Tejas Raj - PeerSpot reviewer
May 14, 2024
The initial setup is easy.
it_user705720 - PeerSpot reviewer
Jul 19, 2017
Valuable features for us include the compression, speed, fast response time, and easy object maintenance.
Pavankumar Balusupati - PeerSpot reviewer
May 14, 2024
The product is easy to learn.
it_user155730 - PeerSpot reviewer
Jun 29, 2017
Columnar storage allows high compression, high load rates and high query performance.
 

SAP IQ Cons review quotes

it_user1055472 - PeerSpot reviewer
Jul 29, 2019
The organization who owns the product does not support it well and appears not to be doing significant development for the future.
it_user727509 - PeerSpot reviewer
Aug 29, 2017
The room for improvement would be the marketing of the product, because this product is much better than advertised.
Mani Velayudhan - PeerSpot reviewer
Mar 1, 2023
The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better.
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,053 professionals have used our research since 2012.
Fredy Alfaro - PeerSpot reviewer
Oct 3, 2024
The only negative aspect of IQ is the cost, which can be challenging for companies in Peru.
it_user719802 - PeerSpot reviewer
Aug 16, 2017
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.
Fredy Alfaro - PeerSpot reviewer
Nov 7, 2024
The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru.
Tejas Raj - PeerSpot reviewer
May 14, 2024
There is very little documentation available.
it_user705720 - PeerSpot reviewer
Jul 19, 2017
I think the universe should be part of the Sybase IQ tool set.
Pavankumar Balusupati - PeerSpot reviewer
May 14, 2024
The tool gets stuck sometimes.
it_user155730 - PeerSpot reviewer
Jun 29, 2017
Concurrency and functional error messaging.