SAP IQ Review

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


What is most valuable?

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

How has it helped 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.

What needs improvement?

Real Time.

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

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

How are customer service and technical support?

Customer Service: GoodTechnical Support: Good

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

The initial setup was straightforward.

What was our ROI?

Excellent

What other advice do I have?

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.
More SAP IQ reviews from users
Add a Comment
Guest
1 Comment

author avatarit_user116742 (Oracle Web Administrator at a tech services company with 1,001-5,000 employees)
Consultant

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.