SAP IQ Review

Robust For Ad Hoc DW Queries But Multiplex Has Metadata Consistency Issues

What is most valuable?

It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.

How has it helped my organization?

My organization was using different RDBMs for data warehouse systems. There were obvious problems in terms of performance. Sybase IQ resolved all the performance problems we had at that time.

What needs improvement?

They should improve the backup options. There is no backup software support for Sybase IQ. You have to implement your own backup system. For large databases, you need to use disk backup solutions and it is very expensive.

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.

It is very hard to find which sessions cause a performance problem. It also has no resource manager to manage resources between consumers.

For how long have I used the solution?

Over 15 years.

What do I think about the stability of the solution?

Early versions crashed frequently. Crashes (IQ freezes for no apparent reason and you have to restart it to resolve it) with the latest versions are rare.

What do I think about the scalability of the solution?

Multiplex has some limitations and bugs. Although implementing MPX is easy, I cannot say it results in the expected scalability.

How are customer service and technical support?

Six out of 10.

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

We used a different solution and then we switched to Sybase IQ. Now, because we are having some difficulties in terms of scalability, stability and performance, our DW system is being switched to a new solution again.

How was the initial setup?

Both simplex and multiplex installation are very straightforward.

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

Negotiation is very important.

What other advice do I have?

Data, and getting insight from data, is very important when it comes to competing with your competitors. You have to be fast and agile, in terms of implementing a system and development, in order to get that data insight.

Which version of this solution are you currently using?

15.4 ESD7.1
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More SAP IQ reviews from users
Find out what your peers are saying about SAP, Microsoft, Oracle and others in Relational Databases. Updated: July 2021.
523,230 professionals have used our research since 2012.
Add a Comment
ITCS user