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."The most valuable feature of this solution is the integration with other IBM products."
"The solution is very stable, in both hardware and database."
"I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary, it's true active-active. We can take one side down and we can upgrade that with new maintenance or a new version, obviously testing coexistence beforehand, without impacting the business."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"The most valuable features of this solution are security and stability."
"The most valuable feature of IBM Db2 Database is its ability to perform automatic self-management, reducing the need for manual tasks such as managing logs and folders."
"IBM Db2 Database has good performance."
"Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"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."
"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."
"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 most valuable features are the Shared-nothing architecture and data protection functionality."
"It has a solid set of tools and consulting services."
"There could be better integration with some cloud solutions."
"The problem with this environment is that any software that you install is very costly because there are no free tools for this environment."
"I would say that the tool has to be made more cloud-friendly and should have agreements with AWS, Microsoft, or Google to run things on hyperscalers."
"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 GUI interface is not particularly friendly for those who do not have experience with the product."
"The initial setup could be improved."
"The backup solution lacks flexibility."
"The price should be lower."
"It needs a teaching web site with more training on third-party tools used for BI."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"It would help to make scaling easier with a reduced cost. "
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"The user interface needs to be improved."
"Data synchronization to the DR site."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 30 reviews while Teradata is ranked 7th in Relational Databases Tools with 21 reviews. IBM Db2 Database is rated 8.2, while Teradata is rated 8.4. The top reviewer of IBM Db2 Database writes "99.99% availability, highly scalable, and capable of supporting half a million transactions per second". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, MySQL and IBM Informix, whereas Teradata is most compared with SQL Server, Snowflake, MySQL, Oracle Exadata and Oracle Database. 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.