Netezza Review

Distribution concurrency control is key for us


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.

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 is customer service and technical support?

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

Which solutions did we use previously?

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.
Add a Comment
Guest

Sign Up with Email