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."It supports in-house-built applications in .NET and VB6"
"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."
"The stability is incredible. I have customers with uptimes of several years."
"The scalability is very good."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"Every version is faster than the previous."
"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."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"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."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"Teradata's pretty fast."
"Cuts time to process huge amounts of data with efficient analytical queries."
"I've never had any issues with scalability."
"This solution is in need of more current tools."
"The pricing is a bit expensive."
"I experienced poor input/output (IO) performance."
"The technical support services need substantial improvement."
"The solution lacks some functionality."
"This product could be made easier to use for beginners."
"I would like to see backups from secondary servers."
"The solution really doesn't add new features very often."
"Needs compatibility with more Big Data platforms."
"Teradata's UI could be improved."
"Teradata can improve the way it handles big data and unstructured data."
"It could use some more advanced analytics relating to structured and semi-structured data."
"The user interface needs to be improved."
"The SQL Assistant is very basic. This tool can be improved for usability."
"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."
"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."
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.