SAP IQ pros and cons

Vendor: SAP

4.0 out of 5

17 reviews
81% willing to recommend

1,167 followers

Post review

SAP IQ Pros review quotes

it_user1055472

Snr DBA at a insurance company with 1,001-5,000 employees

Jul 29, 2019

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

Read full review

it_user727509

Technology Lead at CGI Information Systems and Management Consultants

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

Manager, SAP Basis at The Scotts Miracle-Gro Company

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.

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: March 2024.

DOWNLOAD NOW

768,578 professionals have used our research since 2012.

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.

Read full review

it_user705720

Senior SAP SYBASE/SQL SERVER DBA at a financial services firm with 10,001+ employees

Jul 19, 2017

Valuable features for us include the compression, speed, fast response time, and easy object maintenance.

Read full review

it_user155730

Database Senior Manager at a financial services firm with 201-500 employees

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

Snr DBA at a insurance company with 1,001-5,000 employees

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

Technology Lead at CGI Information Systems and Management Consultants

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

Manager, SAP Basis at The Scotts Miracle-Gro Company

Mar 1, 2023

The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better.

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: March 2024.

DOWNLOAD NOW

768,578 professionals have used our research since 2012.

it_user719802

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

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

it_user705720

Senior SAP SYBASE/SQL SERVER DBA at a financial services firm with 10,001+ employees

Jul 19, 2017

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

Read full review

it_user155730

Database Senior Manager at a financial services firm with 201-500 employees

Jun 29, 2017

Concurrency and functional error messaging.

Read full review