Introducing G2.ai, the future of software buying.Try now
Minitab Connect
Sponsored
Minitab Connect
Visit Website
Product Avatar Image
IBM Netezza Performance Server

By IBM

4.1 out of 5 stars

How would you rate your experience with IBM Netezza Performance Server?

Minitab Connect
Sponsored
Minitab Connect
Visit Website
It's been two months since this profile received a new review
Leave a Review

IBM Netezza Performance Server Reviews & Product Details

Profile Status

This profile is currently managed by IBM Netezza Performance Server but has limited features.

Are you part of the IBM Netezza Performance Server team? Upgrade your plan to enhance your branding and engage with visitors to your profile!

Value at a Glance

Averages based on real user reviews.

Time to Implement

5 months

Perceived Cost

$$$$$
Product Avatar Image

Have you used IBM Netezza Performance Server before?

Answer a few questions to help the IBM Netezza Performance Server community

IBM Netezza Performance Server Reviews (84)

View 2 Video Reviews
Reviews

IBM Netezza Performance Server Reviews (84)

View 2 Video Reviews
4.1
84 reviews

Pros & Cons

Generated from real user reviews
View All Pros and Cons
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Verified User in Insurance
CI
Enterprise (> 1000 emp.)
"IBM QUERY"
What do you like best about IBM Netezza Performance Server?

I use this application everyday for writing sql queries and it a very friendly and helpful tool because of its easy to use features and ability to connect to multiple instances of schema. Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

Look and Feel should be improved. Previous sessions are not being stored sometimes. Review collected by and hosted on G2.com.

Verified User in Gambling & Casinos
UG
Enterprise (> 1000 emp.)
"Great MPP Data Warehouse Appliance"
What do you like best about IBM Netezza Performance Server?

I like that Netezza is an old player in the DW world. They were one of the first to come out with a commercially available Data Warehouse Appliance. They've also made great improvements along the way. The sheer processing power of the appliance makes most jobs run without any issues. The analytic functions provided have also proven to be very useful. It is also easy to set up a distribution key so you know how the data is being sharded across all the nodes. Another thing I like are the CLI tools. NZLOAD for example has been an integral part of our near real time load process. NZMIGRATE has proven to be a great database copy tool. I could go on, but there are definitely some great tools included with this product. I would recommend to at least speak with an IBM representative to see if this Appliance is right for you. Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

