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."
"It supports multiple applications and business intelligence tools."
"The initial setup is pretty easy."
"The scalability is very good."
"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."
"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."
"It supports in-house-built applications in .NET and VB6"
"Replication is a valuable feature and easy to use."
"The functionality of the solution is excellent."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"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."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The initial setup was straightforward."
"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."
"The solution really doesn't add new features very often."
"This product could be made easier to use for beginners."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"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."
"The solution lacks some functionality."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"Limited interest and success in some areas make us hesitate about upgrading."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"Teradata's UI could be improved."
"The scalability could be better. The on-premises solution is always more complicated to scale."
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.