IBM Netezza Performance Server

Score7.5 out of 10

36 Reviews and Ratings

What is IBM Netezza Performance Server?

Netezza Performance Server (NPS) is an add-on data warehouse solution available on Cloud Pak for Data System platform, built over open source and optimized for High Performance Analytics with built-in hardware acceleration. Netezza Performance Server was previously named IBM Performance Server for PostgreSQL (IPS).

Categories & Use Cases

Data Warehouse

Maryam Abbott Saldivia View profile

Software Development Engineer in Information Technology at Possible Incorporated S.L. (11-50 employees employees)

Use Cases and Deployment Scope

Performance and speed are beneficial to the business when using data sharing, through IBM Netezza Performance Server. Netezza Performance is a configurable database, server, storage, and advanced analytics platform that can be used on-premises or in the cloud using IBM Cloud and Amazon Web Services. IBM Netezza Performance Server enables data design analysis with petabytes of storage at a low cost of ownership.

Pros

IBM Netezza Performance Server enables data virtualization and querying across multiple data sources without the need to replicate data to a separate analytics server.

Cons

Controlling space utilization at the database level with IBM Netezza Performance Server might be challenging at times.
Small firms face hefty subscription prices for IBM Netezza Performance Server.

Most Important Features

A fast and efficient implementation is available with IBM Netezza Performance Server, which combines components in a pre-integrated, tested configuration.
For efficiency and better use of resources, IBM Netezza Performance Server makes it easy to connect data management, governance, and data analysis.

Return on Investment

By concentrating all analytical activities in one place, where the data resides, Netezza Performance Server simplifies and speeds up data warehouse setup and analysis.
For the business, Netezza Performance Server provides performance benefits in the data processing.

Alternatives Considered

Cloudera Data Platform and Oracle Database Exadata Cloud Service

Other Software Used

Oracle Database Exadata Cloud Service, Panoply, Clearsense

Daniell Mercer View profile

Software Development Engineer in Information Technology at Persistent Systems (10,001+ employees employees)

Use Cases and Deployment Scope

With data volumes scalable to petabytes, IBM Netezza Performance Server enables data insights and machine learning. Integrating a database, server, storage, and analytics into a single system with petabyte scalability is invaluable. IBM Netezza Performance Server is a high-performance, massively parallel system for extracting insights and performing analysis on large volumes of data. The event configuration option in the IBM Netezza Performance Server is important to provide notification of any hardware component failure for quick replacement.

Pros

IBM Netezza Performance Server enables capabilities to integrate with leading ETL solutions.
Data can be exported from the IBM Netezza Performance Server to a variety of formats, including Excel.
We can prioritize specific users and queries using IBM Netezza Performance Server.

Cons

After using the program, the hosting and productivity aspects of the IBM Netezza Performance Server are relatively lacking.
The IBM Netezza Performance Server membership fee is quite high.

Most Important Features

IBM Netezza Performance Server is critical to the built-in automation and self-healing they offer across IBM Cloud, AWS, and Microsoft Azure, the available and fault-tolerant Netezza installation that collaborates and ensures our data warehouse is always up and running.
Backups can also be scheduled whenever we want, saved to object storage, and mirrored across multiple Availability Zones.

Return on Investment

Collaborate with hybrid multi-cloud techniques that are flexible and high-performance.
Simplifies data analysis by centralizing all actions in one location where the data lives.
Enables optimization of new data pipelines.
Provides seamless updates with full compatibility with Twinfin, Striper, and Mako workloads.
Beneficial for data silo elimination and data virtualization to query data across multiple systems.
Flexible to make the most of data.

Alternatives Considered

Oracle Database Exadata Cloud Service, Panoply and Cyral

Other Software Used

Oracle Database Exadata Cloud Service, Panoply, Firebolt

Himanshu Bhardwaj View profile

Senior Quality Assurance Analyst in Information Technology at Express (1001-5000 employees employees)

Use Cases and Deployment Scope

We used this tool in managing our POS application on individual devices. We used it for multipurpose as well as data warehouse purposes too. 1:16 ratio between server and individual devices for point of sale applications. The transaction extraction process has been made so easier with this tool and sync is almost real-time. The product addresses different platforms such as hardwired devices and portable mobile devices also.

Pros

The speed of operations is really second to none
The data control aspect is really effective and very useful
Stability and no latency issues notices during operations

Cons

More tech support may make it easier as it is only limited to be done via company representatives
Overhead cost for replacements and services looks like it is high compared to others
Integration with other cloud based application will be great

Most Important Features

Speed
performance
security

Return on Investment

One stop shop for all the various data points or matrix
easy administration
scalability

Alternatives Considered

Teradata Vantage - Enterprise Data Warehousing

Other Software Used

Teradata Data Warehouse Appliance 2850

Jayden Hammond View profile

Director, IT Operations and Implementation Services in Information Technology at UT Southwestern Medical Center (10,001+ employees employees)

Use Cases and Deployment Scope

In my current organization, we mainly use IBM Netezza Performance Server to integrate server, analytics and database in one single spot to gain real-time insights.

Pros

Has a simple infrastructure: Do not require tuning nor indexing.
Advanced security via self-encryption.
Unify data warehousing and BI with advanced analytics.

Cons

All the issues that I used to experience were all rectified by the vendor success team for free.

Most Important Features

Workload management capabilities.
Built-in database analytics tools.
Performance tuning capabilities.

Return on Investment

Processing large amounts of data.
Extraction of reports and adhoc analysis for unlocking real-time business insights.
Simplify writing queries procedures.

Alternatives Considered

Amazon Redshift

Verified User

Analyst in Marketing (1001-5000 employees employees)

Pros

Data export, i.e. to Excel.
Database views and queries monitor through Netezza monitor app.

Cons

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

Return on Investment

It allows us to work together simultaneously in the database to query our custom results.
It requires users to know the object name as it does not pop up in their text editor. Thus, users take more time in writing queries.

Alternatives Considered

Amazon Redshift, Microsoft Azure, Aginity, MySQL, MangoApps, PostgreSQL, Toad for Oracle, MS SharePoint / SQL and Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM)

Other Software Used

MangoApps, Microsoft Azure, PostgreSQL, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Toad for Oracle, Amazon Redshift