SAP IQ Review

I've used other RDBMS's in BI systems like MSSQL and Oracle. ASIQ has the best performance in data retrieval.


Valuable Features

Query Speed, Data Compression, Not restricted schema design, Fast Loading, Zero administration, Easy to learn and use.

Improvements to My Organization

ASIQ offers a query engine where you can design a fully denormalized schema depending on business needs. It has the best performance in data retrieval compared to other database engines and reduces HW cost, achieving up to 70% less storage; Database is smaller than input data, even with all the indexes.

Room for Improvement

Real Time.

Deployment Issues

No.

Stability Issues

No.

Scalability Issues

No – ASIQ has ability to scale by adding CPUs or nodes with no need to re-organize the data.

Customer Service and Technical Support

Customer Service: GoodTechnical Support: Good

Previous Solutions

I have used other traditional RDBMs in Business Intelligence systems like MSSQL and Oracle but the performance was not so good when increasing the data volumes. In order to achieve the ASIQ performance, we had to spent a lot of time configuring properly the database.

Initial Setup

The initial setup was straightforward.

ROI

Excellent

Other Advice

Is the best choice when used as DW data repository because it combines high speed queries and lower TCO.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 Comment
Oracle Web Administrator at a tech services company with 1,001-5,000 employeesReal UserTOP 10

ASIQ offers a query engine where I can design a fully denormalized schema depending on business needs. It has the best performance in data retrieval compared to other database engines and reduces HW cost, achieving up to 70% less storage; Database is smaller than input data, even with all the indexes.

10 July 14
Guest
Sign Up with Email