SAP IQ is a phenomenal relational big data database
November 20, 2019

SAP IQ is a phenomenal relational big data database

Zhann Goloborodko | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SAP IQ (formerly SAP Sybase IQ)

SAP IQ is currently our bid data database. We have several schemas with billions of rows, and both Oracle and Sybase were a bit slower than we liked. Moving our Data to SAP IQ showed a distinct increase in performance when doing bulk inserts and aggregates of data. We only began implementing SAP IQ about a year ago, and in the first six months, we tested it more than used it. For the past six months, we have been using it and are happy with the results.


  • Inserting millions of rows of data takes seconds.
  • Aggregating billions of rows of data is insanely fast (compared to Oracle, Sybase, and SQL Server).


  • Installation, specifically licensing, is a pain.
  • Connectivity is a bit tricky given that the SQL Anywhere drivers aren't native anywhere.
  • Previous reports that took hours to run now execute in minutes, and sometimes seconds.
  • Loads that were taking hours are now taking only a few minutes.
When dealing with row by row inserts, or developing front ends, all three databases above far exceed SAP IQ's performance. It struggles when trying to do individual small transactions.

When doing massive bulk transactions, or extensive queries, SAP IQ outperforms all three by factors greater than 10.
SAP IQ support is top-notch. I prefer starting all my SAP IQ support tickets with their Instant Messenger, where the majority of our issues are resolved. If it makes it to their ticketing system, they are very prompt at responding and very knowledgeable in the platform.

Do you think SAP IQ delivers good value for the price?


Are you happy with SAP IQ's feature set?


Did SAP IQ live up to sales and marketing promises?


Did implementation of SAP IQ go as expected?


Would you buy SAP IQ again?


If you are loading massive datasets or aggregating huge relational datasets, SAP IQ is incredible. Loading 10 million rows in seconds is incredibly impressive.


More Reviews of SAP IQ