Try our new research platform with insights from 80,000+ expert users

Teradata pros and cons

Vendor: Teradata

4.1 out of 5

77 reviews
87% willing to recommend

Pros & Cons summary

Teradata enhances efficiency with parallel processing and supports diverse deployments, including cloud. It excels in operational reporting and ETL but needs improvement in data synchronization, integration, and Big Data compatibility. Scalability aids data warehousing, though pricing is high. Challenges exist in handling unstructured data, alongside limited training availability compared to Oracle. The architecture's openness requires enhancement to better facilitate integration with other tools and optimize cloud operations.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Teradata's performance in processing Terabytes of data and scalability are key advantages, offering high performance and fast response times compared to other platforms.

The integration tools seamlessly connect with Teradata, enhancing data management efficiency and contributing to fast query performance.

Teradata's parallel processing capabilities improve performance in loading, transformation, processing, and querying, offering cost-effective and efficient solutions for large data tasks.

Teradata can be deployed on-premise, in the cloud, or in a virtual machine, providing flexibility and the ability to upscale easily as needed.

IntelliFlex offers significant scalability improvements, contributing to Teradata's reputation for resilience and stability with consistent uptime and reliability.

CONS

Teradata faces challenges in data synchronization to DR sites and high transaction process performance.

Technical support and initial setup complexities are areas needing improvement for Teradata users.

Teradata's architecture requires enhanced integration with Big Data platforms and better scalability solutions.

Data ingestion relies on external utilities, not being part of Teradata's SQL dialect, limiting convenience.

Compared to competitors, Teradata has high pricing and scalability issues, with a need for better cloud technology adaptation.

Teradata Pros review quotes

reviewer1645335

Director of Product Management at Scala Computing

Oct 8, 2021

The product is reliable.

Read full review

MartinPotgieter

Services Manager at Bytes Systems Integration

Aug 9, 2022

It's very, very fast

Read full review

SurjitChoudhury

Data engineer at Cocos pt

Feb 20, 2024

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.

Read full review

Free Report: Teradata Reviews and More

Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.

868,759 professionals have used our research since 2012.

IT Director at a financial services firm with 1,001-5,000 employees

Jul 26, 2023

The product's scalability is great. Scalability-wise, I rate the solution a ten out of ten.

Read full review

MartinPotgieter

Services Manager at Bytes Systems Integration

Jul 19, 2023

The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier.

Read full review

KA

Solution Sales and Lead Information at TechAccess Asia Distribution

Jun 27, 2021

The flexibility in design is very good.

Read full review

reviewer2036109

Data Engineer III at a media company with 1,001-5,000 employees

Dec 13, 2022

Teradata's pretty fast.

Read full review

Srikanth Madduri

Program Director at Cognizant

Feb 6, 2020

The ease of deployment is useful so clients are up and running quickly in comparison to other products.

Read full review

Director of Data at a leisure / travel company with 1,001-5,000 employees

Dec 11, 2018

It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready.

Read full review

Sr Manager at Cognizant

May 12, 2022

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.

Read full review

Show 10 more reviews (out of 67)

Teradata Cons review quotes

reviewer1645335

Director of Product Management at Scala Computing

Oct 8, 2021

It could be a bit more user-friendly.

Read full review

MartinPotgieter

Services Manager at Bytes Systems Integration

Aug 9, 2022

The setup is not straightforward.

Read full review

SurjitChoudhury

Data engineer at Cocos pt

Feb 20, 2024

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.

Read full review

Free Report: Teradata Reviews and More

Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.

868,759 professionals have used our research since 2012.

IT Director at a financial services firm with 1,001-5,000 employees

Jul 26, 2023

The only issue our company has with Teradata IntelliFlex is that it is not cost-effective because of the way the product has been designed.

Read full review

MartinPotgieter

Services Manager at Bytes Systems Integration

Jul 19, 2023

The cost of Teradata Cloud Data Warehouse has room for improvement.

Read full review

KA

Solution Sales and Lead Information at TechAccess Asia Distribution

Jun 27, 2021

Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve.

Read full review

reviewer2036109

Data Engineer III at a media company with 1,001-5,000 employees

Dec 13, 2022

Teradata is an old data warehouse, and they're not improving in terms of new, innovative features.

Read full review

Srikanth Madduri

Program Director at Cognizant

Feb 6, 2020

There are some ways that the handling of unstructured data could be improved.

Read full review

Director of Data at a leisure / travel company with 1,001-5,000 employees

Dec 11, 2018

I would like more security and speed.

Read full review

Sr Manager at Cognizant

May 12, 2022

Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good.

Read full review

Show 10 more reviews (out of 66)

Related questions

39

Which data catalog can provide support for BI data sources such as SAP BO and Tableau?

13

Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?

26

Comparing Teradata and Oracle Database, which product do you think is better and why?

14

Which companies use Teradata and who is it most suitable for?

23

Is Teradata a difficult solution to work with?

28

What are the main differences between Oracle Exadata and Teradata?

15

Which product do you prefer: Teradata Vantage or Azure Data Factory?

14

Which solution has better performance: Taradata QueryGrid or Denodo?

82

Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza

25

When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?