We performed a comparison between IBM Informix and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution's stability, performance, enhanced functionality, and replication are all great features."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"Replication is a valuable feature and easy to use."
"IBM Informix benefits users with high availability and good integration capabilities."
"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 stability is incredible. I have customers with uptimes of several years."
"It supports multiple applications and business intelligence tools."
"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."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"The solution scales well on the cloud."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"The flexibility in design is very good."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"Teradata's best feature is its speed with historical data."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"I would like to see backups from secondary servers."
"I really would love to have a QT plugin."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"This product could be made easier to use for beginners."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"I experienced poor input/output (IO) performance."
"The solution lacks some functionality."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"Needs compatibility with more Big Data platforms."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Data synchronization to the DR site."
"Teradata can improve the way it handles big data and unstructured data."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata hardly supports unstructured data or semi-structured data"
IBM Informix is ranked 14th in Relational Databases Tools with 16 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. IBM Informix is rated 8.6, while Teradata is rated 8.2. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and Oracle Database In-Memory, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our IBM Informix vs. Teradata report.
See our list of best Relational Databases Tools vendors.
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.