The ability to support a lot of complex queries to analyze rather big data sets at the same time is a valuable feature for us.
BI/BA Consultant at a financial services firm with 1,001-5,000 employees
It is used in several key areas such as customer analytics, pricing, predictable analytics and forecasting, and reporting etc.
What is most valuable?
How has it helped my organization?
Netezza appliances are used on several key areas such as customer analytics, pricing, predictable analytics and forecasting, and reporting etc. The platform is really versatile and cost effective.
What needs improvement?
Data lineage on column or even object level does not exist, therefore external applications have to be used
For how long have I used the solution?
We've been using it for three to four years.
Buyer's Guide
IBM Netezza Performance Server
November 2024
Learn what your peers think about IBM Netezza Performance Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
831,881 professionals have used our research since 2012.
What was my experience with deployment of the solution?
There were no issues deploying it.
What do I think about the stability of the solution?
It is generally a reliable and stable platform.
What do I think about the scalability of the solution?
There were no issues scaling it.
How are customer service and support?
Customer Service:
As a developer I am not dealing with IBM customer service related activities.
Technical Support:As a developer I am not dealing with IBM customer service related activities
Which solution did I use previously and why did I switch?
No other solution was used previously.
What about the implementation team?
I was not part of the initial set up but I know that the main challenge was to set up IBM CDC to transfer data to the Netezza appliance
Which other solutions did I evaluate?
No other solutions were looked at.
Disclosure: My company has a business relationship with this vendor other than being a customer: IBM is one of our partners.
Member of the Board of Directors at a tech services company with 51-200 employees
It has integration with Linux-based ETL and data streaming technologies. It is not designed for transactional systems.
What is most valuable?
- Ease of use
- Lack of performance problems for analytics and massive data systems
- Integration with Linux-based ETL and data streaming technologies
- Integration with distributed computing platforms
How has it helped my organization?
It has been the primary driving technology behind the corporate wide transition to Netezza as a standard data platform. A whole ecosystem is beginning to develop around the product.
What needs improvement?
It is not designed for transactional systems. Transactional systems that require frequent updates, deletes, etc should use a different solution.
What do I think about the stability of the solution?
Netezza does not perform well with a significant volume of individual record operations. Netezza is designed specifically for set based operations.
What do I think about the scalability of the solution?
Netezza does not perform well with a significant volume of individual record operations. Netezza is designed specifically for set based operations.
Which solution did I use previously and why did I switch?
The appliance is installed and maintained by vendor.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
IBM Netezza Performance Server
November 2024
Learn what your peers think about IBM Netezza Performance Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
831,881 professionals have used our research since 2012.
Technology Consultant (Netezza/Big Data) at a tech vendor with 1,001-5,000 employees
The cost-based analysis of query by optimization, it makes query execution faster and provides enough scope to DBA to improve queries.
What is most valuable?
With a field-programmable gate array, it has the capabilities to do arithmetic calculations at memory level. Also, the cost-based analysis of query by optimization, it makes query execution faster and provides enough scope to DBA to improve queries.
What needs improvement?
In my opinion the product is the best for the purpose it has been built.
For how long have I used the solution?
I've used it for six years.
What was my experience with deployment of the solution?
Not much, IBM guys are quite professional and ready to help with every bit and piece.
What do I think about the stability of the solution?
Not much, IBM guys are quite professional and ready to help with every bit and piece.
What do I think about the scalability of the solution?
Not much, IBM guys are quite professional and ready to help with every bit and piece.
How are customer service and technical support?
Customer Service:
The level of customer service is good.
Technical Support:The level of technical support is good.
Which solution did I use previously and why did I switch?
I've never used any other solutions.
How was the initial setup?
Initial setup is pretty straightforward, as IBM provides ramp-up training through in-house training and assigns a technical account manager to make faster resolution of queries.
What about the implementation team?
Both ways, as the box got setup by us and IBM provided a huge set of documents, which made life easier.
Which other solutions did I evaluate?
Before buying the physical product from IBM, there is an option to use the solution in the cloud to perform a POC and get your stats ready with actual data for better analysis of your investment.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Solution Architect at a comms service provider with 11-50 employees
Billions of data are processed within an optimal amount of time, and it supports almost real-time analytics.
What is most valuable?
- Scalability
- User friendly
- Always innovative
How has it helped my organization?
Billions of data are processed within an optimal amount of time, and it supports almost real-time analytics. This helps the executives to define their strategy for further expansion and identify potential opportunities with informed decisions.
What needs improvement?
It has already integrated with Big Data Hadoop; however, integration with XML is still not there for nzload utility.If nzlad supports XML files along with flat flies ,it will give them an edge over other MPP Architecture.
For how long have I used the solution?
I've used it for eight years.
What was my experience with deployment of the solution?
No issues encountered.
What do I think about the stability of the solution?
No issues encountered.
What do I think about the scalability of the solution?
No issues encountered.
How are customer service and technical support?
It's the best.
Which solution did I use previously and why did I switch?
We used other MPP architecture solutions such as Microsoft PDW and Teradata. However, Netezza has an edge as it is convenient to use and it doesn't need a database administrator to perform a successful implementation of a Netezza migration from any RDBMS.
How was the initial setup?
The initial setup is straightforward as it is an appliance. IBM's technical support team takes care of the entire setup process, and you don't need an expert in Netezza to perform the implementation.
What about the implementation team?
We did it in-collaboration with IBM, and in my opinion, this is the best way to embrace new technology. Once you gradually build up your capability in new technology, you should then take control of it with your in-house talented experts.
What was our ROI?
We had a significant ROI as business increased multi-fold with such a scalable solution.
What's my experience with pricing, setup cost, and licensing?
Compared to other MPP's, Netezza's pricing is quite reasonable considering long term business expansion with low maintenance cost.
What other advice do I have?
Any potential customer who has an inclination towards large scale analytics, should consider Netezza as an option. This not only gives a faster response, but you can also save on resource cost compared to other MPP's. Netezza's maintenance cost is quite low and this will give you an edge for long term revenue growth.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Hadoop Engineer with 1,001-5,000 employees
The cross-database writing function allows users to run commands in the block as single execution.
Valuable Features:
Cross-database writing and more UDFs.
Netezza NPS 7.1 has added a feature of SET CATALOG
This also allows users to run GROOM, GENERATE STATISTICS etc. in the block as a single execution (auto commit).
Improvements to My Organization:
Simplified development process with less administration
Disclosure: I am a real user, and this review is based on my own experience and opinions.
DBA at a financial services firm with 501-1,000 employees
With this solution, there are few things to worry about.
What is most valuable?
- Performance
- Simplicity
- Few things to worry about
How has it helped my organization?
Netezza technology has served us perfectly well. It is the server for our all BI data.
What needs improvement?
Our overall business intelligence has improved.
What was my experience with deployment of the solution?
No issues encountered.
What do I think about the stability of the solution?
No issues encountered.
What do I think about the scalability of the solution?
No issues encountered.
How are customer service and technical support?
Customer Service:
8/10.
Technical Support:8/10.
Which solution did I use previously and why did I switch?
No previous solution was used.
How was the initial setup?
It was straightforward.
What about the implementation team?
It was done by an in-house team with assistance from some IBM consultants who had very good knowledge about Netezza.
What was our ROI?
Very good. Our BI enviroment with Netezza, Cognos and Data Stage has been a great success
Which other solutions did I evaluate?
The in-house team and IBM consultants suggested the solution. There is a partnership between IBM and our corporation.
What other advice do I have?
It is a very good product. Like always, good people with good expertise will help a lot
Disclosure: My company has a business relationship with this vendor other than being a customer: Partners
QlikView Consultant at a tech services company with 11-50 employees
It has improved our management information systems and reporting capabilities.
What is most valuable?
Distribution (no index or partition), built-in analytics is a major advantange.
How has it helped my organization?
It has improved our management information systems and reporting capabilities.
What needs improvement?
It should also consider cloud based solutions.
For how long have I used the solution?
We have been using the solution for more than ten years from the 8000 series,
What do I think about the stability of the solution?
We did not encounter any issues with stability.
What do I think about the scalability of the solution?
I can't extend the storage, only up to 6x compress of data. You need to plan this when selecting the right product to buy.
How are customer service and technical support?
Netezza support is good.
Which solution did I use previously and why did I switch?
We used Oracle previously. The performance required less maintenance when comparing index and data maintenance issues.
How was the initial setup?
The setup took only a few hours with all built-in apps. It is very quick and easy to use.
What's my experience with pricing, setup cost, and licensing?
One license and one support, also cheaper compared to other products.
Which other solutions did I evaluate?
We evaluated MS SQL server.
What other advice do I have?
It is easy to use. Make sure you select the right ETL and reporting tool. Also select the right tool for the organization to hold it in the long run.
It has a compression engine and FPGA on but you should still analyze your volume of data and decide on the right model and size.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Regional Support Specialist at a financial services firm with 501-1,000 employees
It has the capacity to handle terabytes of data with query response times that are very low. Setup is complex.
What is most valuable?
Personally, I like the Compression and Partitioning features.
How has it helped my organization?
It has the capacity to handle terabytes of data with query response times that are very low. This has helped us a lot.
What needs improvement?
It’s a good product for analytical processing, but they need to conduct more seminars and hands-on training and events. They need to be showcasing the product and features to create awareness among businesses.
For how long have I used the solution?
I have been working on it for the last two-and-a-half years and now we are in process of a tech refresh. We’re moving from the old Netezza to the newer IBM Pure Data Analytics, using a quarter of the rack for Pure Data.
What was my experience with deployment of the solution?
No issues encountered with deployment.
What do I think about the stability of the solution?
No issues encountered with stability.
What do I think about the scalability of the solution?
No issues encountered with scalability.
How are customer service and technical support?
They're very good, helpful, and knowledgeable.
Which solution did I use previously and why did I switch?
It’s a complex setup.
How was the initial setup?
It was handled by the vendor as it's proprietary.
What other advice do I have?
It's fit for the purpose it's designed for. It's an analytical/hierarchical database, now in great demand, that can store plenty of data and return the results in no time for complex queries.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free IBM Netezza Performance Server Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Data WarehousePopular Comparisons
Oracle Exadata
VMware Tanzu Data Solutions
Apache Hadoop
Oracle Database Appliance
IBM Db2 Warehouse
Microsoft Analytics Platform System
IBM Integrated Analytics System
Yellowbrick Data Warehouse
Buyer's Guide
Download our free IBM Netezza Performance Server Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- How to migrate from Netezza Analytics to Netezza Performance Server?
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
- What are the main differences between Data Lake and Data Warehouse?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- What is the best data warehouse tool?
- Which Data Strategy solution have you used?
- Why is Data Warehouse important for companies?
If you are talking about when IBM comes in initially and does the setup I can see your point it is complex. If you are talking about the upgrade of the os and the dbos (database operating system) that can be fairly complex especially when you have HA (high availability) option on your server. There is a lot of things the IBM tech has to go through usually both os upgrade and then the dbos. Typically IBM will do a fail over doing the upgrade. I have watched them (through webex) during these upgrades and there are a lot of things they have to go through.
Database and table setup Netezza is about as easy as they come. There are classes that IBM offers around basic database and server care. Also a class on interpreting explain plans. There are other vendors that offer classes as well on these topics. There is plenty of material on the internet that offers some advice and help on some of these topics. There is a forum available at IBM that is available just search it up on google. The forum will occasionally offer "Enzee" (free) around Netezza and there are tons of blogs available around care and maintenance.
The biggest event that IBM Insight is available and there are many presentations and certification can be done during the conference.
Good luck