IBM Netezza Performance Server Reviews, Competitors and Pricing

it_user669453

Data Warehouse Architect at a consultancy

Mar 14, 2018

Download

Distribution concurrency control is key for us

Pros and Cons

"Distribution concurrency control."

"Concurrency limit needs to be increased somewhat."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."

What is our primary use case?

We use Netezza and Teradata in our project environment where I work as an admin and data modeler.

What is most valuable?

Distribution concurrency control.

What needs improvement?

Concurrency limit needs to be increased somewhat.

For how long have I used the solution?

More than five years.

Buyer's Guide

IBM Netezza Performance Server

November 2024

Free Report: IBM Netezza Performance Server Reviews and More

Learn what your peers think about IBM Netezza Performance Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

DOWNLOAD NOW

831,881 professionals have used our research since 2012.

What do I think about the stability of the solution?

Great stability in Netazza's Mako.

What do I think about the scalability of the solution?

As of now, no issues with scalability. But like Teradata, we can’t add a node/SPU to the existing appliance.

How are customer service and support?

I work with IBM PDA support. They are wonderful and fix issues in good time.

Which solution did I use previously and why did I switch?

We used Teradata for Data Mart for certain applications but issues arose once the data setup grew. Using PDA, the issues were resolved.

How was the initial setup?

Setup is not that complex. Within 24 hours we had everything completed and had copied the dataset from Oracle. Our migration approach was to use a shell script (pipe).

What other advice do I have?

Best if you have a robust infrastructure, where network bandwidth is good. We used 10GB Ethernet cable for data transfer.

Disclosure: I am a real user, and this review is based on my own experience and opinions.

it_user351462

Data Architect/Modeler with 501-1,000 employees

Dec 9, 2015

Download

It provides outstanding performance for structured data, but bitemporal support is needed.

What is most valuable?

Performance
Not complex to administer

How has it helped my organization?

It provides a key repository for risk information - suitable due to volume of data.

What needs improvement?

Bitemporal support is needed.

For how long have I used the solution?

I've used it for three years.

What do I think about the stability of the solution?

We found some bugs - boundary conditions mostly.

What do I think about the scalability of the solution?

There are no issues with scalability.

How are customer service and technical support?

9/10 - I have always be able to reach someone at IBM with the correct answer.

Which solution did I use previously and why did I switch?

Non analytic databases used to be all there was. Netezza provides outstanding performance for structured data.

How was the initial setup?

I didn't set up but our database administrators have said it is much simpler than Oracle, or DB2.In house - have a person trained on PureData - it will pay off

What about the implementation team?

In house - have a person trained on Pure Data - it will pay off

What was our ROI?

I can't quantify ROI.

What's my experience with pricing, setup cost, and licensing?

Licensing is straightforward - you end up buying the box with Netezza on it as it's an appliance.

What other advice do I have?

Every query has to be set based - no iteration over a result set. stored procedures should be used sparingly.

Disclosure: I am a real user, and this review is based on my own experience and opinions.