SAP IQ Review

We can now have over one billion rows in a table for semi-real trans-national querying., but the admin UI could use some improvements.


Valuable Features

  • Data compression ratio
  • Mass query speed

Sybase IQ, it's high compressed ratio and large query are attractive. In data warehouse experience that is a good tool and normal C/P.

Improvements to My Organization

We can now have over one billion rows in a table for semi-real trans-national querying. In quarterly or monthly report from billions of records, it supports and provides, stable performance.

Room for Improvement

  • Admin UI
  • Tuning parameters
  • Maintenance tool
  • UI

Use of Solution

I've used it for over five years.

Deployment Issues

There weren't many issues.

Stability Issues

Aborts happen, and we don't know why.

Scalability Issues

There aren't many issues.

Customer Service and Technical Support

Customer Service:

5/10.

Technical Support:

5/10.

Previous Solutions

We also have an Oracle solution, and these it runs in parallel with Sybase IQ.

Initial Setup

We set it up in multi node mode, and it wasn't too complex.

Implementation Team

We implemented with a vendor who were 6/10.

ROI

It's at about 60%.

Pricing, Setup Cost and Licensing

They should simplify the classification of licenses, especially the core/store number.

Other Solutions Considered

  • Oracle
  • PostgreSQL

Other Advice

Take into consideration your multiplex environment and storage IOPS balance.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email