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
67
Ranking in other categories
Cloud Data Warehouse (5th)
Netezza Analytics
Average Rating
7.4
Number of Reviews
11
Ranking in other categories
Hadoop (11th)
 

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 6.8%, down 9.7% compared to last year.
Netezza Analytics, on the other hand, focuses on Hadoop, holds 1.5% mindshare, up 1.0% since last year.
Cloud Data Warehouse
Hadoop
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
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.
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

"The most valuable feature is the scalability, as it grows according to our needs."
"Its simplicity in configuration, cost-effectiveness due to being in the cloud and close to our data sources, and the fact that it's a managed service that is scalable and reliable are highly valuable."
"The stability of Amazon Redshift is good."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"The initial setup is easy."
"The ability to reload data multiple times at different times."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"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."
"The need for administration involvement is quite limited on the solution."
"Data compression. It was relatively impressive. I think at some point we were getting 4:1 compression if not more."
"Speed contributes to large capacity."
"The most valuable feature is the performance."
"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."
 

Cons

"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"The product must become a bit more serverless."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"The speed of the solution and its portability needs improvement."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"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."
"The most valuable features of this solution are robustness and support."
"The hardware has a risk of failure. They need to improve this."
"The solution could implement more reporting tools and networking utilities."
"I'm not sure of IBM's roadmap currently, as the solution is coming up on its end of life."
"Administration of this product is too tough. It's very complex because of the tools which it's missing."
"This product is being discontinued from IBM, and I would like to have some kind of upgrade available."
"Disaster recovery support. Because it was an appliance, and if you wanted to support disaster recovery, you needed to buy two."
"The Analytics feature should be simplified."
 

Pricing and Cost Advice

"The solution is available at a mid-range price compared to other vendors."
"It is an expensive product."
"The pricing is reasonable."
"It's pay per use. You can have multiple models."
"Pricing for Amazon Redshift is reasonable, though it could be somewhat higher than other solutions, such as Azure. Still, when you base your comparison on the services offered and the pricing, it's the most reasonable versus its competitors, such as RDS."
"My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"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."
"The annual licensing fees are twenty-two percent of the product cost."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
832,138 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
64%
Financial Services Firm
7%
Computer Software Company
5%
Manufacturing Company
3%
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
 

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: February 2025.
832,138 professionals have used our research since 2012.