Consultant at a tech services company with 51-200 employees
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.
Buyer's Guide
SAP IQ
April 2024
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.
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 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.
Buyer's Guide
Download our free SAP IQ Report and get advice and tips from experienced pros
sharing their opinions.
Updated: April 2024
Popular Comparisons
SQL Server
Snowflake
Oracle Database
MySQL
SAP HANA
Oracle Exadata
IBM Db2 Database
Vertica
Apache Hadoop
SAP BW4HANA
Oracle Database In-Memory
SAP Adaptive Server Enterprise
Snowflake Analytics
IBM Integrated Analytics System
Buyer's Guide
Download our free SAP IQ Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Relational Databases, what aspect do you think is the most important to look for?
- Do general purpose or OLTP Oracle databases really perform better on SPARC based servers?
- Microsoft sql2017 VS SAP Hana
- What is the best database choice for a long term plan?
- SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
- How does NuoDB compare to MySQL and SQL Server?
- Which RDBMS tool do you prefer and why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why is Relational Databases Tools important for companies?
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.