2015-11-14T21:08:00Z

What advice do you have for others considering IBM Netezza Performance Server?


If you were talking to someone whose organization is considering IBM Netezza Performance Server, what would you say?

How would you rate it and why? Any other tips or advice?

Guest
55 Answers

author avatar
Top 20Real User

We use IBM IPS and have migrated from Netezza. I am not benchmarking cloud based data warehouses which provide a more open and rapid expandable architecture, my focus is more on organization that has tons of structured data & years of history from fragmented systems that needs to be consolidated and put under one central data warehouse with strong governance but provide rapid access for analytical purpose, business data discovery use and for rapid connectivity with dashboarding and reporting systems. Based on our use case IBM IPS is a perfect fit & my personal view weightage is 8/10 on performance but a 10/10 on compatibility with all systems & tools used with Netezza before. Almost eliminating migration risk and hidden surprises or changes to ETL's or systems. Advice would be size the cloud pak part to ensure that the ML or any advance functionality will not have a performance bottleneck going further.  

2020-08-12T07:25:38Z
author avatar
Real User

Based on first conception, do a POC, scale up to the volumes and get the vendor to prove that it can work with their requirements. Get them to scale it up, either simulate it, make sure it can actually do what it says, rather than buying beta and then get it and then find out that it doesn't actually do everything it says it does.

2018-12-10T08:29:00Z
author avatar
Real User

Get the requirements and have them finalized. Then, be very specific about the requirements that your organization needs. Based upon your requirements: * Identify whether Netezza will be suitable for your requirements. * Get the sizing right.

2018-08-16T08:28:00Z
author avatar
Real User

My client is looking towards replacing Neteeza with one of the up and coming warehousing solutions like Presto. They don't want the in-house or on-prem cost of managing that particular appliance. When everything is available on cloud, we pay less. My client develops medical products. They wanted to concentrate on the medical part, not on how to manage their IT. So they're moving towards more and more towards the cloud to replace the on-prem solution. My advice would be to fully categorize your needs. Why you need Netezza should be a specific question, because there are so many different analytic solutions and which provide performance and which are cheaper than Netezza. Until you figure out completely that you only need a PDA (pure data analytics) system, you should really look at other products and compare them. I wouldn't choose Netezza in today's world when we have Redshift, Presto, EMR, when we have Teradata, and when we have Oracle Autonomous. In today's world, you should look at these solutions first. If they don't serve your purpose, then look to Netezza. In the current world, data is the big question. Nowadays, we are receiving a lot of data. It's like the data generation has come. We have terabytes of data and it might be, in a year or so, you cross the petabyte scale. So go with a petabyte-scale solution instead of a non-expandable Netezza appliance. We are currently working on the latest Mako version. After that - Mako retires in 2024 - I don't think they have anything on Netezza. What they have is dashDB and Sailfish, which is a completely different product for IBM, but similar to Netezza. And those are expandable. Netezza is a good product in and of itself, aside from the fact it is not expandable. Overall, it's a good product but definitely has room for improvement.

2018-08-12T06:33:00Z
author avatar
Top 5Consultant

Try to find someone who had already worked with this appliance to have some tips and advices to help you to use it as better as it can. I take too long to discover the best way to make it work well. With my team, I have created a data environment using Netezza as Data warehouse solution, ODI to run the ETL process, shell script. We have now five years of data stored in the Netezza database and we distribute data to all BI Applications easily and quickly. However, it would be better if we had some useful help in the past.

2015-11-14T21:08:00Z
Find out what your peers are saying about IBM, Oracle, Micro Focus and others in Data Warehouse. Updated: October 2020.
442,194 professionals have used our research since 2012.