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."Every version is faster than the previous."
"The scalability is very good."
"The initial setup is pretty easy."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"Replication is a valuable feature and easy to use."
"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."
"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 two types of partitioning have been very significant for us - row and columnar partitioning."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The solution really doesn't add new features very often."
"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."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"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."
"I would like to see backups from secondary servers."
"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."
"I would like to see more integration with many different types of data."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata is a bit late for the cloud."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Teradata's UI could be improved."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
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 and MySQL, 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.