SAP IQ

SAP IQ

About TrustRadius Scoring
Score 9.9 out of 100
SAP IQ (formerly SAP Sybase IQ)

Overview

Recent Reviews

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SAP IQ, and make your voice heard!

Pricing

View all pricing
N/A
Unavailable

What is SAP IQ?

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

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

3 people want pricing too

Alternatives Pricing

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

What is SingleStore (formerly MemSQL)?

MemSQL is a NoSQL database offering from the company of the same name in San Francisco.

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is SAP IQ?

SAP® IQ software aims to deliver speed and power for extreme-scale enterprise data warehousing and analytics. According to the vendor, its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

SAP IQ Features

  • Supported: Create a unified data store for all data types
  • Supported: Accelerate data loading
  • Supported: Reduce costs and improve performance

SAP IQ Competitors

SAP IQ Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Frequently Asked Questions

What is SAP IQ?

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

Who uses SAP IQ?

The most common users of SAP IQ are from Enterprises (1,001+ employees) and the Financial Services industry.

Reviews and Ratings

 (11)

Ratings

Reviews

(1-3 of 3)
Companies can't remove reviews or game the system. Here's why
Zhann Goloborodko | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
If you are loading massive datasets or aggregating huge relational datasets, SAP IQ is incredible. Loading 10 million rows in seconds is incredibly impressive.
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use this columnar relational database software in the business for the purpose of having a data warehouse and also a data mart that would store business data and enable users to run leverage these for intelligent and informed business decisions on a day to day basis. This is the main database that supports our data warehouse.
  • Superior performance in getting results for query
  • Ability to scale up as data size/volume increase
  • In memory solution and hence enhanced speed
  • 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
Does data compression very well, produces query results very quickly, ability to scale up as data volume/size grow in an organization, row level versioning is in memory and hence the speed. It is a very stable product for large enterprises. More detailed documentation on how to use this product in the initial stages would be really welcome.
Eirik Toft | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We use it to warehouse data to log every customer action and call that flows through our network. It's also referenced for customer billing and is replicated across. We do have a mandated requirement to keep this data available for 7 years.

IQ itself solves the big issue of warehousing large amounts of data.
  • 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.
  • The pricing schedule is a bit expensive and cumbersome.
  • Licensing for a virtual machine is difficult to understand.
It is very well suited for large warehousing applications. It is less suited for databases that need to do computational work.