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

Teradata pros and cons

Vendor: Teradata

4.1 out of 5

83 reviews
88% willing to recommend

Pros & Cons summary

Teradata excels in performance and scalability with efficient real-time analytics and high-speed data retrieval through its parallel processing capabilities. Running on Unix and Linux, it ensures data protection. It is expensive compared to alternatives like Redshift. Initial setup is complex, and it has limitations with unstructured data. Improvements in cloud-based capabilities and technical support are needed. Despite cost concerns, it is user-friendly for large-scale management.

Buyer's Guide

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

Prominent pros & cons

PROS

Teradata excels in performance and scalability, effectively handling terabytes of data with speed and resilience.

Its parallel processing features and MPP architecture allow for efficient real-time analytics and high-speed data retrieval.

Teradata reduces operational costs by optimizing ETL processes, offering excellent multi-load capabilities.

The platform provides robust security, running on Unix and Linux, ensuring data protection and stability.

Its seamless integration capabilities and ease of deployment make it reliable and user-friendly for large-scale database management.

CONS

Pricing and cost structure are concerns, with Teradata being expensive compared to alternatives like Redshift, Synapse, and GCP.

The initial setup is complex, with numerous factors and software applications requiring access.

Handling of unstructured and semi-structured data is limited, not allowing for direct loading into its warehouse.

Adoption of cloud technology is relatively late, requiring improvements in cloud-based capabilities.

Technical support response time and the ability to scale efficiently are areas needing enhancement.

Teradata Pros review quotes

EDW Lead at a tech services company with 1,001-5,000 employees

Jun 28, 2015

It's simple to use and scalable.

Read full review

Lead Teradata DBA at a manufacturing company with 10,001+ employees

Aug 13, 2015

Our business processes are much more efficient with Teradata's speed.

Read full review

Teradata Team Leader at a financial services firm with 1,001-5,000 employees

Jun 15, 2017

The two types of partitioning have been very significant for us - row and columnar partitioning.

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: February 2026.

884,873 professionals have used our research since 2012.

Teradata Architect at a tech services company with 501-1,000 employees

Jun 15, 2017

We are into DWBI (Data Warehousing and Business Intelligence) and Teradata is number one in the market for these solutions.

Read full review

Project Manager at a tech services company with 5,001-10,000 employees

Jun 19, 2017

We switched because of TD distributed architecture and it is the best product for EDW.

Read full review

SD

Solution Lead at a tech company with 10,001+ employees

Nov 21, 2017

Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services.

Read full review

Senior IT Business Analyst at a comms service provider with 10,001+ employees

Jun 22, 2017

Viewpoint, the detailed query logs and performance statistics are valuable features.

Read full review

Enterprise Programmes Architect at a logistics company with 10,001+ employees

Jun 22, 2017

It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes.

Read full review

Teradata Consultant at a tech services company with 10,001+ employees

Jun 27, 2017

It architects the databases well, right from data modelling, the correct appliance to be chosen, the queries hitting the system, strategic and tactical, and that business knowledge should be easy to understand to end developers.

Read full review

Professional Services Senior Consultant at a tech services company

Jun 27, 2017

I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable.

Read full review

Show 10 more reviews (out of 72)

Teradata Cons review quotes

EDW Lead at a tech services company with 1,001-5,000 employees

Jun 28, 2015

It's simple but costly.

Read full review

Lead Teradata DBA at a manufacturing company with 10,001+ employees

Aug 13, 2015

I'd like to see better processing on a transactional level and star schema optimization.

Read full review

Teradata Team Leader at a financial services firm with 1,001-5,000 employees

Jun 15, 2017

Data synchronization to the DR site.

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: February 2026.

884,873 professionals have used our research since 2012.

Teradata Architect at a tech services company with 501-1,000 employees

Jun 15, 2017

The Query Response time needs improving.

Read full review

Project Manager at a tech services company with 5,001-10,000 employees

Jun 19, 2017

Concurrency is still a challenge, pricing is still high.

Read full review

SD

Solution Lead at a tech company with 10,001+ employees

Nov 21, 2017

There is some improvement required on OLTP level and some analytical function is missing.

Read full review

Senior IT Business Analyst at a comms service provider with 10,001+ employees

Jun 22, 2017

The SQL Assistant is very basic. This tool can be improved for usability.

Read full review

Enterprise Programmes Architect at a logistics company with 10,001+ employees

Jun 22, 2017

The increasing volumes of data demand more and more performance.

Read full review

Teradata Consultant at a tech services company with 10,001+ employees

Jun 27, 2017

It should be compatible and free on CLOUD/ AWS. Currently many DB's on AWS are free, Teradata is also on Amazon Web Services, but its charged and no documentation available to practice those LABS.

Read full review

Professional Services Senior Consultant at a tech services company

Jun 27, 2017

The cloud is the new challenge and the new opportunity.

Read full review

Show 10 more reviews (out of 72)

Related questions

64

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

29

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

37

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

31

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

37

Is Teradata a difficult solution to work with?

34

What are the main differences between Oracle Exadata and Teradata?

18

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

15

Which solution has better performance: Taradata QueryGrid or Denodo?

70

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

39

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