SAP IQ Review

Query response and data loading times are fast, but we ran into stability issues involved server crashes when attempting to answer legal SQL queries.

What is most valuable?

The speed of the tool - both of the query response and the loading of data.

How has it helped my organization?

It’s the central component of our enterprise data warehouse. Queries and reports that would require hours or days from the original source systems are now available in minutes or seconds. It’s really fast!

What needs improvement?

The stability needs improvement. We’ve upgraded through multiple minor revisions because of issues where the database server would crash when attempting to answer a perfectly legal SQL query.


For how long have I used the solution?

I've been using it for five years.

What was my experience with deployment of the solution?

The client side of the package is a bit monolithic. We'd like to be able to roll out just the ODBC driver to client workstations through our managed desktop solution, but SAP/Sybase apparently doesn't have that capability, so we have to manually visit every workstation and install the complete client package from the DVD image.

What do I think about the stability of the solution?

Just the stability issues referenced above. A production database server should never crash in response to user input, but Sybase IQ has repeatedly done that for us, over multiple revisions of the product.

What do I think about the scalability of the solution?

Not yet. We haven’t had a need to expand our Sybase IQ system yet, but their multiplex architecture seems like a useful approach if/when we need to do so.

How are customer service and technical support?

Customer Service:

We have to go through our systems integrator (Telus).

Technical Support:

Technical support is not good, although we actually have to go through our systems integrator (Telus), not directly to SAP/Sybase. However, the feedback from our systems integrator (Telus), is that the technical support is not great. Their first level help desk at SAP/Sybase is generally of no value for the problems we encounter, and the process of escalation to the appropriate level takes longer than it should.

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

This was our first solution for our enterprise data warehouse project.

How was the initial setup?

The initial setup was complex, because Sybase IQ is architecturally very different from Sybase ASE, which we’ve been using for over 20 years. They share the “Sybase” name, but otherwise are very different products, requiring a different approach to database administration and tuning.

What about the implementation team?

We used our vendor team, whose expertise was acceptable, but not outstanding.

What was our ROI?

We haven't calculated it.

Which other solutions did I evaluate?

Caveat emptor. It’s a frustratingly excellent product. When it works, 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.

Which version of this solution are you currently using?

**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: March 2021.
475,705 professionals have used our research since 2012.
Add a Comment