We performed a comparison between Amazon Redshift and Netezza Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."The most valuable feature of Redshift is its cluster."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"It is quite simple to use and there are no issues with creating the tables."
"It's scalable because it's on the cloud."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"The valuable features are performance, data compression, and scalability."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"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."
"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 most valuable feature is the performance."
"Speed contributes to large capacity."
"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."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"The product could be improved by making it more flexible."
"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."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"Should be made available across zones, like other Multi-AZ solutions."
"The most valuable features of this solution are robustness and support."
"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."
"Administration of this product is too tough. It's very complex because of the tools which it's missing."
"I'm not sure of IBM's roadmap currently, as the solution is coming up on its end of life."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 reviews while Netezza Analytics is ranked 11th in Hadoop. Amazon Redshift is rated 7.8, while Netezza Analytics is rated 7.4. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Netezza Analytics writes "ARULES() function is the fastest implementation of the associations algorithm (a priori or tree) I have worked with". Amazon Redshift is most compared with Snowflake, Teradata, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas Netezza Analytics is most compared with Spark SQL and HPE Ezmeral Data Fabric.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.