SAP IQ Review

The installer is very easy to understand, but the training available needs improvement.

Valuable Features

  • Performance
  • Scalability
  • Ease of deployment
  • Usability
  • Administration

Improvements to My Organization

In the organizations I have worked with, SAP Sybase IQ has been used successfully as a datawarehouse solution and as data store for ad hoc querying. It delivers performance and enormous scalability.

Room for Improvement

Training and marketing are two areas where improvements are needed.

Use of Solution

I've used it for eight years.

Deployment Issues

SAP Sybase IQ is a product which can be deployed very easily on commodity hardware.

Stability Issues

Not really. In normal functioning SAP Sybase IQ is extremely stable.

Scalability Issues

No. I have seen deployments of datawarehouses with tens of TB's in used space and they scaled very easily to multiple applications.

Customer Service and Technical Support

Customer Service:

It has been good, but more can be done in this area.

Technical Support:

It's good, 7/10.

Initial Setup

It's straightforward in the hands of a junior level DBA. The installer is very easy to understand as long as the user has a understanding of architecture and layout of the database server.

Implementation Team

It's been in-house.

Pricing, Setup Cost and Licensing

Understand your requirements well in terms of performance, backup, and space requirements before picking the number of licenses. If IQ is being used in a virtual environment then probably a good understanding of licensing options in a virtual environment is needed. Recently SAP has introduced some new license options, but new users should review those options with the sales team.

Other Advice

Estimate the storage requirements, performance requirements, and the number of users during the planning phase. Review the documentation related to hardware sizing and best practices available on the SAP website. There is a hardware estimation guide too which helps in estimating the hardware requirements. Lastly, review the multiplexing option too and understand the implication of columnar storage in a database server.

Which version of this solution are you currently using?

16.0 sp08
**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: June 2021.
510,534 professionals have used our research since 2012.
Add a Comment