We performed a comparison between IBM Db2 Warehouse and SAP IQ based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"The analytics engine is not bad at forecasting predictions."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"Provides good security and reliability."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Columnar storage allows high compression, high load rates and high query performance."
"Unbeatable speed and compression with a colummn-structured relational database."
"There should be more material available for training and training should be free."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
"IBM Db2 Warehouse needs to improve its interface."
"Lacks sufficient documentation and particularly in Spanish."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"I think the universe should be part of the Sybase IQ tool set."
"Concurrency and functional error messaging."
IBM Db2 Warehouse is ranked 14th in Data Warehouse with 8 reviews while SAP IQ is ranked 16th in Data Warehouse with 17 reviews. IBM Db2 Warehouse is rated 7.6, while SAP IQ is rated 8.0. The top reviewer of IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and IBM Db2 Warehouse on Cloud, whereas SAP IQ is most compared with Snowflake, SAP HANA, SQL Server, SAP BW4HANA and Apache Hadoop. See our IBM Db2 Warehouse vs. SAP IQ report.
See our list of best Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.