Amazon Redshift vs Teradata comparison

Read 76 Teradata reviews

4,989 Views
3,819 Comparison Views

87% willing to recommend

Amazon Redshift

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 12, 2025

Teradata and Amazon Redshift are prominent players in the data warehousing category, each offering unique advantages. While both excel in high-volume data handling, Redshift holds a slight edge due to its superior cloud integration within the AWS ecosystem.

Features: Teradata is distinguished by its shared-nothing architecture and query optimization capabilities, facilitating efficient partitioning and parallel processing for complex workloads. Its robust security features and workload management stand out. Amazon Redshift is noted for its seamless AWS integration, efficient analytical capabilities, and cloud-based scalability, offering flexible and cost-effective solutions.

Room for Improvement: Teradata's primary concerns include high pricing and challenges in handling unstructured data, as well as scalability issues in cloud environments. Redshift requires enhancements in snapshot restoring and real-time data integration performance. Users desire better support for unstructured data in both solutions.

Ease of Deployment and Customer Service: Teradata provides deployment options across on-premises, private cloud, and hybrid setups, though cloud integration could be improved. It offers strong technical support but response times need enhancement. Amazon Redshift offers easy cloud deployment with effective support, valued for its seamless AWS operation, though broader cloud interoperability support is desired.

Pricing and ROI: Teradata is perceived as costly, yet offers high performance and comprehensive features with positive ROI for large-scale operations. Its evolving pricing models are improving flexibility. Amazon Redshift is known for competitive pricing, particularly in the cloud, praised for its affordability with a pay-as-you-use model, making it manageable for diverse business needs. However, cost remains a concern for smaller organizations.

To learn more, read our detailed Amazon Redshift vs. Teradata Report (Updated: February 2025).

Amazon Redshift vs. Teradata

February 2025

Download the complete report

Helped 838,640 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Amazon Redshift

Ranking in Cloud Data Warehouse

5th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

Teradata

Ranking in Cloud Data Warehouse

6th

Average Rating

8.2

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Customer Experience Management (4th), Backup and Recovery (20th), Data Integration (16th), Relational Databases Tools (7th), Data Warehouse (3rd), BI (Business Intelligence) Tools (10th), Marketing Management (6th)

Mindshare comparison

As of February 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 6.8%, down from 9.7% compared to the previous year. The mindshare of Teradata is 9.0%, down from 9.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

Featured Reviews

Ved Prakash Yadav

Senior Data Platform Manager at a manufacturing company with 10,001+ employees

Works as a data warehouse system and collects data from different sources

In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.

Read full review

SurjitChoudhury

Data engineer at Cocos pt

Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities

We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted. It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor. Moreover, this solution has impacted the query time and data performance. In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes. To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index. This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance. 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. But, these technologies are quite old now. With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The ability to reload data multiple times at different times."

"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."

"It's scalable because it's on the cloud."

"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."

"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."

"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."

"I have primarily used the Redshift Spectrum feature and found it most valuable."

"You can copy JSON to the column and have it analyzed using simple functions."

More Amazon Redshift pros

"The most valuable feature of Teradata is the quick processing of large data."

"Auto-partitioning and indexing, and resource allocation on the fly are key features."

"It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years."

"The most valuable feature is the ease of uploading data from multiple sources."

"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 data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems."

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

"It has a solid set of tools and consulting services."

More Teradata pros

Cons

"I would like to improve the pricing and the simplicity of using this solution."

"The product could be improved by making it more flexible."

"The speed of the solution and its portability needs improvement."

"Amazon Redshift does not have the capability to dynamically increase the VM file."

"Planting is the primary key enforcement that should be improved."

"The initial deployment was complex."

"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."

"It would be good to see Redshift as a serverless offering."

More Amazon Redshift cons

"Teradata is a bit late for the cloud."

"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."

"I'm not sure about the unstructured data management capabilities. It could be improved."

"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."

"Their level of technical support is adequate. It could be better."

"GUI of administrative tools is really outdated."

"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."

"I would like to see an improved Knowledge Base on the web."

More Teradata cons

Pricing and Cost Advice

"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."

"The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term."

"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."

"The best part about this solution is the cost."

"It's pay per use. You can have multiple models."

"The solution has very competitive pricing."

"The pricing is reasonable."

"For Amazon Redshift, we pay around INR 60,000 annually. The cost factor also depends on the number of existing customers."

More Amazon Redshift pricing and cost advice

"Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."

"Teradata is not cheap, but you get what you pay for."

"It's a very expensive product."

"Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world."

"Users have to pay a yearly licensing fee for Teradata IntelliFlex, which is very expensive."

"The solution requires a license."

"The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space."

"The tool costs about 30,000 euros a month, while Azure Synapse SQL only costs 10,000."

