Lead Oracle DBA | IBM Neteeza Admin | Consultant at Capgemini
Real User
Top 10
2023-08-16T07:06:01Z
Aug 16, 2023
The solution's maintenance is quite easy. One person is enough to maintain the solution. If you are using PostgreSQL as a database solution, then using IBM Netezza Performance Server is the logical choice since it is based on open-source Postgres. However, if you are using Oracle, data conversion can be tricky. So, in that case, you want to go ahead with Exadata. Overall, I rate IBM Netezza Performance Server a seven out of ten.
Account Executive at a insurance company with 10,001+ employees
User
2021-05-14T18:51:12Z
May 14, 2021
We looked at performance server to replace our MAKO Appliances IPS is really NPS 7.2. Concurrency was still set at 48. Performance server didn't make it to our POC.
General Manager-Business Analytics and Decison Systems at a retailer with 10,001+ employees
Real User
2020-08-12T07:25:38Z
Aug 12, 2020
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.
Senior Manager - Data Quality and Governance with 1,001-5,000 employees
Real User
2018-12-10T08:29:00Z
Dec 10, 2018
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.
Database Admin. Manager at a financial services firm with 1,001-5,000 employees
Real User
2018-08-16T08:28:00Z
Aug 16, 2018
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.
Technical Lead at a financial services firm with 51-200 employees
Real User
2018-08-12T06:33:00Z
Aug 12, 2018
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.
Business Intelligence Consultant at a tech services company with 51-200 employees
Consultant
2015-11-14T21:08:00Z
Nov 14, 2015
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.
What is a data warehouse? A data warehouse, sometimes categorized as an Enterprise Data Warehouse, (DW or DWH) is a data analysis and reporting system. Data warehouses are fundamental storehouses of integrated data from single, or multiple sources, storing historical or current data in one location where data is utilized, creating reports for designated Enterprise users.
A DW is considered an integral component of business intelligence and describes a system used to analyze an...
The solution's maintenance is quite easy. One person is enough to maintain the solution. If you are using PostgreSQL as a database solution, then using IBM Netezza Performance Server is the logical choice since it is based on open-source Postgres. However, if you are using Oracle, data conversion can be tricky. So, in that case, you want to go ahead with Exadata. Overall, I rate IBM Netezza Performance Server a seven out of ten.
I rate IBM Netezza Performance Server a seven out of ten.
We looked at performance server to replace our MAKO Appliances IPS is really NPS 7.2. Concurrency was still set at 48. Performance server didn't make it to our POC.
Take a look at Snowflake and/or Yellowbrick
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.
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.
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.
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.
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.