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."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."
"It will be MPP, so performance should improve."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"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."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"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."
"It is a stable program."
"Teradata's best feature is its speed with historical data."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"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."
"The solution needs improvement in its stability, support and pricing."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"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."
"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."
"Limited interest and success in some areas make us hesitate about upgrading."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"Data synchronization to the DR site."
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 Db2 Warehouse, IBM Netezza Performance Server, 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.