Sometimes the SQL language Netezza uses (it's a PostreSQL variant) can get a little annoying. But if you're used to PostreSQL you can certainly get up and running. Review collected by and hosted on G2.com.

Kushal R.
KR
Associate
Information Technology and Services
Enterprise (> 1000 emp.)
"Fast and High Volume data compatible"
What do you like best about IBM Netezza Performance Server?

Its very fast when compared to other DBs present. Aginity tool by IBM is great to work on the Netezza DB. Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

As you adopt this DB, you have to make few changes for your builtin functions. Review collected by and hosted on G2.com.

Verified User in Higher Education
CH
Enterprise (> 1000 emp.)
"Getting lost in the cloud"
What do you like best about IBM Netezza Performance Server?

It is straightforward interface, useful when I just want to dump out data and process it in C or R. Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

It needs a more powerful query builder and a more updated GUI. Review collected by and hosted on G2.com.

Naresh K.
NK
Solutions Designer
Financial Services
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Extremely fast. "
What do you like best about IBM Netezza Performance Server?

Extremely fast is designed properly, even with terabytes of data. You will never go back to oracle or any traditional db's once using netezza Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

SQL toolkit functions is not extensive like Oracle and not many parellel processes allowed Review collected by and hosted on G2.com.

Hossein S.
HS
Research Assistant
Higher Education
Enterprise (> 1000 emp.)
"An HPC appliance for a full stack database"
What do you like best about IBM Netezza Performance Server?

I was introduced to Netezza in a research project in Dalhousie university a couple of months ago. Since then, I believe Netezza is definitely one of the best machines for big data analytics. Having well designed HPC techniques in any single part, I found it well tuned, fast and easy to use. There are some good and free client applications available to manage the server and run scripts.

One thing which is amazing is its built-in DBA that work as a 24-7 support team. Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

Unlike its well written official documents, there are almost no active user community on Netezza topics. Having said that, it is sometimes very tough to find a solution to an obvious question. I checked only three different client management tools to work with it. They shared one thing in common that is all of them provide something that the other two doesn't provide. This results to have all of them and work on different client tools to have everything done. In addition, the official IBM client that comes with Netezza can be said to be the worst of them.

In addition, lack of demos or tutorials on very common problems is another issue that I think should be added to Netezza official document. Review collected by and hosted on G2.com.

Bhuvaneshor A.
BA
Sr BI Architect - Reporting
Information Technology and Services
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Very good product... Opportunity to become better"
What do you like best about IBM Netezza Performance Server?

Less Administration Required

Easy to move data and fetch data Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

Since this is unix based less user interface available to manage. Need better managements tools with intuitive user interface. Provide more utilities to manage performance and reporting about performance. Need utility to migration of code and data.

Difficulty finding material about Natezza or books and best practice related documents

Finding resources developers and dba is very hard

In Nashville are you going to do some conference? Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
AM
Mid-Market (51-1000 emp.)
"Very fast if you follow the best practices and understand the architecture"
What do you like best about IBM Netezza Performance Server?

The MPP (Massively Parallel Processing) architecture is very strong feature of this appliance which helps in running ugly time consuming warehouse report queries very fast - These would have taken forever to run on other RDBMS databases. The key is the fact that most of the unwanted data is filtered (projection and restriction) as close to the disk as possible. Standard SQL queries can be used with the appliance which makes it easier for porting existing applications and avoid a new learning curve in that front.

If the best practices are followed in terms of distribution keys, data-types etc. you can get real good performance boost.

Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

Since this is an appliance, it has many hardware components inside and we have experienced lots of sporadic hardware failures - we are then at the mercy of IBM to replace them (Scheduling, webX, field Engg) which really reflects on the SLA. Many companies have complained about the Moose disks (bad batch of disks) which had to be completely replaced. For small shops this could be really inconvenient.

There aren't enough active user community for Netezza and so it gets very difficult sometimes. You again would need to open a ticket with IBM and get understanding of what it is (eg - SEU single bit vs Multi bit error) and get some documentation on the issues.

Also dislike the fact that the catalog backup pauses the system. (Understand that the catalog is in the host file system) But if IBM can allow a hot catalog backup, that would be very useful.

Review collected by and hosted on G2.com.

Ramakant S.
RS
Data Warehouse Specialist
Consumer Services
Mid-Market (51-1000 emp.)
"Impressively fast data warehousing appliance"
What do you like best about IBM Netezza Performance Server?

Lightning fast performance even with half of Terra byte Size of Tables

Very fast loading and offloading of Data

Faster Backup and restore Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

Keys are not enforced

Small bugs. i.e. Different SPU may have different system Time resulting into different time stamps while loading data into tables or in similar use cases

Database generated surrogate keys are not in Order - although it doesn't matter much

Slow Updates

Costly

Lack of maturity observed at some occasions where it went down due to silly reasons- i.e Query getting queued up Review collected by and hosted on G2.com.

Milind O.
MO
VP of Data Warehousing / BI
Financial Services
Mid-Market (51-1000 emp.)
"Performance beast as long as you KISS it"
What do you like best about IBM Netezza Performance Server?

The hardware platform approach surely is the core processing power behind Netezza. The ability to run standard SQL queries is a huge plus as this helps development and eliminates yet another language learning curve. With multi server architecture the performance improvements are easily realized. Review collected by and hosted on G2.com.

What do you dislike about IBM Netezza Performance Server?

The performance of the system seems to break down with implementation of views, especially layers of views. The appliance is designed around table joins and so I think its best to avoid views or at least keep them non nested. That means creating more tables and more ETL. Any table once organized and distributed on particular set of columns only those queries will see advantage, so if you have a huge variety of queries against that table then not all of them will see improvements. Another pain was disk failures and the fact that IBM certified technician has to come to replace the disks every time. I was just surprised by the rate of failures! Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

5 months

Perceived Cost

$$$$$
IBM Netezza Performance Server Comparisons
Product Avatar Image
Oracle Exadata Cloud Service
Compare Now
Product Avatar Image
Amazon Redshift
Compare Now
Product Avatar Image
Snowflake
Compare Now
IBM Netezza Performance Server Features
Data Integration
Data Compression
Data Quality
BI Tool Integration
Data lake Integration
Cloud
Data Governance
Data Security