We performed a comparison between IBM Db2 Warehouse on Cloud and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."It will be MPP, so performance should improve."
"The performance is okay as long as the volume of queries is not too high."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger."
"The flexibility in design is very good."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"It is a solid database a lot of different tools to move data."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"The initial setup was straightforward."
"The most valuable feature of Teradata is the quick processing of large data."
"I've never had any issues with scalability."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"The following could be better: licensing, architecture openness, integration with other tools."
"There is some improvement required on OLTP level and some analytical function is missing."
"GUI of administrative tools is really outdated."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"I would like to see an improved Knowledge Base on the web."
"The increasing volumes of data demand more and more performance."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse while Teradata is ranked 3rd in Data Warehouse with 54 reviews. IBM Db2 Warehouse on Cloud is rated 7.6, while Teradata is rated 8.2. The top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". 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 on Cloud is most compared with Amazon Redshift, IBM Netezza Performance Server, IBM Db2 Warehouse, Microsoft Azure Synapse Analytics and Snowflake, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery.
See our list of best Data Warehouse vendors and best Cloud 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.