Tech Director at a computer software company with 1,001-5,000 employees
Real User
Top 20
Aug 21, 2025
I do not use SAP IQ's machine learning capabilities. I cannot assess the benefit of SAP IQ's distributed query processing for complex queries, as I am a non-technical operator. I am not sure if we use SAP IQ's data compression features. I think the compression we are doing is on the data storage level and not on the database level. I believe we do not use it, but I'm not certain. We do not utilize SAP IQ's support for unstructured data, as we do not have unstructured data. I do not have any strong opinions on SAP IQ's security features such as data encryption. It's not been something that has been much in focus, neither in our choice of the platform, nor in our daily operations. I guess they're satisfactory as they have not been a problem. I am not aware of the pricing and licensing of SAP IQ, as it's part of a bigger agreement, and I'm not the owner of that agreement. My impression is that SAP IQ is a rather expensive tool in terms of value for money. On a scale of 1-10, I rate SAP IQ a 7.
Systems Engineer at a tech services company with 1-10 employees
Reseller
Top 5
Oct 3, 2024
IQ is an excellent product. I do not understand why SAP does not make it more commercially available or supported. I'd rate the solution nine out of ten.
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.
Snr DBA at a insurance company with 1,001-5,000 employees
Real User
Jul 29, 2019
In rating the product, I would give it at least an 8 out of ten. The only thing really needed to make it a ten out of ten for us and our usage is better support from the vendor. Well, I say better support but also better vision into the future. I do not think the company is doing sufficient work in development. My advice for other people and companies considering this product as a solution is to find out if you can get proper support. I really think that's the biggest challenge facing people who use the product. The current company that owns the product, SAP, is very laid back about supporting the product. It may be helpful to note that the solution does not require a lot of maintenance. We've really got only one or two DBAs looking after it and it is not even a full-time job. If you have a multiplex setup you may require more dedicated DBA staff for maintenance. Once the setup is done correctly, the maintenance comes down to monitoring. There's not a lot of other effort involved in keeping things running.
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.
I do not use SAP IQ's machine learning capabilities. I cannot assess the benefit of SAP IQ's distributed query processing for complex queries, as I am a non-technical operator. I am not sure if we use SAP IQ's data compression features. I think the compression we are doing is on the data storage level and not on the database level. I believe we do not use it, but I'm not certain. We do not utilize SAP IQ's support for unstructured data, as we do not have unstructured data. I do not have any strong opinions on SAP IQ's security features such as data encryption. It's not been something that has been much in focus, neither in our choice of the platform, nor in our daily operations. I guess they're satisfactory as they have not been a problem. I am not aware of the pricing and licensing of SAP IQ, as it's part of a bigger agreement, and I'm not the owner of that agreement. My impression is that SAP IQ is a rather expensive tool in terms of value for money. On a scale of 1-10, I rate SAP IQ a 7.
SAP IQ is an excellent product, and I regret that it is no longer supported. I'd rate the solution nine out of ten.
IQ is an excellent product. I do not understand why SAP does not make it more commercially available or supported. I'd rate the solution nine out of ten.
My organization provides a binary service to test environments. I recommend that others use the tool. Overall, I rate the solution a seven out of ten.
It is not easy for a beginner to learn to use SAP IQ. Overall, I would rate it a seven out of ten because there are still a lot of things to improve.
Overall, I rate the solution a nine out of ten.
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.
In rating the product, I would give it at least an 8 out of ten. The only thing really needed to make it a ten out of ten for us and our usage is better support from the vendor. Well, I say better support but also better vision into the future. I do not think the company is doing sufficient work in development. My advice for other people and companies considering this product as a solution is to find out if you can get proper support. I really think that's the biggest challenge facing people who use the product. The current company that owns the product, SAP, is very laid back about supporting the product. It may be helpful to note that the solution does not require a lot of maintenance. We've really got only one or two DBAs looking after it and it is not even a full-time job. If you have a multiplex setup you may require more dedicated DBA staff for maintenance. Once the setup is done correctly, the maintenance comes down to monitoring. There's not a lot of other effort involved in keeping things running.