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

Amazon Redshift vs IBM Db2 Warehouse on Cloud vs IBM Netezza Performance Server 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:
 

Mindshare comparison

Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
Amazon Redshift7.5%
Snowflake17.7%
Dremio9.4%
Other65.4%
Cloud Data Warehouse
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
IBM Db2 Warehouse on Cloud0.8%
Snowflake17.7%
Dremio9.4%
Other72.1%
Cloud Data Warehouse
Data Warehouse Market Share Distribution
ProductMarket Share (%)
IBM Netezza Performance Server4.4%
Oracle Exadata14.1%
Teradata13.2%
Other68.3%
Data Warehouse
 

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.
FM
Enhancing analytics with seamless data dumping and reliable support
Our primary use case is data storage and analytics The organization has decided to purchase a full stack solution from IBM due to positive responses, which helped them upgrade from the previous version. The data dumping into the raw zone and the feature of BigQuery is quite attractive. There…
Shiv Subramaniam Koduvayur - PeerSpot reviewer
Parallel data processing streamlines operations while cost and cloud integration challenge adoption
The cost of the solution is on the more expensive side, which is a concern for me. Additionally, its promotion and interaction with cloud applications are limited. The cloud version is only available in AWS, and in the Middle East, it is not well-developed in the Azure environment. For the cost to be reduced, it should match competitors. Many features need to be incorporated on the cloud.

Quotes from Members

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

Pros

"This service can merge and integrate well with all databases."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"The initial setup is easy."
"It allows for the storage of huge amounts of data."
"The solution's speed, stability, and user concurrency have been very good."
"It's scalable because it's on the cloud."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The performance is okay as long as the volume of queries is not too high."
"It is stable when there is support from IBM."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​"
"It will be MPP, so performance should improve."
"Speed contributes to large capacity."
"The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general."
"The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that."
"Parallel data processing is a significant feature for me."
"IBM Netezza Performance Server is a cost-effective solution."
"Distribution concurrency control."
"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
 

Cons

"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"The only minor issue I faced was that it took a bit longer than expected to change the cluster to have more space or storage."
"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."
"During the setup, whenever we try to give any permissions, if I have a data warehouse in Amazon Redshift and want to provide access to a user to just check the data without making any changes, it is a long process to create a policy in Amazon and share it with that policy."
"This solution lacks integration with non-AWS sources."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"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."
"There might be some limitations from a business intelligence perspective, but nothing we can't find a workaround for."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"The Analytics feature should be simplified."
"Concurrency limit needs to be increased somewhat."
"The solution could implement more reporting tools and networking utilities."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"The only issue is that it's not expandable."
"I'm not sure of IBM's roadmap currently, as the solution is coming up on its end of life."
"The product cost is high compared to others in the market, and this cost has become unbearable for me."
"This product is being discontinued from IBM, and I would like to have some kind of upgrade available."
 

Pricing and Cost Advice

"The pricing is reasonable."
"The solution has very competitive pricing."
"The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term."
"It is an expensive product."
"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."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"The cost is comparable to Snowflake."
"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
"The annual licensing fees are twenty-two percent of the product cost."
"The solution has a yearly licensing fee, and users have to pay extra for support."
"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."
"Netezza is a costly solution. It does serve a specific purpose but it's costlier than what's available in the market, if you go to the cloud."
"The pricing is very expensive. It has a lot CPUs with a lot of components in it. It also has built-in redundancy for resiliency reasons."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
867,341 professionals have used our research since 2012.
 

Comparison Review

it_user232068 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Government
8%
No data available
Financial Services Firm
22%
Insurance Company
8%
Manufacturing Company
7%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise21
Large Enterprise27
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise5
Large Enterprise33
 

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 str...
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 w...
What advice do you have for others considering IBM Db2 Warehouse on Cloud?
Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions t...
What needs improvement with IBM Db2 Warehouse on Cloud?
There are some limitations in adding data files to table spaces, and improvements are needed for regional support.
What is your primary use case for IBM Db2 Warehouse on Cloud?
Our primary use case is data storage and analytics.
What needs improvement with IBM Netezza Performance Server?
The cost of the solution is on the more expensive side, which is a concern for me. Additionally, its promotion and in...
What advice do you have for others considering IBM Netezza Performance Server?
The solution has generally received positive feedback from me and is recommended for continued use by end users. Howe...
 

Also Known As

No data available
IBM dashDB
Netezza Performance Server, Netezza, Netezza Analytics
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Copenhagen Business School, BPM Northwest, GameStop
Seattle Childrens Hospital, Carphone Warehouse, Vanderbilt University School of Medicine, Battelle, Start Today Co. Ltd., Kelley Blue Book, Trident Marketing, Elisa Corporation, Catalina Marketing, iBasis, Barnes & Noble, Qualcomm, MediaMath, Acxiom, iBasis, Foxwoods
Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: August 2025.
867,341 professionals have used our research since 2012.