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

Amazon Redshift vs Netezza Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

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
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
Cloud Data Warehouse (6th)
Netezza Analytics
Average Rating
7.4
Number of Reviews
11
Ranking in other categories
Hadoop (8th)
 

Mindshare comparison

Amazon Redshift and Netezza Analytics aren’t in the same category and serve different purposes. Amazon Redshift is designed for Cloud Data Warehouse and holds a mindshare of 7.4%, down 8.5% compared to last year.
Netezza Analytics, on the other hand, focuses on Hadoop, holds 1.5% mindshare, up 1.2% since last year.
Cloud Data Warehouse
Hadoop
 

Featured Reviews

Sriram-Natesan - PeerSpot reviewer
The ability to create a lot of views or materialized views is beneficial
Improvement in the immediate response and the process of getting into a call could be helpful. We have had to wait for at least twenty-four hours to get a call and then wait for a couple more hours for a solution. Improved connectivity to different BI tools and already published connectors for major tools in AWS could enhance the service.
Shiv Subramaniam Koduvayur - PeerSpot reviewer
A robust solution with good support, but a better GUI for database management is needed
The biggest lesson that I have learned from using this solution is that a lot of evaluation should be done before starting. Also, we needed to put a lot of effort into understanding the different functions that the product offers. This allows you to best leverage the capability of the product. I would rate this solution a seven out of ten.

Quotes from Members

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

Pros

"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"Redshift Spectrum is the most valuable feature."
"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."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"With the tools we have, Amazon Redshift has the features to query efficiently."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The valuable features are performance, data compression, and scalability."
"This service can merge and integrate well with all databases."
"The most valuable feature is the performance."
"The need for administration involvement is quite limited on the solution."
"For me, as an end-user, everything that I do on the solution is simple, clear, and understandable."
"It is a back end for our SSIS, MicroStrategy,, Tableau. All of these are connecting to get the data. To do so we are also using our analytics which is built on the data."
"Speed contributes to large capacity."
"The performance of the solution is its most valuable feature. The solution is easy to administer as well. It's very user-friendly. On the technical side, the architecture is simple to understand and you don't need too many administrators to handle the solution."
"Data compression. It was relatively impressive. I think at some point we were getting 4:1 compression if not more."
 

Cons

"For people who struggle with IAM or role-based management, the setup isn't easy."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"The speed of the solution and its portability needs improvement."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"It is not easy to deal with queries in Amazon Redshift and see the same data."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The customer support could be more responsive."
"The hardware has a risk of failure. They need to improve this."
"In-DB processing with SAS Analytics, since this is supposed to be an analytics server so the expectation is there."
"Administration of this product is too tough. It's very complex because of the tools which it's missing."
"The solution could implement more reporting tools and networking utilities."
"This product is being discontinued from IBM, and I would like to have some kind of upgrade available."
"I'm not sure of IBM's roadmap currently, as the solution is coming up on its end of life."
"The Analytics feature should be simplified."
"Disaster recovery support. Because it was an appliance, and if you wanted to support disaster recovery, you needed to buy two."
 

Pricing and Cost Advice

"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"The solution is available at a mid-range price compared to other vendors."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"On a scale of one to ten, where one is a low price and ten is a high price, I rate the pricing a seven."
"The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"Expensive to maintain compared to other solutions."
"For me, mainly, it reduces my costs. It's not only the appliance cost. There are also support costs and a maintenance costs. It does reduce the costs very drastically."
"The annual licensing fees are twenty-two percent of the product cost."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
856,873 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
48%
Financial Services Firm
10%
Computer Software Company
8%
Manufacturing Company
4%
No data available
 

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.
Ask a question
Earn 20 points
 

Comparisons

No data available
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
A leading online advertising network
Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: May 2025.
856,873 professionals have used our research since 2012.