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."The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"Provides good security and reliability."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"The analytics engine is not bad at forecasting predictions."
"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."
"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."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The performance is great, we are able to query our data in one operation."
"Improved performance of ETL procedures, reporting."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"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."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"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."
"Lacks sufficient documentation and particularly in Spanish."
"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."
"IBM Db2 Warehouse needs to improve its interface."
"There should be more material available for training and training should be free."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"Needs compatibility with more Big Data platforms."
"The current operational approach needs improvement."
"It needs a teaching web site with more training on third-party tools used for BI."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
IBM Db2 Warehouse is ranked 13th 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 "Useful for ETL process and has good documentation ". 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 IBM Db2 Warehouse on Cloud, 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.