No more typing reviews! Try our Samantha, our new voice AI agent.

IBM Informix vs SAP IQ comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 4, 2025

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 Informix
Ranking in Relational Databases Tools
28th
Average Rating
8.2
Reviews Sentiment
7.5
Number of Reviews
17
Ranking in other categories
Embedded Database (9th)
SAP IQ
Ranking in Relational Databases Tools
25th
Average Rating
7.8
Reviews Sentiment
6.6
Number of Reviews
22
Ranking in other categories
Data Warehouse (15th)
 

Mindshare comparison

As of November 2026, in the Relational Databases Tools category, the mindshare of IBM Informix is 1.9%, up from 1.8% compared to the previous year. The mindshare of SAP IQ is 2.4%, up from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools Mindshare Distribution
ProductMindshare (%)
SAP IQ2.4%
IBM Informix1.9%
Other95.7%
Relational Databases Tools
 

Featured Reviews

Nasir Niamat - PeerSpot reviewer
DB Consultant at i2c
Has offered a cost-effective option despite frequent technical issues and limited market demand
We find some bugs in IBM Informix. Maybe we are using it more aggressively than others. Every month or every second month, we find some bugs in it, which is not ideal. It should be rare, not this frequent. The good thing is they cover those bugs in the next release within weeks or days on demand. IBM Informix should become hybrid and should include AI features similar to other DBMS systems such as Snowflake, Redshift, and DataBricks. This would help its value rise with the market.
KK
Tech Director at a computer software company with 1,001-5,000 employees
Works well with existing platform integration but could improve error messaging and technical support
I do not use SAP IQ's machine learning capabilities. I cannot assess the benefit of SAP IQ's distributed query processing for complex queries, as I am a non-technical operator. I am not sure if we use SAP IQ's data compression features. I think the compression we are doing is on the data storage level and not on the database level. I believe we do not use it, but I'm not certain. We do not utilize SAP IQ's support for unstructured data, as we do not have unstructured data. I do not have any strong opinions on SAP IQ's security features such as data encryption. It's not been something that has been much in focus, neither in our choice of the platform, nor in our daily operations. I guess they're satisfactory as they have not been a problem. I am not aware of the pricing and licensing of SAP IQ, as it's part of a bigger agreement, and I'm not the owner of that agreement. My impression is that SAP IQ is a rather expensive tool in terms of value for money. On a scale of 1-10, I rate SAP IQ a 7.

Quotes from Members

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

Pros

"My advice is to take it; you will never regret it."
"The solution is quite stable and reliable; we use it mainly due to its general stable nature."
"We don't have any problems with the Informix Database."
"The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle."
"It is very easy to install IBM Informix, very easy to scale, and support is quite better."
"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."
"Every version is faster than the previous."
"We can now have over one billion rows in a table for semi-real trans-national querying."
"IQ has enabled our company to load data from our data vendors in under one hour and eliminated multiple copies and hours of processing time."
"IQ is a very high-performance and high-transaction database."
"Columnar storage allows high compression, high load rates and high query performance."
"The initial setup is easy."
"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."
"SAP IQ is actually quite effective when it comes to scalability; we have a setup that's built with multiple servers involved and that seems to be working fairly efficiently, and if we wanted to add more servers into this entire setup, that would be fairly easy."
"While queries with previous products could run for hours, with SAP IQ, they run in a matter of minutes or seconds."
 

Cons

"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"The pricing is a bit expensive."
"For me, it's always too expensive. The problem is that Informix sometimes competes with free products, so yes, it's very expensive, but when we're talking about licensed products like SQL Server or anything, the midsize pricing could be significantly improved."
"The solution should offer replication. It would be helpful if the solution would allow us to access third-party tools."
"The product needs a lot more marketing involvement from IBM."
"This product could be made easier to use for beginners."
"The solution really doesn't add new features very often. Other solutions are much more actively pushing out upgrades and improvements."
"This solution is in need of more current tools."
"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."
"It's too complex. This is concerning something that will change immediately."
"Very few people are familiar with this technology, as training programs are very expensive."
"Customer Service: It has been good, but more can be done in this area."
"A production database server should never crash in response to user input, but Sybase IQ has repeatedly done that for us, over multiple revisions of the product."
"Technical Support: 6/10 because at the time I was using it, Sybase Turkey were short on staff and not very experienced."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"There is very little documentation available."
 

Pricing and Cost Advice

"The product has reasonable pricing. We purchase its yearly license."
"I am not aware of the licensing costs or terms."
"For me, it's always too expensive."
"The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
"Negotiation is very important."
"It's not that costly. So, the pricing is cheap."
"The cost of implementation is about $3,000."
"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."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
922,349 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Comms Service Provider
12%
Construction Company
11%
Outsourcing Company
9%
Manufacturing Company
8%
Financial Services Firm
22%
Outsourcing Company
13%
Comms Service Provider
11%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise2
Large Enterprise8
By reviewers
Company SizeCount
Small Business6
Midsize Enterprise2
Large Enterprise16
 

Questions from the Community

What is your experience regarding pricing and costs for IBM Informix?
There is a cost reason to move from IBM Informix. It is relatively cheaper than Oracle. The second reason is that moving the whole application to a new database would require significant cost. The ...
What needs improvement with IBM Informix?
We find some bugs in IBM Informix. Maybe we are using it more aggressively than others. Every month or every second month, we find some bugs in it, which is not ideal. It should be rare, not this f...
What is your primary use case for IBM Informix?
We are using IBM Informix for OLTP systems. We are using IBM Informix although it is a technology that is not very popular compared to others. We are using it because our application was initially ...
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.
What needs improvement with SAP IQ?
When it comes to SAP IQ, the areas that could be improved or enhanced include the error messaging and the locking capabilities, as that's where we often encounter problems. When there is an iss...
What is your primary use case for SAP IQ?
Our usual use cases for SAP IQ is that we have a Software-as-a-Service architecture where this database is the foundation for our SAP BusinessObjects platform. This is where it's getting its da...
 

Comparisons

 

Also Known As

Informix
Sybase IQ
 

Overview

 

Sample Customers

Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Find out what your peers are saying about IBM Informix vs. SAP IQ and other solutions. Updated: November 2026.
922,349 professionals have used our research since 2012.