IBM Netezza Performance Server Pros and Cons

I like how IBM Netezza Performance Server is not just a cloud service but also a business resource. You can move data and process programs without affecting the original data and use this to analyze it. Review collected by and hosted on G2.com.

It is a little confusing how to purchase the server for a whole group of people, such as a group of employees. The only information given is purchasing a consultation. Review collected by and hosted on G2.com.

Easy to use (no need to use indexes etc.) and really fast. I like external tables a lot. Review collected by and hosted on G2.com.

Lack of anyy oficcial SQL client (Oravle have SQL Developer etc.) Review collected by and hosted on G2.com.

Development of reports with low query times thus avoiding the construction of information cubes Review collected by and hosted on G2.com.

When there are a few million records, you do not see the decrease in query times Review collected by and hosted on G2.com.

IBM Netezza Performance Server is a very powerful database that can hold large data and bring results very fast. It is simple to use, scalable, fast, and since it's an AI-based platform so it's smart as well.

Also, it's different from other databases like Teradata, Oracle, etc in terms of we have to tune a query to make it faster but in Netezza, we don't need to provide any indexing. Also its very cost effective Review collected by and hosted on G2.com.

As of nothing to say, It's the best DB because using the DB on BI is a key where we need a database that can retrieve a result very fast so the reporting solution also becomes faster. Review collected by and hosted on G2.com.

Good Platform for Cloud Computing for All Small and Big Companies. Review collected by and hosted on G2.com.

Pricing is very high for low budget companies Review collected by and hosted on G2.com.

Tables are simple to structure, add, and remove data variables from.

Exporting data to various formats was simple. as in Excel

There are various table views available. Review collected by and hosted on G2.com.

cannot utilize pivot, a function found in MS SQL Server.

Not supported by Windows-based systems but supported by Linux-based systems Review collected by and hosted on G2.com.

IBM Netezza is a good datawarehouse tool and it has better performance. Review collected by and hosted on G2.com.

Analytics functions can be more improved. Review collected by and hosted on G2.com.

Hight performance sql tool, easy to use and work Review collected by and hosted on G2.com.

Interface can be improved

Analytics operations can made better Review collected by and hosted on G2.com.

IBM Netezza is the most powerful and faster DB which helps us to give the better speed for the retrieval of data and since it uses the cloud-based AI-driven architecture which makes it unique to hold unlimited data(I know there is nothing called unlimited).

Also since is an AI-based technique which makes it scalable, price effective and easy to use. Also, we don't need to bother about tuning our SQL and writing the hints into the query to make it faster. Review collected by and hosted on G2.com.

I would say the architecture might be difficult for people to understand who wanted to understand the mechanism behind the tool but for users like me, I don't have anything to say as bad about Netezza. Review collected by and hosted on G2.com.

I have been working on Netezza systems for more than seven years. It is a powerful OLAP system. Worked on all 3 Netezza family systems, and each appliance comes with more power to new generation systems. Business queries performance is far better on Mako appliance. Netezza system is user-friendly, and one can learn this technology yourself by referring to IBM online guides.

There are many areas in Netezza which you can look into to optimize the system like Table redesign, Implementing CBT, queries join conditions, Express/Full statistics and groom and many more.

IBM has provided inbuilt contrib utilities to make DBA work easy and also has good customer support.

If one has little idea about shell scripting then can write many scripts to optimize DBA work.

Also Netezza appliance has a feature of setting up events which will send notification on any hardware component failure for timely replacement.

Netezza NPS upgrade is easy to implement and rollback by DBAs. Review collected by and hosted on G2.com.

Netezza has few drawbacks like you cannot control space usage at a database level, also need to contact IBM support to understand the internal parameters pros n cons Review collected by and hosted on G2.com.