SAP IQ Reviews

Vendor: SAP

3.9 out of 5

19 reviews
83% willing to recommend

1,169 followers

What is SAP IQ?

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 #22 ranked solution in top Relational Databases. PeerSpot users give SAP IQ an average rating of 7.8 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 82% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 42% of all views.

Helped 793,295 peers since 2012

Featured reviews

Mani Velayudhan

Manager, SAP Basis at The Scotts Miracle-Gro Company

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

Tejas Raj

Manager at Capgemini

It's used for reporting purposes. We can quickly pull in large volumes of records It's a columnar database, so pulling records is easy. This makes it simple to generate reports and analyze data, such as tracking the growth of records. I've seen very few SAP IQ systems in recent years. So people…

Read full review

Pavankumar Balusupati

Member of Technical Staff at HCL Technologies

We use the solution to secure and install databases and test networking tools The solution allows a high number of concurrent users. It enables Petabyte-Scale Data Warehousing. It's a column-oriented database management system. It can be used as a data mart. The product is easy to learn. The…

Read full review

SAP IQ mindshare

Product category:

As of July 2024, the mindshare of SAP IQ in the Relational Databases Tools category stands at 0.4%, up from 0.3% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Relational Databases Tools

Key learnings from peers

Last updated May 16, 2024

Valuable Features

"The initial setup is easy."
"The product is easy to learn."
"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."

Room for Improvement

"There is very little documentation available."
"The tool gets stuck sometimes."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."