Item: SAP IQ
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

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.

Pros and Cons

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

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

SAP IQ is perhaps an under-marketed product in the sense that it is able to scale up very well and perform much faster and more efficiently than other products such as Oracle - when we ran multiple large queries on both Sybase IQ and Oracle, we found that that results were much faster in Sybase IQ and this gave the confidence to go for this product.

Other Software Used

Oracle Advanced Analytics

Likelihood to Recommend

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.

SAP Sybase IQ - versatile for data warehousing

Overall Satisfaction with SAP Sybase IQ