IBM Db2 Warehouse vs IBM Netezza Performance Server comparison

IBM Db2 Warehouse vs. IBM Netezza Performance Server

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

IBM Db2 Warehouse

Ranking in Data Warehouse

11th

Average Rating

7.8

Reviews Sentiment

5.3

Number of Reviews

Ranking in other categories

No ranking in other categories

IBM Netezza Performance Server

Ranking in Data Warehouse

12th

Average Rating

8.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 1.9%, up from 1.6% compared to the previous year. The mindshare of IBM Netezza Performance Server is 4.0%, up from 4.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse

Featured Reviews

Josef Kraus

Owner at S.K. Consulting Services GmbH

Useful for ETL process and has good documentation

The tool's most beneficial feature for our data management tasks has been the ETL process. Additionally, we utilized Windows and Linux. IBM Db2 Warehouse's scalability has significantly impacted our data storage capabilities. We needed to order new disks for storage every week within this hosting environment. Additionally, we implemented protection measures for production use. The tools are readily available, and if you're willing to invest in them, you can access a good data warehouse without any issues.

Read full review

Shemal Gandhi

Lead Oracle DBA | IBM Neteeza Admin | Consultant at Capgemini

A cost-effective data warehousing tool, but security features like TDE encryption are missing

The solution's maintenance is quite easy. One person is enough to maintain the solution. If you are using PostgreSQL as a database solution, then using IBM Netezza Performance Server is the logical choice since it is based on open-source Postgres. However, if you are using Oracle, data conversion can be tricky. So, in that case, you want to go ahead with Exadata. Overall, I rate IBM Netezza Performance Server a seven out of ten.

Read full review

Quotes from Members

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

Pros

"The analytics engine is not bad at forecasting predictions."

"Some of the best features are stored procedures, parallelism, and different indexing strategies."

"Provides good security and reliability."

"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."

"It can scale effectively as long as resources are available."

"The solution is stable."

"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."

"IBM Netezza Performance Server is a cost-effective solution."

"The most valuable feature would be the fact that it has been running for awhile in an appliance format."

"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."

"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."

"We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."

"Distribution concurrency control."

"The performance is most important to me, and it helps our ability to make business decisions quickly."

More IBM Netezza Performance Server pros

Cons

"There should be more material available for training and training should be free."

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

"IBM Db2 Warehouse needs to improve its interface."

"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."

"In terms of improvement, IBM Db2 Warehouse should be more scalable."

"Lacks sufficient documentation and particularly in Spanish."

"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."

More IBM Db2 Warehouse cons

"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."

"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."

"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."

"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."

"Concurrency limit needs to be increased somewhat."

"The only issue is that it's not expandable."

"In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all."

"LIke Teradata, we can’t add a node/SPU to the existing appliance."

More IBM Netezza Performance Server cons

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."

"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 solution has a yearly licensing fee, and users have to pay extra for support."

"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."

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

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…

Read full review

Top Industries

By visitors reading reviews

Educational Organization

59%

Financial Services Firm

Computer Software Company

Insurance Company

Educational Organization

73%

Financial Services Firm

Computer Software Company

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about IBM Db2 Warehouse?

The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.

What is your experience regarding pricing and costs for IBM Db2 Warehouse?

Db2 Warehouse or IBM products are pretty expensive. There are cheaper tools on the market. However, if the client is satisfied with paying for the Db2 Warehouse license, especially for cloud-based ...

What needs improvement with IBM Db2 Warehouse?

Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues. The technical support quality is good, but the response time needs improvement.

What do you like most about IBM Netezza Performance Server?

IBM Netezza Performance Server is a cost-effective solution.

What is your experience regarding pricing and costs for IBM Netezza Performance Server?

The solution has a yearly licensing fee, and users have to pay extra for support.

What needs improvement with IBM Netezza Performance Server?

Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.

Oracle Exadata vs IBM Db2 Warehouse

Comparisons

Compared 29% of the time

Snowflake vs IBM Db2 Warehouse

Compared 28% of the time

Teradata vs IBM Db2 Warehouse

Compared 14% of the time

Amazon Redshift vs IBM Db2 Warehouse

Compared 10% of the time

IBM Db2 Warehouse on Cloud vs IBM Db2 Warehouse

Compared 9% of the time

More IBM Db2 Warehouse Competitors

Teradata vs IBM Netezza Performance Server

Compared 17% of the time

Oracle Exadata vs IBM Netezza Performance Server

Compared 16% of the time

Oracle Database vs IBM Netezza Performance Server

Compared 10% of the time

Snowflake vs IBM Netezza Performance Server

Compared 8% of the time

IBM Db2 Database vs IBM Netezza Performance Server

Compared 8% of the time

More IBM Netezza Performance Server Competitors

Product Reports

IBM Db2 Warehouse

Download IBM Db2 Warehouse product report

IBM Netezza Performance Server

Download IBM Netezza Performance Server product report

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse

Netezza Performance Server, Netezza

Learn More

Video not available

IBM

Overview

InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

IBM Netezza appliances are now part of IBM PureSystems - expert integrated systems with built in expertise, integration by design and a simplified user experience. Part of the PureData family, the Netezza appliance is now known as the PureData System for Analytics. It has the same key design tenets of simplicity, speed, scalability and analytics power that was fundamental to Netezza appliances.

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited

Seattle Childrens 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

IBM Db2 Warehouse vs. IBM Netezza Performance Server