SAP IQ Reviews

Vendor: SAP

4.0 out of 5

21 reviews
84% willing to recommend

1,168 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, Teradata and more!

SAP IQ is the #12 ranked solution in top Data Warehouse solutions and #18 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 43% of all views.

Helped 823,795 peers since 2012

Featured reviews

Tejas Raj

Manager at Capgemini

I've seen very few SAP IQ systems in recent years. So people are moving away from SAP IQ In the last three years, I've rarely encountered customers using it. Fewer systems with SAP IQ usage among our customers. Most of them have moved on to HANA. There are parallel products, and there are also viable alternatives from AWS, so many have migrated to those.

Read full review

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

Fredy Alfaro

Systems Engineer at a tech services company with 1-10 employees

I implemented the creation of new databases and migration of data in both production and development environments using IQ. It is a columnar database and a very transactional one. We also competed with Teradata Base. In IQ, this same transaction is executed in 30 seconds With IQ, a transaction…

Read full review

SAP IQ mindshare

Product category:

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

Relational Databases Tools

PeerAnalyst reports

Type	Title	Date
Category	Relational Databases Tools	Dec 17, 2024	Download
Product	Reviews, tips, and advice from real users	Dec 17, 2024	Download
Comparison	SAP IQ vs SQL Server	Dec 17, 2024	Download
Comparison	SAP IQ vs Oracle Database	Dec 17, 2024	Download
Comparison	SAP IQ vs MySQL	Dec 17, 2024	Download

Title	Rating	Mindshare	Recommending
SQL Server	4.2	21.4%	93%	266 interviews Add to research
Teradata	4.1	5.3%	87%	76 interviews Add to research

Valuable Features

"All data is compressed and indexed, allowing for fast execution of transactions."
"IQ is a very high-performance and high-transaction database."
"The initial setup is easy."

Room for Improvement

"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."
"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."
"There is very little documentation available."