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.
Snr DBA at a insurance company with 1,001-5,000 employees
Real User
2019-07-29T10:11:00Z
Jul 29, 2019
Actually, it is not the product that needs revision but the company itself. Sybase IQ was bought by SAP. They use it, but they don't really advertise and push it correctly. So SAP IQ — from a company standpoint — is not really supported correctly. If they did more to support the product, it would be a more popular solution. SAP IQ has not introduced more integration with Hadoop so the two products would act in a more tightly coupled way. This would be one of the more important features that they might add. The integration with Hadoop is important because it seems everybody is going towards Hadoop for big data. You also need a system that works well. Hadoop is fast, but SAP IQ is even faster. They each have advantages, so if you can combine them, that would be good. It will work out better for cost and extra storage.
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.
The only negative aspect of IQ is the cost, which can be challenging for companies in Peru.
The tool gets stuck sometimes. The databases freeze suddenly during testing.
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.
The product should add more business intelligence factors.
The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better.
Actually, it is not the product that needs revision but the company itself. Sybase IQ was bought by SAP. They use it, but they don't really advertise and push it correctly. So SAP IQ — from a company standpoint — is not really supported correctly. If they did more to support the product, it would be a more popular solution. SAP IQ has not introduced more integration with Hadoop so the two products would act in a more tightly coupled way. This would be one of the more important features that they might add. The integration with Hadoop is important because it seems everybody is going towards Hadoop for big data. You also need a system that works well. Hadoop is fast, but SAP IQ is even faster. They each have advantages, so if you can combine them, that would be good. It will work out better for cost and extra storage.