More Teradata pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

838,640 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

Aug 5, 2015

Netezza vs. Teradata

Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…

Read full review

Top Industries

By visitors reading reviews

Educational Organization

64%

Financial Services Firm

Computer Software Company

Manufacturing Company

Financial Services Firm

27%

Computer Software Company

10%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...

What do you like most about Amazon Redshift?

The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.

What is your experience regarding pricing and costs for Amazon Redshift?

I have no idea about pricing.

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

I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may declare Teradata better than Oracle is the pricing. Both solutions are quite simi...

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

Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if it would be compatible with our field. According to the product's site, the comp...

Is Teradata a difficult solution to work with?

Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if you just ask. There are some features that may cause difficulties - for example,...

Snowflake vs Amazon Redshift

Comparisons

Compared 11% of the time

Oracle Exadata vs Amazon Redshift

Compared 10% of the time

AWS Lake Formation vs Amazon Redshift

Compared 10% of the time

Vertica vs Amazon Redshift

Compared 10% of the time

Microsoft Azure Synapse Analytics vs Amazon Redshift

Compared 7% of the time

More Amazon Redshift Competitors

Oracle Exadata vs Teradata

Compared 14% of the time

SQL Server vs Teradata

Compared 11% of the time

MySQL vs Teradata

Compared 8% of the time

Snowflake vs Teradata

Compared 7% of the time

BigQuery vs Teradata

Compared 4% of the time

More Teradata Competitors

Product Reports

Download Amazon Redshift product report

Amazon Redshift

February 2025

Download Teradata product report

January 2025

Also Known As

No data available

IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture

Overview

What is Amazon Redshift?

Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.

Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.

The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.

Amazon Redshift Functionalities

Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:

Cluster administration: The Amazon Redshift cluster is a group of nodes that contains a leader node and one (or more) compute node(s). The compute nodes needed are dependent on the data size, amount of queries needed, and the query execution functionality desired.
Cluster snapshots: Snapshots are backups of a cluster from an exact point in time. Amazon Redshift offers two types of snapshots: manual and automated. Amazon will store these snapshots internally in the Amazon Simple Storage Service (Amazon S3) utilizing an SSL connection. Whenever a Snapshot restore is needed, Amazon Redshift will create a new cluster and will import data from the snapshot as directed.
Cluster access: Amazon Redshift provides several intuitive features to help define connectivity rules, encrypt data and connections, and control the overall access of your cluster.
IAM credentials and AWS accounts: The Amazon Redshift cluster is only accessible by the AWS account that created the cluster. This automatically secures the cluster and keeps it safe. Inside the AWS account, users access the AWS Identity and IAM protocol to create additional user accounts and manage permissions, granting specified users the desired access needed to control cluster performance.
Encryption: Users have the option to choose to encrypt the clusters for additional added security once the cluster is provisioned. When encryption is enabled, Amazon Redshift will store all the data in user-created tables in a secure encrypted format. To manage Amazon Redshift encryption keys, users will access AWS Key Management Service (AWS KMS).

Reviews from Real Users

“Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS

“With the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini

Amazon Web Services (AWS)

Teradata is a scalable data analytics platform designed to meet enterprise demands for large-scale data management and processing, focusing on performance, scalability, and security for complex query executions.

As a leading data warehousing solution, Teradata integrates advanced analytics enabling organizations to derive insights from massive datasets. It supports high-volume data workloads with its architecture optimized for analytical queries. Users benefit from its robust scalability, allowing seamless expansion as data grows. Teradata's SQL engine is compatible with a wide range of data types, ensuring flexibility in data analysis. With advanced security measures, it protects sensitive data across various environments, providing peace of mind to users handling critical information.

What are the most important features of Teradata?

Linear Scalability: Easily expands data processing capabilities to handle increasing data loads without performance degradation.
Advanced Analytics: Supports complex analytical operations integrating machine learning and AI for predictive insights.
SQL Compatibility: Offers a comprehensive SQL interface that supports complex queries across diverse data types.
Data Security: Implements rigorous security protocols to protect data integrity and confidentiality.

What benefits and ROI should users look for?

Improved Decision-Making: Derive actionable insights quickly for strategic business decisions.
Cost Efficiency: Optimized resource usage reduces operational costs associated with data processing.
Increased Productivity: Streamlined data operations save time, allowing teams to focus on analysis.
Enhanced Scalability: Seamless growth without significant additional investment as data volumes increase.

Teradata is widely used in industries like finance, telecommunications, and healthcare, where data-driven decisions are critical. Companies leverage its robust analytics capabilities to enhance customer experiences, streamline operations, and ensure compliance with regulatory requirements. In these sectors, quick access to data insights can significantly impact competitive advantage.

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

Netflix