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.

Pros

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

Cons

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

Yes

Are you happy with SAP IQ's feature set?

Yes

Did SAP IQ live up to sales and marketing promises?

Yes

Did implementation of SAP IQ go as expected?

Yes

Would you buy SAP IQ again?

Yes

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

Comments

More Reviews of SAP IQ