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 (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.9%, down 9.4% compared to last year.
Netezza Analytics, on the other hand, focuses on Hadoop, holds 1.3% 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 its scalability."
"The solution's speed, stability, and user concurrency have been very good."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"We have found Machine Learning use cases are very nice."
"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."
"With the tools we have, Amazon Redshift has the features to query efficiently."
"It allows you write complex queries and perform row by row processes."
"I am satisfied with the performance of the product."
"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."
"For me, as an end-user, everything that I do on the solution is simple, clear, and understandable."
"The need for administration involvement is quite limited on the solution."
"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."
"Data compression. It was relatively impressive. I think at some point we were getting 4:1 compression if not more."
"The most valuable feature is the performance."
 

Cons

"It is not easy to deal with queries in Amazon Redshift and see the same data."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"The OLAP slide and dice features need to be improved."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"This solution lacks integration with non-AWS sources."
"The product could be improved by making it more flexible."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"Administration of this product is too tough. It's very complex because of the tools which it's missing."
"The most valuable features of this solution are robustness and support."
"The solution could implement more reporting tools and networking utilities."
"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."
"In-DB processing with SAS Analytics, since this is supposed to be an analytics server so the expectation is there."
"The hardware has a risk of failure. They need to improve this."
"This product is being discontinued from IBM, and I would like to have some kind of upgrade available."
 

Pricing and Cost Advice

"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"It's pay per use. You can have multiple models."
"The best part about this solution is the cost."
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"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."
"Expensive to maintain compared to other solutions."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
842,296 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
65%
Financial Services Firm
6%
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: March 2025.
842,296 professionals have used our research since 2012.