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

Teradata pros and cons

Vendor: Teradata

4.1 out of 5

76 reviews
87% willing to recommend

7,186 followers

Pros & Cons summary

Teradata supports cost management and delivery through IT optimizations with features like FastLoad and MultiLoad for accelerated data handling. Parallel processing ensures efficient querying, while auto-partitioning optimizes data processing. Flexible deployment options aid customization. However, setup is complex and pricing is high, with limited compatibility for Big Data platforms. Technical support and data synchronization need improvement, making it less ideal for smaller companies seeking cost-effective solutions.

Buyer's Guide

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

Prominent pros & cons

PROS

Teradata supports both row and columnar partitioning, enhancing data management efficiency.

Teradata reduces IT and operations costs, and enhances on-time delivery of products and services.

Features like FastLoad, TPump, and MultiLoad enable quick and efficient data handling and reporting.

Massive parallel processing capabilities allow for large amounts of concurrent querying and data analysis.

The system's architecture and indexing features significantly cut time for processing huge data volumes.

CONS

Data synchronization to the DR site requires improvement.

Teradata lacks compatibility with more Big Data platforms.

The stability and capability to handle large datasets need enhancement.

Teradata's pricing is notably high compared to alternatives.

Issues occur with data ingestion taking excessive time to load.

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: October 2024.

815,854 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 66)

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: October 2024.

815,854 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 65)

Related questions

76

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

17

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

43

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

29

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

36

Is Teradata a difficult solution to work with?

22

What are the main differences between Oracle Exadata and Teradata?

12

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

7

Which solution has better performance: Taradata QueryGrid or Denodo?

255

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

66

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