IBM Netezza Performance Server Pros and Cons

The speed and reliable data warehouse. The server is easy to maintain and requires minimal support activity Review collected by and hosted on G2.com.

There are already service providers for Datawarehouseing like Snowflake, AWS. Migration could be smoother. Review collected by and hosted on G2.com.

The Workload Management option helps you to redirect the Specific set of Queries into a specific Queue. Option to set the Priority for specific Users or Specific Queries Review collected by and hosted on G2.com.

Disk Replacement is frequently coming nowadays, which requires some attention from IBM. Cloud Solution for Netezza needs to rollout Review collected by and hosted on G2.com.

The most helpful feature of IBM Netezza I felt is its availability over cloud. Apart from this the in-database analytics capabilities of the application is very much useful to handle & manage the data warehouse of my client. Review collected by and hosted on G2.com.

Performance tuning features are a little bit limited that I feel after using the application. Review collected by and hosted on G2.com.

IBM Neteeza is a very versatile tool and is a good platform for multiple data loads as your source. I have worked with Neteeza where in I had three different sources i.e 1) Oracle, 2) MS SQL Server & 3) PostgreSQL. It worked seamlesly with all these different data sets to pull in bulk loads of data on a daily bases. Review collected by and hosted on G2.com.

Many daily tasks cannot be performed from the frontend portal, requiring the admins to have some linux knowledge to perform the tasks, like backup & recovery for example. Review collected by and hosted on G2.com.

The bulk copy feature of Netezza was really helpful. Review collected by and hosted on G2.com.

Netezza could provide cloud services too. Review collected by and hosted on G2.com.

Simplicity of operations and administration; HW based accelerator for compression/decompression that leads to consistent fast performance for all SQL operations. something even bigdata server can't achieve; integrate well with major ETL tools; Superb update performance - which is critical to DW. raw data load is actually quite good too for Netezza or older DB technology. Most of the business(98%) out there don't really need what google or facebook is using! Review collected by and hosted on G2.com.

At the price point - none; if i have to pick one; lack of advanced stored procedure support - in-memory processing / advanced data type. This was based on 5 years ago experience; lately. i heard many DB2/Oracle PL/SQL features has been migrated in. Review collected by and hosted on G2.com.

Data could be extracted using simple query language.

Easy to add , remove data variables and structure tables .

Data could be easily exported to other formats . for e.g Excel

Different views of the tables available. Review collected by and hosted on G2.com.

Difficulties processing with large amounts of data

Finding data tables is not easy. Key to relevant tables and view not available.

Easy overwriting of tables causing Data miss match. Review collected by and hosted on G2.com.

Overall Comment:"Solid solution - well positioned among close competitors. Good performance overall ; easy to implement, easy to operate." Review collected by and hosted on G2.com.

Cannot use functions such as pivot, which is in MS SQL Server

Objects such as tables do not pop up automatically in the editor, users needs to navigate themselves to know the object names Review collected by and hosted on G2.com.