We performed a comparison between IBM Informix and IBM Netezza Performance Server based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."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."
"The initial setup is pretty easy."
"It supports multiple applications and business intelligence tools."
"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."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"The scalability is very good."
"IBM Informix benefits users with high availability and good integration capabilities."
"So far, we do not have a lot of issues. It's pretty problem-free."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"IBM Netezza Performance Server is a cost-effective solution."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"Distribution concurrency control."
"The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product."
"We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"I would like to see backups from secondary servers."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"This solution is in need of more current tools."
"The technical support services need substantial improvement."
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all."
"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."
"Concurrency limit needs to be increased somewhat."
"The only issue is that it's not expandable."
"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."
"The scalability is not as expected. The capacity in the black box is not enough."
More IBM Netezza Performance Server Pricing and Cost Advice →
IBM Informix is ranked 6th in Embedded Database with 16 reviews while IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews. IBM Informix is rated 8.6, while IBM Netezza Performance Server is rated 8.0. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Snowflake, Teradata and SQL Server.
We monitor all Embedded Database 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.