IBM Integrated Analytics System vs SAP IQ comparison

"With a solid DB2 foundation, it performs incredibly and I recently implemented the new BLU Acceleration, and was dumbfounded that hour-long queries took minutes, in the correct scenario, of course."

"The feature I appreciate the most about SAP IQ is the compression, which is very good; we cannot compare with any other type of EDW."

"Columnar storage allows high compression, high load rates and high query performance."

"The initial setup is easy."

"IQ is a very high-performance and high-transaction database."

"The performance is amazing, but the stability issues, and the expense of the product, coupled with less than top-tier technical support, should be considered when evaluating the product for your specific environment."

"While queries with previous products could run for hours, with SAP IQ, they run in a matter of minutes or seconds."

"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."

"The product is easy to learn."

"The HA - it's a good solution, but I feel IBM should provide the necessary scripts so you can destroy the TSA domain and rebuild it easily."

"Customer Service: It has been good, but more can be done in this area."

"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."

"Aborts happen, and we don't know why."

"There could be more documentation and training."

"With various patches of v15.4 and v16.0, we had instances where the IQ server crashed under certain circumstances."

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

"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."

"The organization who owns the product does not support it well and appears not to be doing significant development for the future."

"The only costs after standard licensing fees are for add-ons and upgrades."

"Negotiation is very important."

"It's not that costly. So, the pricing is cheap."

"The cost of implementation is about $3,000."

"Evaluate all options; check to see if you need expensive add-ons."

"Negotiate based on the features required."