TrustRadius: an HG Insights company

SAP IQ

Score10 out of 10

12 Reviews and Ratings

Get a Demo

What is SAP IQ?

SAP IQ (formerly SAP Sybase IQ) is a columnar relational database management system (RDBMS) optimized for Big Data analytics.

Categories & Use Cases

Reviews

What users are saying about SAP IQ.
View all reviews

SAP IQ is a phenomenal relational big data database

Incentivized
Zhann GoloborodkoView profile
Senior Programmer/Analyst in Information Technology at Investment Company Institute (51-200 employees employees)

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.

Return on Investment

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

Alternatives Considered

SAP Adaptive Server Enterprise, Oracle Database and Microsoft SQL Server

Other Software Used

SAP Adaptive Server Enterprise, Oracle Database, Microsoft SQL Server

IQ is good for us, it'd be good for you too!

Incentivized
Eirik ToftView profile
Systems Administration Spec IV in Information Technology at XO Communications (10,001+ employees employees)

Pros

  • It recovers nicely and with minimal downtime.
  • It works well on the Linux OS.
  • It's easy for our DBA to work with and maintain.

Cons

  • The pricing schedule is a bit expensive and cumbersome.
  • Licensing for a virtual machine is difficult to understand.

Return on Investment

  • The ROI over a number of years has been good. Seeing as how we use it for billing, it has an obvious ROI to us.
  • As they have been modifying their licensing structure, it's been difficult to keep up and understand how they work.

Other Software Used

MySQL, Oracle Berkeley DB, Microsoft SQL Server

SAP Sybase IQ - versatile for data warehousing

Incentivized
Verified User
Executive in Information Technology (1001-5000 employees employees)

Pros

  • Superior performance in getting results for query
  • Ability to scale up as data size/volume increase
  • In memory solution and hence enhanced speed

Cons

  • Initial set up can be more intuitive
  • More documentation to help users who are ramping up on learning curve to get used to this product

Return on Investment

  • A great database for data warehousing, data mart
  • Ability to run large queries and get results in a quick time frame

Alternatives Considered

Oracle Database

Other Software Used

Oracle Advanced Analytics

Related Products

Products similar to SAP IQ that may also meet your needs.
All comparisons
Teradata Vantage
CompareLearn more
Microsoft SQL Server
CompareLearn more
Oracle Database
CompareLearn more