--- title: IBM Netezza Performance Server Reviews meta_title: 'IBM Netezza Performance Server Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 84 reviews by the users' company size, role or industry to find out how IBM Netezza Performance Server works for a business like yours. aggregate_rating: rating_value: 4.1 review_count: 84 scale: '5' date_modified: '2026-08-07' parent_category: name: IT Infrastructure url: https://www.g2.com/categories/it-infrastructure --- # IBM Netezza Performance Server Reviews **Vendor:** IBM **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.1/5.0 **Total Reviews:** 84 ## About IBM Netezza Performance Server Integrates database, server, storage and analytics into a single system with petabyte scalability. Fast analytics Provides a high-performance, massively parallel system that enables you to gain insight from your data and perform analytics on very large data volumes. Smart, efficient queries Simplifies analytics by consolidating all activity in one place, where the data resides. Simplified infrastructure Easy to deploy and manage; simplifies your data warehouse and analytic infrastructure. Does not require tuning, indexing or aggregated tables and needs minimal administration. Advanced security Enhanced data security is provided through self-encrypting drives as well as support for the Kerberos authentication protocol. Integrated platform Supports thousands of users, unifying data warehouse, Hadoop and business intelligence with advanced analytics. ## IBM Netezza Performance Server Pros & Cons **What users like:** - Users value the **exceptional speed** of IBM Netezza Performance Server, enhancing data analysis and handling complex queries efficiently. (5 reviews) - Users rave about the **exceptional speed and efficiency** of IBM Netezza Performance Server, enhancing data analysis and processing tasks. (4 reviews) - Users value the **user-friendly interface** of IBM Netezza Performance Server, making data analysis and integration effortless. (3 reviews) - Users praise the **exceptional processing speed** of IBM Netezza Performance Server, enhancing data analysis and query efficiency. (3 reviews) - Users commend the **high processing speed and efficiency** of IBM Netezza Performance Server for seamless data management. (2 reviews) - Large Datasets (2 reviews) - Powerful BI (2 reviews) - Users value the **cost predictability** of IBM Netezza Performance Server, enhancing efficiency and budget management for data solutions. (1 reviews) - Data Integration (1 reviews) - Users value the **easy integrations** of IBM Netezza Performance Server, enhancing scalability and real-time analysis capabilities. (1 reviews) **What users dislike:** - Users identify the **high cost** of IBM Netezza Performance Server as a significant challenge, particularly for smaller enterprises. (3 reviews) - Users find the **high maintenance costs** of IBM Netezza Performance Server a barrier, particularly for smaller businesses. (2 reviews) - Users find **integration issues** challenging when connecting IBM Netezza Performance Server with other software tools. (1 reviews) - Users find the **limited customization** options frustrating, which can hinder software integration and flexibility. (1 reviews) - Users experience **slow performance** with IBM Netezza Performance Server when handling millions of records, affecting query times. (1 reviews) - Slow Queries (1 reviews) ## IBM Netezza Performance Server Reviews ### 1. Efficiency Unleashed: A Comprehensive Review of IBM Netezza Performance Server **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Food Production | Small-Business (50 or fewer emp.) **Reviewed Date:** November 17, 2023 **What do you like best about IBM Netezza Performance Server?** The standout feature of IBM Netezza Performance Server that I appreciate the most is its remarkable processing speed and efficiency in handling complex data queries. This, coupled with a user-friendly interface, significantly enhances the overall ease of use and accelerates data analysis tasks. **What do you dislike about IBM Netezza Performance Server?** While IBM Netezza Performance Server excels in many aspects, one drawback is the relatively high cost associated with its implementation and maintenance. This might pose a challenge for smaller enterprises with budget constraints seeking a powerful data management solution. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** I leverage IBM Netezza Performance Server for optimizing and streamlining our agro-food traceability processes. This robust solution enables us to efficiently analyze and manage vast datasets related to the production, distribution, and quality control of our agricultural products. By harnessing its powerful performance and scalability, we enhance traceability throughout the supply chain, ensuring transparency, compliance with standards, and ultimately delivering high-quality and safe agro-food products to consumers. ### 2. IBM Netezza Performance Server **Rating:** 4.0/5.0 stars **Reviewed by:** ABHISHEK A. | Data Engineer , Enterprise (> 1000 emp.) **Reviewed Date:** December 13, 2023 **What do you like best about IBM Netezza Performance Server?** It was known for several features that users found beneficial. This software and technology evolve, so there may be updates or changes to the product since then. Here are some aspects that users typically appreciated about IBM Netezza like High Performance,Scalability,Built-in Analytics, etc **What do you dislike about IBM Netezza Performance Server?** like any technology, there might be aspects that some users find less favorable like cost, Limited Customization,Updates and Upgrades, etc **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** BM Netezza Performance Server addresses various challenges associated with data warehousing and analytics, providing several benefits to organizations that deploy it. ### 3. High performance DWH **Rating:** 4.0/5.0 stars **Reviewed by:** VINAY L. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 14, 2023 **What do you like best about IBM Netezza Performance Server?** Our data platform architecture requires Data warehousing solution that's highly performant, cost effective, reliable and many more. Netezza ticks most of the boxes **What do you dislike about IBM Netezza Performance Server?** No better community support. Was expecting better articles about getting started as well. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Were able to bring data to dwh pretty easily and keep it ready for analytics. Integrates with most of the important etl tools. ### 4. Netezza on cloud pak **Rating:** 4.0/5.0 stars **Reviewed by:** Chaitanya M. | IT Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** May 26, 2023 **What do you like best about IBM Netezza Performance Server?** The fact that this solution is a cloud native offering and it's designed to unify data that's residing in silos in an organization to come to gether and provide powerful insights **What do you dislike about IBM Netezza Performance Server?** The integration with Watson is seamless and great but if u have an in-house ai driven analytical engines built already integration is a time consuming and needs a lot of hours to setup correctly **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Unification of fat which was siloed before. We had half picture before because we were only looking at a chunk of day for customer behaviour with netezza we are able to get a 360 view ### 5. Im a manager of one team in Management Information System Unit of Bank **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** May 19, 2023 **What do you like best about IBM Netezza Performance Server?** Easy to use (no need to use indexes etc.) and really fast. I like external tables a lot. **What do you dislike about IBM Netezza Performance Server?** Lack of anyy oficcial SQL client (Oravle have SQL Developer etc.) **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** I use netteza to traform data for reporting - preparing data to BI tools like Oracle bussiness intelegience and custom python crafted email reporting ### 6. Django and Netezza are efficient platforms for business intelligence reporting **Rating:** 4.0/5.0 stars **Reviewed by:** Stalin A. | Master's Professor BigData-Data Science, Mid-Market (51-1000 emp.) **Reviewed Date:** May 15, 2023 **What do you like best about IBM Netezza Performance Server?** Development of reports with low query times thus avoiding the construction of information cubes **What do you dislike about IBM Netezza Performance Server?** When there are a few million records, you do not see the decrease in query times **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Solved the problem of high query times in reports developed with python without increasing hardware capacities or doing manual grooming tasks ### 7. IBM NETEZZA a good datawarehouse tool **Rating:** 4.0/5.0 stars **Reviewed by:** Aditi B. | Senior Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2022 **What do you like best about IBM Netezza Performance Server?** IBM Netezza is a good datawarehouse tool and it has better performance. **What do you dislike about IBM Netezza Performance Server?** Analytics functions can be more improved. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** It is very good tool for datawarehouse solutions ### 8. IBM Netezza a highly optimised SQL data warehouse **Rating:** 4.0/5.0 stars **Reviewed by:** Saurabh G. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 20, 2022 **What do you like best about IBM Netezza Performance Server?** Hight performance sql tool, easy to use and work **What do you dislike about IBM Netezza Performance Server?** Interface can be improved Analytics operations can made better **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** IBM Netezza is a good data warehousing platform ### 9. Experience is Awesome On All 3 Family Netezza Systems **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** July 21, 2021 **What do you like best about IBM Netezza Performance Server?** 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. **What do you dislike about IBM Netezza Performance Server?** 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 **Recommendations to others considering IBM Netezza Performance Server:** Netezza Mako system is a powerful system, but IBM is moving out of support for these systems by June 2023 and bringing a new Performance system as a Netezza replacement. Go with new IBM Performance appliance POC before going LIVE **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Business queries that are critical to any business are getting the data in few seconds ### 10. Good Cloud DataWarehouse **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2022 **What do you like best about IBM Netezza Performance Server?** The speed and reliable data warehouse. The server is easy to maintain and requires minimal support activity **What do you dislike about IBM Netezza Performance Server?** There are already service providers for Datawarehouseing like Snowflake, AWS. Migration could be smoother. **Recommendations to others considering IBM Netezza Performance Server:** Good to use this for high-performance Data warehouse and analytics with great support from IBM **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** We are trying to build a Data warehouse solution that will help data scientists to analyze the data faster.IBM Netezza Performance provides great reliability for Warehouse ### 11. Netezza Performance Server for Dashboard Application **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** October 05, 2021 **What do you like best about IBM Netezza Performance Server?** 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 **What do you dislike about IBM Netezza Performance Server?** Disk Replacement is frequently coming nowadays, which requires some attention from IBM. Cloud Solution for Netezza needs to rollout **Recommendations to others considering IBM Netezza Performance Server:** Already the product is EOL now. So you need to Develop something and not for Production, then you can use Netezza **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** We are using Netezza for both Data Processing and Application Dashboard powering ### 12. IBM Netezza Performance Server Review **Rating:** 3.5/5.0 stars **Reviewed by:** D Guru P. | Application Development specialist, Enterprise (> 1000 emp.) **Reviewed Date:** January 11, 2021 ### 13. Great tool for high-performance data warehouse appliances and advanced analytics applications **Rating:** 4.0/5.0 stars **Reviewed by:** Raunak S. | Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** June 11, 2021 **What do you like best about IBM Netezza Performance Server?** 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. **What do you dislike about IBM Netezza Performance Server?** Performance tuning features are a little bit limited that I feel after using the application. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** It helped me handle the entire data warehouse of my client, which included the various kind of data stored in different types of tables with varying data types. Easy to use and very much UI is user-friendly. ### 14. Working with IBM Neteeza **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** June 13, 2021 **What do you like best about IBM Netezza Performance Server?** 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. **What do you dislike about IBM Netezza Performance Server?** 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. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** We use this as our data warehousing application to collate user data from various cross functional databases and based on that we are predicting customer behavior in the insurance sector. ### 15. Used IBM Netezza as this was the platform used by the client for their Business reports **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** June 19, 2020 **What do you like best about IBM Netezza Performance Server?** 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. **What do you dislike about IBM Netezza Performance Server?** 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. **Recommendations to others considering IBM Netezza Performance Server:** Keep a note of important tables that you frequently use for your data analysis. This will save time searching for relevant variables. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Used IBM Netezza to extract various reports and adhoc analysis of data for delivering Business Insights to the customer. Most of the time have found it easy to use and handle various data variables. ### 16. Good performance overall ; easy to implement, easy to operate. **Rating:** 4.0/5.0 stars **Reviewed by:** Mukul J. | Assistant Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2020 **What do you like best about IBM Netezza Performance Server?** Overall Comment:"Solid solution - well positioned among close competitors. Good performance overall ; easy to implement, easy to operate." **What do you dislike about IBM Netezza Performance Server?** 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 **Recommendations to others considering IBM Netezza Performance Server:** Try it in evaluation period better. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** 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. ### 17. Performance improvement **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** May 21, 2020 **What do you like best about IBM Netezza Performance Server?** Netezza Performance Server is delivered with the same load and go ease of use customers expect. No indexing or tuning is required, ensuring that the entire set of available nz utilities remains unchanged. **What do you dislike about IBM Netezza Performance Server?** Cost is high for medium sized companies We cannot use some of the functions like pivot etc **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Fast queries and it handled large set of data. Helpful to generate reports for future analysis ### 18. Great tool,makes life of BI developers easy **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2020 **What do you like best about IBM Netezza Performance Server?** It's an easy to use tool. With a simplistic approach ,you can get all your complex tasks accomplished ina short time. **What do you dislike about IBM Netezza Performance Server?** Few shortcuts which are right now missing in the GUI if added would make this a perfect tool **Recommendations to others considering IBM Netezza Performance Server:** Highly recommended **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** I help clients provide a clear understanding of there historical data , insights to there data from which they can make some informed business decisions. ### 19. IBM Netezza Data Warehouse Usage Experience **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Broadcast Media | Enterprise (> 1000 emp.) **Reviewed Date:** April 22, 2020 **What do you like best about IBM Netezza Performance Server?** High Performance -> Ability to give robust performance with high data volume. **What do you dislike about IBM Netezza Performance Server?** Statistics Maintenance & Grooming for tables are manual work..lack of good multi-language support **Recommendations to others considering IBM Netezza Performance Server:** if you seeking for a Data-warehouse gives high performance with huge data loads go for Netezza DW **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** The Reporting platform is built with Netezza Data Warehouse. Its giving very good performance which leads to user sanctification. ### 20. Good Experience **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 27, 2020 **What do you like best about IBM Netezza Performance Server?** It helpful to load the data from various streams to warehouse **What do you dislike about IBM Netezza Performance Server?** Nothing as of now but i think processing speed can be increase a bit **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Loading data from various streams ### 21. Blazing fast read & flexible database for around 50G data **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** June 20, 2019 **What do you like best about IBM Netezza Performance Server?** Designed for faster read & proven implementation for concurrent user. Easy to install, scale up & maintain appliance. Easier to replicate databases & provide support. **What do you dislike about IBM Netezza Performance Server?** I dislike few patching tampering user group profile. Also non availability of materialized views. **Recommendations to others considering IBM Netezza Performance Server:** Faster read, easy to scale and manage is very important criteria. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Analytical journey backbone is Netezza. Benefit is faster read & multi user support. ### 22. MISO Purdata Review **Rating:** 3.5/5.0 stars **Reviewed by:** Craig W. | Lead Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2019 **What do you like best about IBM Netezza Performance Server?** When used properly it is very fast for analytics on large amounts of data. The system is reliable and is highly available. **What do you dislike about IBM Netezza Performance Server?** At times, disk failure rate (2 or 3 a month sometimes) seems excessive, but it is fault tolerant enough to handle the failures **Recommendations to others considering IBM Netezza Performance Server:** PureData system are now converting to IBM IAS for Data Analytics **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Business reporting and data analytics. Loads and Reports that ran in hours before take much less time ### 23. Netezza for Analytics and Campaign Management data **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** February 12, 2019 **What do you like best about IBM Netezza Performance Server?** The horsepower and flexibility. Model score processing is faster, ETL onto the environment is easy and can build any type of data model needed to support campaign. **What do you dislike about IBM Netezza Performance Server?** It is good for analytics but still trying to figure out how it works best for campaigning. Started using with limited knowledge so trying to understanding differences between a DB2 and Netezza. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Using for outbound communications in order to inform members of benefits and services to our members. ### 24. Netezza **Rating:** 3.5/5.0 stars **Reviewed by:** Trey D. | IT Supervisor, Data Services, Mid-Market (51-1000 emp.) **Reviewed Date:** February 12, 2019 **What do you like best about IBM Netezza Performance Server?** Performance on netezza is the best thing our users like. **What do you dislike about IBM Netezza Performance Server?** It would be nice to add storage **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** data discovery, historical data repository ### 25. More intuitive analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** February 12, 2019 **What do you like best about IBM Netezza Performance Server?** Snappier navigation and more intuitive analytics **What do you dislike about IBM Netezza Performance Server?** training but it seems like it has improved with this latest version **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** helping business units analyze their data and see their basic kpis ### 26. Very Scalable **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** February 12, 2019 **What do you like best about IBM Netezza Performance Server?** Easier performance improvement by adding more appliances **What do you dislike about IBM Netezza Performance Server?** taking long downtime for addition of appliances and rebuilding it **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** maintaining book of records and provding analytical platform ### 27. IBM QUERY **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** April 12, 2018 **What do you like best about IBM Netezza Performance Server?** I use this application everyday for writing sql queries and it a very friendly and helpful tool because of its easy to use features and ability to connect to multiple instances of schema. **What do you dislike about IBM Netezza Performance Server?** Look and Feel should be improved. Previous sessions are not being stored sometimes. **Recommendations to others considering IBM Netezza Performance Server:** I personally use this tool and found it to be very helpful especially for people who query tables to retrieve data for validation and analyses. This is similar to Toad and other query based tools but definitely meets my needs. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** I'm able to validate data in multiple environments between the source and target tables. I'm able to use the queries and trying to avoid much work in MS Excel. ### 28. Great MPP Data Warehouse Appliance **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Gambling & Casinos | Enterprise (> 1000 emp.) **Reviewed Date:** October 18, 2016 **What do you like best about IBM Netezza Performance Server?** I like that Netezza is an old player in the DW world. They were one of the first to come out with a commercially available Data Warehouse Appliance. They've also made great improvements along the way. The sheer processing power of the appliance makes most jobs run without any issues. The analytic functions provided have also proven to be very useful. It is also easy to set up a distribution key so you know how the data is being sharded across all the nodes. Another thing I like are the CLI tools. NZLOAD for example has been an integral part of our near real time load process. NZMIGRATE has proven to be a great database copy tool. I could go on, but there are definitely some great tools included with this product. I would recommend to at least speak with an IBM representative to see if this Appliance is right for you. **What do you dislike about IBM Netezza Performance Server?** Sometimes the SQL language Netezza uses (it's a PostreSQL variant) can get a little annoying. But if you're used to PostreSQL you can certainly get up and running. **Recommendations to others considering IBM Netezza Performance Server:** Knit a tight relationship with IBM Netezza support. They've been really helpful in proposing solutions and upgrades. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Most of the data that sits on our Netezza Appliance is an Operational Data Store that feeds Data Marts for our Marketing department. The end users then use Cognos to consume the data. This has proven to be a good solution. They're able to access their data quickly and in an efficient manner. ### 29. An HPC appliance for a full stack database **Rating:** 4.0/5.0 stars **Reviewed by:** Hossein S. | Research Assistant, Higher Education, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2015 **What do you like best about IBM Netezza Performance Server?** I was introduced to Netezza in a research project in Dalhousie university a couple of months ago. Since then, I believe Netezza is definitely one of the best machines for big data analytics. Having well designed HPC techniques in any single part, I found it well tuned, fast and easy to use. There are some good and free client applications available to manage the server and run scripts. One thing which is amazing is its built-in DBA that work as a 24-7 support team. **What do you dislike about IBM Netezza Performance Server?** Unlike its well written official documents, there are almost no active user community on Netezza topics. Having said that, it is sometimes very tough to find a solution to an obvious question. I checked only three different client management tools to work with it. They shared one thing in common that is all of them provide something that the other two doesn't provide. This results to have all of them and work on different client tools to have everything done. In addition, the official IBM client that comes with Netezza can be said to be the worst of them. In addition, lack of demos or tutorials on very common problems is another issue that I think should be added to Netezza official document. **Recommendations to others considering IBM Netezza Performance Server:** Having an intelligent built-in DBA, you don't need to employ a lot of DBAs! If you can afford it, it's a good choice. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** I started to work with Netezza in a research project in Dalhousie University. Because of confidentiality I can't talk about the details but in a nutshell, there was a human and AIS trajectory mining project on huge datasets in which we used Netezza. ### 30. Very good product... Opportunity to become better **Rating:** 4.0/5.0 stars **Reviewed by:** Bhuvaneshor A. | Sr BI Architect - Reporting, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** April 13, 2015 **What do you like best about IBM Netezza Performance Server?** Less Administration Required Easy to move data and fetch data **What do you dislike about IBM Netezza Performance Server?** Since this is unix based less user interface available to manage. Need better managements tools with intuitive user interface. Provide more utilities to manage performance and reporting about performance. Need utility to migration of code and data. Difficulty finding material about Natezza or books and best practice related documents Finding resources developers and dba is very hard In Nashville are you going to do some conference? **Recommendations to others considering IBM Netezza Performance Server:** There should be forum where Nashville TN Natezza user group should meet in person and share their knowledge **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** It is fast and works great with cognos. We are providing dashboards to business users and they are they are rendering data very fast Less administration and maintenance. ### 31. Very fast if you follow the best practices and understand the architecture **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** April 20, 2015 **What do you like best about IBM Netezza Performance Server?** The MPP (Massively Parallel Processing) architecture is very strong feature of this appliance which helps in running ugly time consuming warehouse report queries very fast - These would have taken forever to run on other RDBMS databases. The key is the fact that most of the unwanted data is filtered (projection and restriction) as close to the disk as possible. Standard SQL queries can be used with the appliance which makes it easier for porting existing applications and avoid a new learning curve in that front. If the best practices are followed in terms of distribution keys, data-types etc. you can get real good performance boost. **What do you dislike about IBM Netezza Performance Server?** Since this is an appliance, it has many hardware components inside and we have experienced lots of sporadic hardware failures - we are then at the mercy of IBM to replace them (Scheduling, webX, field Engg) which really reflects on the SLA. Many companies have complained about the Moose disks (bad batch of disks) which had to be completely replaced. For small shops this could be really inconvenient. There aren't enough active user community for Netezza and so it gets very difficult sometimes. You again would need to open a ticket with IBM and get understanding of what it is (eg - SEU single bit vs Multi bit error) and get some documentation on the issues. Also dislike the fact that the catalog backup pauses the system. (Understand that the catalog is in the host file system) But if IBM can allow a hot catalog backup, that would be very useful. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** We use Netezza primarily for doing analytic's - this is used for doing market research and running campaigns using various tools. ### 32. Impressively fast data warehousing appliance **Rating:** 4.0/5.0 stars **Reviewed by:** Ramakant S. | Data Warehouse Specialist, Consumer Services, Mid-Market (51-1000 emp.) **Reviewed Date:** April 16, 2015 **What do you like best about IBM Netezza Performance Server?** Lightning fast performance even with half of Terra byte Size of Tables Very fast loading and offloading of Data Faster Backup and restore **What do you dislike about IBM Netezza Performance Server?** Keys are not enforced Small bugs. i.e. Different SPU may have different system Time resulting into different time stamps while loading data into tables or in similar use cases Database generated surrogate keys are not in Order - although it doesn't matter much Slow Updates Costly Lack of maturity observed at some occasions where it went down due to silly reasons- i.e Query getting queued up **Recommendations to others considering IBM Netezza Performance Server:** It is costly but worth it. You may ignore few flaws of MPP architecture once you get the benifits of performance. Also teh administration is easy. Say, most of the things are handled by IBM support team. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Business take: Using as data-warehouse for reporting and analytics purpose. Needed Nightly Batch load to finish quicker and making the data ready for Business use as soon as possible across different timezones Benefits: The Nightly Load has drastically reduced Reporting layer became faster Able to throw Complex Algorithm to Database ### 33. Performance beast as long as you KISS it **Rating:** 3.5/5.0 stars **Reviewed by:** Milind O. | VP of Data Warehousing / BI, Financial Services, Mid-Market (51-1000 emp.) **Reviewed Date:** April 14, 2015 **What do you like best about IBM Netezza Performance Server?** The hardware platform approach surely is the core processing power behind Netezza. The ability to run standard SQL queries is a huge plus as this helps development and eliminates yet another language learning curve. With multi server architecture the performance improvements are easily realized. **What do you dislike about IBM Netezza Performance Server?** The performance of the system seems to break down with implementation of views, especially layers of views. The appliance is designed around table joins and so I think its best to avoid views or at least keep them non nested. That means creating more tables and more ETL. Any table once organized and distributed on particular set of columns only those queries will see advantage, so if you have a huge variety of queries against that table then not all of them will see improvements. Another pain was disk failures and the fact that IBM certified technician has to come to replace the disks every time. I was just surprised by the rate of failures! **Recommendations to others considering IBM Netezza Performance Server:** Definitely stay away from creating views especially nested views, do more ETL and load more tables! **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** We were migrating an overnight batch system that took hours to produce reports onto a faster more robust platform. The entire process was now much faster and data capture and data consumption were granular and we had several batch running constantly , thus resulting in reports reflecting data within minutes rather than next day ### 34. Raw speed opens up new possibilities for dev & testing, but lack of flexibility can cause problems **Rating:** 4.0/5.0 stars **Reviewed by:** John H. | Associate Director - Enterprise Data Warehouse, Financial Services, Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2015 **What do you like best about IBM Netezza Performance Server?** The raw speed of the system allows for a development process not typically undertaken. For example, it's possible to run full performance testing as you unit test. You can also create tables that are much larger than you would make in a typical database (eg storing current and archive rows in the same tables). The simplicity of the system allows for minimal maintenance. DBA involvement can be next to zero. **What do you dislike about IBM Netezza Performance Server?** The simplicity of the system can also cause issues in mixed use cases. In other databases, you also have the ability to improve performance by multiple means, such as partitioning, indexing, allocating server hardware, etc. Netezza essentially has only two ways--as far as physical architecture goes--to handle performance: sorting data and distributing data. Sorting data is done directly in the table, avoiding the need for clustered indexes. But that's only helpful if the query you run utilizes that sort. For instance, if you sort on date by making the Date field the ORGANIZE BY key, any query that doesn't utilize Date in the WHERE clause will have to tablescan. You can create materialized views that essentially act like indexes, but you can't use both MVs and ORGANIZE BY keys. In other words, if you use even one MV to sort, you can't force-sort the data in the table unless you actually reload the data with an ORDER BY clause in the INSERT statement. The problem with the MVs is that even though they act like an index, you have to refresh them like a typical MV in order to sort any new data. In a system that is loaded or updated intraday, that can cause problems. Distribution has two components that can sometimes be at odds with each other: evenly hashing the data to share workload and colocating data for joins. But if the column that makes sense to distribute on for colocation purposes doesn't evenly distribute the data, you will be forced to make a compromise on one for the sake of the other. Furthermore, in a star schema, you can colocate the fact table's foreign key with a dimension's primary key, but that is best used if you query with a parameter on that dimension in the WHERE clause. If you run a query that can't filter on that dimension, the distribution key might not help you. Also, you can only ever pick one dimension to colocate with the fact. Choosing a multi-column distribution of the fact based on multiple dimension keys does not colocate the fact with _each_ dimension. It instead distributes the fact with a hash key based on the concatenated combination of the values of the multi-column distribution key (ie the fact will not be colocated with _any_ dimension). Also, the fact that Netezza has not come out with in-memory or columnar options makes me wonder if the architecture of the appliance even allows for such possibilities. In other words, the lack of flexibility might be cropping up again if the nature of the appliance doesn't allow for such varied functionality. **Recommendations to others considering IBM Netezza Performance Server:** If you can design a system that makes sure to take advantage of Netezza's strengths, then I'd say buy it. But keep in mind that the lack of flexibility of the system means you might lack flexibility in your design in the future. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** We used Netezza to perform in-database transformation processes in near-real time while simultaneously allowing user queries. The lack of traditional locking for WRITE/READ combinations allows this to work quite well. ### 35. Great Engineering machine for DW **Rating:** 4.0/5.0 stars **Reviewed by:** Jonghun L. | Database Administrator, Apparel & Fashion, Enterprise (> 1000 emp.) **Reviewed Date:** April 15, 2015 **What do you like best about IBM Netezza Performance Server?** First of all, Netezza requires minimum DBA administration. It means it can maintain with less sys and dba resources. Second, it has nothing share disk resource nothing like Oracle shared storage. It has own architecture and algorithm to move data. And it is not using index at all. So called "Zone mapping" it help a lot for heavy query from the BI users. **What do you dislike about IBM Netezza Performance Server?** Our company Netezza was not actually built for real time replication. I have to spend a lot of time to fix this issue so called CDC. **Recommendations to others considering IBM Netezza Performance Server:** I recommend this machine to any BI system for DW. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Netezza is built for DW. And it can be used bulk load. It compared to Oracle and MS DB. It reduced the time to load the data compare to both DBs. Great machine for DW. ### 36. Awesome for Data Warehouse. Has its' own quirks. On the whole a thumbs up. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** April 16, 2015 **What do you like best about IBM Netezza Performance Server?** Blazingly fast for Queries. Very little maintenance, hence needs minimal support from DBA. **What do you dislike about IBM Netezza Performance Server?** Concurrency - performance dips with number of concurrent queries. If more than 48 queries concurrently, it ques up. Scalability - If your data increases, you need to go for a bigger appliance. Cannot add incrementally Backup and Replication :-( Some kinds of Correlated Queries not supported **Recommendations to others considering IBM Netezza Performance Server:** Have a strong Technical Team who understands Netezza. We learnt it the hard way. Netezza is awesome for some problems, average for some and sucks out right for some. **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Using it for the Enterprise Data Warehouse. Currently servicing Finance, Store Operations and Supply Chain groups using only one appliance. Queries (Reports) are faster, this has its own problem(s). Users want more complicated reports. Business Problems Solved: Allocation, Planning, Store Operations, Inventory Control, Sales Forecasting etc. Benefits: Business Users can simulate complex models rapidly. ### 37. ETL using Netezza as a data source **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** August 05, 2015 **What do you like best about IBM Netezza Performance Server?** Immense time to value Low administrative costs Great hardware compression capabilities Scalability **What do you dislike about IBM Netezza Performance Server?** Load utility not as fast as competition Large overhead for conversions from an existing implementation to Netezza (largely due to lack of indexes) **Recommendations to others considering IBM Netezza Performance Server:** Terrific hardware compression abilities **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** Used Netezza as the primary data warehouse. Used IBM DB2 to complement OLTP systems to complement the NEtezza data warehouse. ### 38. Great to work **Rating:** 3.5/5.0 stars **Reviewed by:** Prasanna M. | Senior Software Engineer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** April 09, 2015 **What do you like best about IBM Netezza Performance Server?** Performance, archietecture and flexibility **What do you dislike about IBM Netezza Performance Server?** Limitations on application integrity with SAP systems. **Recommendations to others considering IBM Netezza Performance Server:** NA **What problems is IBM Netezza Performance Server solving and how is that benefiting you?** application integrity with SAP HANA ## IBM Netezza Performance Server Discussions - [What is IBM Netezza Performance Server used for?](https://www.g2.com/discussions/what-is-ibm-netezza-performance-server-used-for) - [What is IBM PureData?](https://www.g2.com/discussions/what-is-ibm-puredata) - [What is netezza used for?](https://www.g2.com/discussions/what-is-netezza-used-for) - [Is Netezza end of life?](https://www.g2.com/discussions/is-netezza-end-of-life) - [What is IBM PDA?](https://www.g2.com/discussions/what-is-ibm-pda) - [View IBM Netezza Performance Server pricing details and edition comparison](https://www.g2.com/products/ibm-netezza-performance-server/reviews?filters%5Bnps_score%5D%5B%5D=4§ion=pricing&secure%5Bexpires_at%5D=2026-08-09+08%3A52%3A14+-0500&secure%5Bsession_id%5D=384d67bb-f94e-4744-abd7-abc2ca6b8f81&secure%5Btoken%5D=5459ea5b7e41ee6af8737ea4fbb0f87440851e658cbdc53cade1deaf158e5200&format=llm_user) ## IBM Netezza Performance Server Features **Administration** - Database Management - Access Control - Data Security - Remote Access/Control - Version Control - Remote Monitoring & Management - Capacity Management - Configuration Management - File Management - Compliance Management - Service Level Agreement (SLA) Management - Namespace Management - Access Controls/Permissions **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics - ETL - Extract Transfer Load - Data Capture and Transfer - Real-Time Analytics - Reporting/Analytics **Federation** - Architecture - Provisioning - Orchestration - API / Integrations - Virtual Machine Provisioning - API - Third-Party Integrations **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Transformation** - Data Visualization - Application Performance - Data Modeling **Deployment** - On-Premise - Cloud **Additional Functionality** - Real-Time Reporting - Real-Time Monitoring - Two-Factor Authentication - Virtual Machine Encryption - Backup and Recovery - File Transfer - Server Monitoring - Secure Data Storage - AI Copilot - Data Migration - Virtual Machine Monitoring - Load Balancing - Remote Update/Installation - Archiving & Retention - Visual Analytics - Virtual Machine Snapshots - Role-Based Permissions - HIPAA Compliant - Performance Monitoring - Activity Dashboard - Desktop/Application Virtualization - Event Logs - Single Sign On - Generative AI - Disaster Recovery - Alerts/Escalation - Automatic Backup - Reporting/Analytics **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization - Generative AI **Additional Functionality** - Parallel Processing - Ad hoc Analysis - Multiple Data Sources - API - In-Database Processing - Monitoring - Real-Time Reporting - Data Synchronization - Real-Time Monitoring - Data Connectors - Performance Metrics - Ad hoc Reporting - Alerts/Notifications - Access Controls/Permissions - Drag & Drop - Data Visualization - Data Import/Export - Match & Merge - Data Transformation - Secure Data Storage - Data Extraction - AI Copilot - Customizable Reports - Activity Dashboard - Data Migration - In-Memory Processing - Data Mapping ## Top IBM Netezza Performance Server Alternatives - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (371 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (713 reviews) - [Oracle Exadata Cloud Service](https://www.g2.com/products/oracle-exadata-cloud-service/reviews) - 4.4/5.0 (40 reviews)