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
 

SAP IQ Pros review quotes

it_user1055472 - PeerSpot reviewer
Jul 29, 2019
Unbeatable speed and compression with a colummn-structured relational database.
Read full review
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.
Read full review
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.
Read full review
Buyer's Guide
SAP IQ
October 2024
Free Report: SAP IQ Reviews and More
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
DOWNLOAD NOW
816,406 professionals have used our research since 2012.
Fredy Alfaro - PeerSpot reviewer
Oct 3, 2024
IQ is a very high-performance and high-transaction database.
Read full review
it_user719802 - PeerSpot reviewer
Aug 16, 2017
It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.
Read full review
Fredy Alfaro - PeerSpot reviewer
Nov 7, 2024
All data is compressed and indexed, allowing for fast execution of transactions.
Read full review
Tejas Raj - PeerSpot reviewer
May 14, 2024
The initial setup is easy.
Read full review
it_user705720 - PeerSpot reviewer
Jul 19, 2017
Valuable features for us include the compression, speed, fast response time, and easy object maintenance.
Read full review
Pavankumar Balusupati - PeerSpot reviewer
May 14, 2024
The product is easy to learn.
Read full review
it_user155730 - PeerSpot reviewer
Jun 29, 2017
Columnar storage allows high compression, high load rates and high query performance.
Read full review
 

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.
Read full review
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.
Read full review
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.
Read full review
Buyer's Guide
SAP IQ
October 2024
Free Report: SAP IQ Reviews and More
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
DOWNLOAD NOW
816,406 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.
Read full review
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.
Read full review
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.
Read full review
Tejas Raj - PeerSpot reviewer
May 14, 2024
There is very little documentation available.
Read full review
it_user705720 - PeerSpot reviewer
Jul 19, 2017
I think the universe should be part of the Sybase IQ tool set.
Read full review
Pavankumar Balusupati - PeerSpot reviewer
May 14, 2024
The tool gets stuck sometimes.
Read full review
it_user155730 - PeerSpot reviewer
Jun 29, 2017
Concurrency and functional error messaging.
Read full review

Product Categories

Product Categories
Relational Databases Tools
Data Warehouse

Popular Comparisons

Popular Comparisons
SQL Server vs SAP IQ Logo
SQL Server vs SAP IQ
Teradata vs SAP IQ Logo
Teradata vs SAP IQ
SAP HANA vs SAP IQ Logo
SAP HANA vs SAP IQ
IBM Db2 Database vs SAP IQ Logo
IBM Db2 Database vs SAP IQ
Oracle Database In-Memory vs SAP IQ Logo
Oracle Database In-Memory vs SAP IQ
SAP Adaptive Server Enterprise vs SAP IQ Logo
SAP Adaptive Server Enterprise vs SAP IQ
See all alternatives

Product Categories

Product Categories
Relational Databases Tools
Data Warehouse

Popular Comparisons

Popular Comparisons
SQL Server vs SAP IQ Logo
SQL Server vs SAP IQ
Teradata vs SAP IQ Logo
Teradata vs SAP IQ
SAP HANA vs SAP IQ Logo
SAP HANA vs SAP IQ
IBM Db2 Database vs SAP IQ Logo
IBM Db2 Database vs SAP IQ
Oracle Database In-Memory vs SAP IQ Logo
Oracle Database In-Memory vs SAP IQ
SAP Adaptive Server Enterprise vs SAP IQ Logo
SAP Adaptive Server Enterprise vs SAP IQ
See all alternatives
Related questions
  • 7
When evaluating Relational Databases, what aspect do you think is the most important to look for?
  • 136
Do general purpose or OLTP Oracle databases really perform better on SPARC based servers?
  • 14
Microsoft sql2017 VS SAP Hana
  • 197
What is the best database choice for a long term plan?
  • 3
SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
  • 25
How does NuoDB compare to MySQL and SQL Server?
  • 30
Which RDBMS tool do you prefer and why?
  • 23
Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
  • 2
Why is Relational Databases Tools important for companies?