SAP IQ Reviews

9 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-3 of 3)

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.
Read Zhann Goloborodko's full review
Anonymous | TrustRadius Reviewer
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.
Read this authenticated review
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.
Read Eirik Toft's full review

About 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.
Categories:  Relational Databases

SAP IQ Features

Has featureCreate a unified data store for all data types
Has featureAccelerate data loading
Has featureReduce costs and improve performance

SAP IQ Competitors

SAP IQ Technical Details

Operating Systems: Unspecified
Mobile Application:No