TrustRadius
SAP IQ (formerly SAP Sybase IQ) is a columnar relational database management system (RDBMS) optimized for Big Data analytics.SAP Sybase IQ - versatile for data warehousingWe 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,8,A great database for data warehousing, data mart Ability to run large queries and get results in a quick time frame,Oracle Database,Oracle Advanced AnalyticsIQ is good for us, it'd be good for you too!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.,7,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.,MySQL, Oracle Berkeley DB, Microsoft SQL Server
  3. SAP IQ Reviews
Unspecified
SAP IQ (formerly SAP Sybase IQ)
7 Ratings
Score 8.4 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

SAP IQ Reviews

SAP IQ
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Do you work for this company? Manage this listing

Show Filters 
Hide Filters 
Filter 7 vetted SAP IQ reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Show All Filters
More Filters 
Less Filters 

Reviews (1-2 of 2)

Do you use this product? Write a Review
No photo available
March 22, 2018

SAP Sybase IQ - versatile for data warehousing

Verified User
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 profile photo
December 06, 2017

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

Eirik Toft
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

SAP IQ Scorecard Summary

Likelihood to Recommend (7)
8.4

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