SAP IQ and IBM Db2 compete in the business intelligence and data warehousing domain. SAP IQ seems to have the upper hand in query performance and data compression, while IBM Db2 is superior in platform support and transaction management.
Features: SAP IQ's columnar database design enables high compression and quick query performance, optimizing storage and offering scalability. It excels in high-speed data loading. IBM Db2 is recognized for advanced SQL capabilities, broad platform support, and robust transaction management, along with autonomic features that optimize performance without manual intervention.
Room for Improvement: SAP IQ needs enhanced backup options, better integration with technologies like Hadoop, and improved support as experienced resources are limited. Its marketing efforts require strengthening. IBM Db2 could benefit from user interface updates, improved cloud readiness, and simplified licensing and performance monitoring tools.
Ease of Deployment and Customer Service: SAP IQ is primarily an on-premises solution and lacks cloud integration flexibility, whereas IBM Db2 supports hybrid and private clouds, offering broader deployment options. SAP IQ's customer service needs improvement, in contrast to IBM Db2, which receives positive feedback for global support and efficient problem resolution.
Pricing and ROI: SAP IQ is cost-effective but has a complex pricing structure that requires careful evaluation. IBM Db2, though pricier than some competitors like Oracle and Microsoft SQL Server, offers comprehensive features that can deliver good value, especially when integrated with IBM hardware. Additionally, IBM’s pricing and support structures are perceived as complex, emphasizing the importance of negotiations.
We normally receive substantial discounts on the price.
It seems very difficult to get proper advanced assistance on advanced or complicated problems.
The quality of support from SAP is very good; if it's a known problem, they will have a knowledge base, so we will get immediate assistance.
We can span the read and write load into multiple nodes, and that scalability is there.
If we wanted to add more servers into this entire setup, that would be fairly easy, so it's rather good when it comes to scalability.
It's usually something external, such as lack of disk space or problems arising from the integration to other systems.
It might be slightly slower than other database vendors, but it works well since banks typically do not move quickly with leading-edge technology.
If the CPU utilization is very high, there is no direct way we can find out which query is taking the most CPU.
When there is an issue, the error messaging we get is not always sufficient to do a fast and solid fix.
IBM Db2 Database, because of enterprise performance and support, is why banks still maintain their relationship with it.
The IBM Db2 Database is trusted, and IT effort is less than any other product.
We can get historical data quickly, and you can fetch information very quickly because every column is indexed.
The most valuable feature of SAP IQ for us is that it works very effectively with the SAP BusinessObjects which we use it with.
| Product | Market Share (%) |
|---|---|
| IBM Db2 Database | 7.6% |
| SAP IQ | 1.1% |
| Other | 91.3% |
| Company Size | Count |
|---|---|
| Small Business | 20 |
| Midsize Enterprise | 13 |
| Large Enterprise | 48 |
| Company Size | Count |
|---|---|
| Small Business | 7 |
| Midsize Enterprise | 2 |
| Large Enterprise | 15 |
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.
We monitor all Relational Databases Tools 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.
