Technical Lead at a financial services firm with 51-200 employees
Real User
2018-08-12T06:33:00Z
Aug 12, 2018
It really serves its purpose. It meets the need for performance, it meets the need for robustness, and it also serves as a perfect data warehousing appliance. The only issue is that it's not expandable. The new versions of Netezza, they are expandable. They can be on-prem and on the cloud like dashDB from IBM. It replaces the previous Netezza versions. We are currently on Mako because TwinFin support is going in 2019. Maybe in the next couple of years, we will be replacing Netezza with Redshift.
Business Intelligence Consultant at a tech services company with 51-200 employees
Consultant
2015-11-14T21:08:00Z
Nov 14, 2015
Concurrent Queries, with this model (1000-3), we had a very big problem using front-end tools connected on it. When using a dashboard tool to use data directly from the database, I had a big problem with queries being queued and stopped running. Looking at the manual I read that Netezza has a limited number or concurrent process.
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...
Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.
IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available.
This is an appliance-based product with limited capability. It has all the horse-power that one can imagine and can handle all workloads.
They should make it work better in a multi-user context. This solution works, but not for the workload we have.
Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints.
It really serves its purpose. It meets the need for performance, it meets the need for robustness, and it also serves as a perfect data warehousing appliance. The only issue is that it's not expandable. The new versions of Netezza, they are expandable. They can be on-prem and on the cloud like dashDB from IBM. It replaces the previous Netezza versions. We are currently on Mako because TwinFin support is going in 2019. Maybe in the next couple of years, we will be replacing Netezza with Redshift.
Concurrent Queries, with this model (1000-3), we had a very big problem using front-end tools connected on it. When using a dashboard tool to use data directly from the database, I had a big problem with queries being queued and stopped running. Looking at the manual I read that Netezza has a limited number or concurrent process.