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.


What is most valuable?

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

How has it helped 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.

What needs improvement?

  • Admin UI
  • Tuning parameters
  • Maintenance tool
  • UI

For how long have I used the solution?

I've used it for over five years.

What was my experience with deployment of the solution?

There weren't many issues.

What do I think about the stability of the solution?

Aborts happen, and we don't know why.

What do I think about the scalability of the solution?

There aren't many issues.

How are customer service and technical support?

Customer Service:

5/10.

Technical Support:

5/10.

Which solution did I use previously and why did I switch?

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

How was the initial setup?

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

What about the implementation team?

We implemented with a vendor who were 6/10.

What was our ROI?

It's at about 60%.

What's my experience with pricing, setup cost, and licensing?

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

Which other solutions did I evaluate?

  • Oracle
  • PostgreSQL

What other advice do I have?

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