Netezza Review

SQL is 100% ANSI compliant, but support for interfaces has been poor.


Valuable Features

  • The ability to load data very quickly
  • SQL is 100% ANSI compliant
  • Queries run very fast and require no hints (Oracle)
  • No space management
  • Tuning SQL is generally pretty easy

Improvements to My Organization

For every organization that I have been in that has Netezza, the ability to load and run queries is greatly simplified and A LOT faster than any other DBMS out there.

Room for Improvement

Netezza is just starting on real time integration with Big Insights (big data). Support for interfaces has been poor. Hoping this improves.

Use of Solution

I've used it for nine years.

Deployment Issues

No issues encountered.

Stability Issues

Netezza servers used to have disk issues in the early days, however, for the most part this has been addressed.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service:

9/10.

Technical Support:

9/10.

Previous Solutions

I have used Oracle and Teradata as a DBA. I have found Netezza to be the easiest in terms of DBA management

Initial Setup

Very straightforward. Data movement is very easy. It works better if you do 1 large file as opposed to several small files

Implementation Team

Netezza servers are installed by IBM but implementations are sometimes handled in house and for others it maybe a mixture with BI vendors. We are a BI vendor and do implementations.

Other Solutions Considered

Most shops I am in have used Oracle, Sql Server, or Teradata. Depending on what the data is being used for (OLTP, OLAP). OLAP is the best application for a Netezza server.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are partners with IBM.
Add a Comment
Guest

Sign Up with Email