IBM Db2 Warehouse on Cloud vs SAP IQ comparison

IBM and SAP are both solutions in the Data Warehouse category. Additionally, 85% of IBM users are willing to recommend the solution, compared to 84% of SAP users who would recommend it.

IBM Db2 Warehouse on Cloud

Read 7 IBM Db2 Warehouse on Cloud reviews

145 Views
113 Comparison Views

85% willing to recommend

SAP IQ

Read 21 SAP IQ reviews

513 Views
370 Comparison Views

84% willing to recommend

IBM Db2 Warehouse on Cloud

SAP IQ

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM Db2 Warehouse on Cloud 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.

To learn more, read our detailed IBM Db2 Warehouse on Cloud vs. SAP IQ Report (Updated: April 2025).

Buyer's Guide

IBM Db2 Warehouse on Cloud vs. SAP IQ

April 2025

Download the complete report

Helped 845,877 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

IBM Db2 Warehouse on Cloud

Average Rating

7.6

Reviews Sentiment

6.3

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (16th)

SAP IQ

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Relational Databases Tools (26th), Data Warehouse (13th)

Featured Reviews

FarhanFarhan

Database Engineer at Meezan Bank

Enhancing analytics with seamless data dumping and reliable support

Our primary use case is data storage and analytics The organization has decided to purchase a full stack solution from IBM due to positive responses, which helped them upgrade from the previous version. The data dumping into the raw zone and the feature of BigQuery is quite attractive. There…

Read full review

Tejas Raj

Manager at Capgemini

Columnar database, so pulling records is easy but there isn't enough documentation for installation

I've seen very few SAP IQ systems in recent years. So people are moving away from SAP IQ In the last three years, I've rarely encountered customers using it. Fewer systems with SAP IQ usage among our customers. Most of them have moved on to HANA. There are parallel products, and there are also viable alternatives from AWS, so many have migrated to those.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger."

"The performance is okay as long as the volume of queries is not too high."

"It is stable when there is support from IBM."

"It will be MPP, so performance should improve."

"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."

"Columnar storage allows high compression, high load rates and high query performance."

"The product is easy to learn."

"All data is compressed and indexed, allowing for fast execution of transactions."

"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."

"The initial setup is easy."

"IQ is a very high-performance and high-transaction database."

"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."

More SAP IQ pros

Cons

"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."

"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."

"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."

"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."

"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."

"The tool gets stuck sometimes."

"Concurrency and functional error messaging."

"There is very little documentation available."

"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."

"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."

"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."

"The room for improvement would be the marketing of the product, because this product is much better than advertised."

More SAP IQ cons

Pricing and Cost Advice

"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."

"The cost of implementation is about $3,000."

"Negotiation is very important."

"It's not that costly. So, the pricing is cheap."

"Evaluate all options; check to see if you need expensive add-ons."

"The only costs after standard licensing fees are for add-ons and upgrades."

"Negotiate based on the features required."

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

845,877 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

44%

Computer Software Company

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What advice do you have for others considering IBM Db2 Warehouse on Cloud?

Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that can help administrators maximize the efficiency of their data-based operatio...

See all answers

What needs improvement with IBM Db2 Warehouse on Cloud?

There are some limitations in adding data files to table spaces, and improvements are needed for regional support.

See all answers

What is your primary use case for IBM Db2 Warehouse on Cloud?

Our primary use case is data storage and analytics.

See all answers

What is your experience regarding pricing and costs for SAP IQ?

IQ implementation costs about three thousand dollars. It's less expensive compared to alternatives like Teradata Base in terms of transactional efficiency.

See all answers

What needs improvement with SAP IQ?

The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru.

See all answers

What is your primary use case for SAP IQ?

I worked on implementing new databases, migration data in production, and developer environments with SAP IQ.

See all answers

Comparisons

Oracle Exadata vs IBM Db2 Warehouse on Cloud

Compared 38% of the time

IBM Netezza Performance Server vs IBM Db2 Warehouse on Cloud

Compared 31% of the time

Amazon Redshift vs IBM Db2 Warehouse on Cloud

Compared 31% of the time

More IBM Db2 Warehouse on Cloud Competitors

Snowflake vs SAP IQ

Compared 32% of the time

SAP HANA vs SAP IQ

Compared 15% of the time

SQL Server vs SAP IQ

Compared 12% of the time

Apache Hadoop vs SAP IQ

Compared 12% of the time

SAP BW4HANA vs SAP IQ

Compared 9% of the time

More SAP IQ Competitors

Product Reports

Buyer's Guide

Cloud Data Warehouse

March 2025

Download IBM Db2 Warehouse on Cloud product report

Buyer's Guide

SAP IQ

March 2025

Download SAP IQ product report

Also Known As

IBM dashDB

Sybase IQ

Overview

IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.

IBM

SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

SAP

Sample Customers

Copenhagen Business School, BPM Northwest, GameStop

ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.

Buyer's Guide

IBM Db2 Warehouse on Cloud vs. SAP IQ

April 2025

Free Report: IBM Db2 Warehouse on Cloud vs. SAP IQ

Find out what your peers are saying about IBM Db2 Warehouse on Cloud vs. SAP IQ and other solutions. Updated: April 2025.

DOWNLOAD NOW

845,877 professionals have used our research since 2012.

See our IBM Db2 Warehouse on Cloud vs. SAP IQ report.

See our list of best Data Warehouse vendors and best Cloud 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.