We performed a comparison between IBM Db2 Warehouse and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Some of the best features are stored procedures, parallelism, and different indexing strategies."
"The analytics engine is not bad at forecasting predictions."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
"Provides good security and reliability."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Designing the database is easy."
"The functionality of the solution is excellent."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"The key advantages are Performance when processing Terabytes of data and scalability."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"The initial setup was straightforward."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"IBM Db2 Warehouse needs to improve its interface."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
"Lacks sufficient documentation and particularly in Spanish."
"There should be more material available for training and training should be free."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"I would like to see more integration with many different types of data."
"Teradata's UI could be improved."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"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's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"The cloud is the new challenge and the new opportunity."
"Teradata is a bit late for the cloud."
IBM Db2 Warehouse is ranked 16th in Data Warehouse with 8 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. IBM Db2 Warehouse is rated 7.6, while Teradata is rated 8.2. The top reviewer of IBM Db2 Warehouse writes "If you have good people designing how the data is stored, this is a marvelous tool". 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 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and Oracle Autonomous Data Warehouse, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our IBM Db2 Warehouse vs. Teradata report.
See our list of best Data Warehouse vendors.
We monitor all Data Warehouse 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.