We performed a comparison between IBM Db2 Database 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's a very mature product."
"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."
"The solution is a very stable relational database and has integration with legacy systems. It is a great product."
"The stability of IBM Db2 Database is stable. We have not faced any downtime in one year. Our work is mostly during business hours and during that time, we haven't faced any downtime."
"It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue."
"The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
"Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them."
"The solution is very stable, in both hardware and database."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"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."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Designing the database is easy."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"Teradata's most valuable feature is that it's easy to use."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"We need some time to improve the performance. We have to perform a weekly REORG, or else RUNSTATS for the databases."
"There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"The initial set up was complex."
"Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced. The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition. In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem."
"The solution could be more modern and have updated database technology."
"IBM Db2 Database could improve in the steps it takes for upgrades. It is not an easy process. The process of upgrading the version is lengthy and requires a lot of time. To make it more efficient, I suggest implementing some automation on the solution side. This will greatly reduce the time required for the upgrade."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"The following could be better: licensing, architecture openness, integration with other tools."
"The solution needs improvement in its stability, support and pricing."
"The cloud is the new challenge and the new opportunity."
"GUI of administrative tools is really outdated."
"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."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Needs compatibility with more Big Data platforms."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 67 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. IBM Db2 Database is rated 8.2, while Teradata is rated 8.2. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". 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 Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, MySQL and Oracle Database In-Memory, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and Amazon Redshift. See our IBM Db2 Database 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.