IBM Netezza Performance Server Reviews

The performance is most important to me, and it helps our ability to make business decisions quickly.

They should make it work better in a multi-user context. This solution works, but not for the workload we have.

It is stable. We use it in our data warehousing complex, and the performance is good.

The scalability is not as expected. It is shipped to you as an appliance, a black box. If you want to expand it, you have to get an extra CD,or whatever, and they come and program something int he box to release extra bits. If this were a cloud product, you could just expand and subtract as you wish. The capacity in this black box is not enough.

I would rate the tech support a five, on a scale of one to ten. It is obviously not that great. 

We had Teradata before, and I am not really sure why we switched.

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.

• The speed of the MPP platform
• The ability to load large amounts of data in very short order
• The fact that the hardware and software are designed to work together and are supported in unison by IBM

We can process through more data much faster than we could with prior technologies.

More monitoring tools would be nice. I have found no tools within the tool which help with long running query issues. I would like to see the ability of static binds so access path can be counted on.

I've been using this since 2010

There were no issues with the deployment.

Stability comes and goes. Every software upgrade removes some problems, but introduces others. None have been critical, though.

There were no issues with the scalability.

It's 7/10 as when something goes wrong within IBM, it can take quite a bit to get it straightened out including a phone call to the sales rep to light fires.

It was a straightforward set-up. You just have to install the appliance, turn it on, and you can start using.

Netezza themselves set up the machines. We implemented our business rules using a vendor team to get us up to speed on MPP processing.

We evaluated this and Greenplum. Netezza won the battle for being an appliance that is wholly supported by the vendor. Greenplum won the individual transaction battle, but it was not enough to overcome the ease of an appliance.

The most difficult time I have with people is getting them to understand that Netezza is not meant for individual transactions, but for full set processing.

• Lots of space
• Implicit compression
• High Availability with multiple redundancy

The performance has meant that we reclaimed many hours in our batch window. The ease of which we ported data onto it, the fact that it does not take a lot of administration and the overall manageability of the box have improved our company.

Ability to use constraints to enforce uniqueness would be an improvement.

We got our first Netezza box in 2004 and the Pure Data in 2014 following the acquisition by IBM.

A blade failure at the commissioning stage, but the box (and predecessors) have been extremely stable and provides us with lots of scalability.

Very good for this product. It was excellent when it was Netezza and that support seems to have continued with IBM.

Previously used DB2 LUW but this could not provide us with the performance we needed at the time. We looked at Netezza as they were trying to get a foothold in the UK and the portability of data and the speed with which it performed was incredible.

Very straightforward for Pure Data but the initial set-up was affected by the fact that we seemed to get a junior technician from IBM who was not as good as other engineers we have had.

Build a strong relationship with your technical account manager as you will be referring to them quite a lot. Could save many man hours in the long term.

I can't comment on the figures but needless to say it has been a resounding success for us.

IBM support is very good for this product. It has very few issues and it does exactly what it says on the tin. Check for the functional limitations of the logical database e.g there are no such thing as indexes/primary key constraints where you might want to force uniqueness.

We use Aginity to access Netezza database. We really like the way we can dominate the physical distribution of the data hence know how to improve the performance of the query. Netezza on its own is very fast which makes our life easier to run huge queries for analytics.

This has really helped us to improve the performance of our Data Marts and warehouses. We can run our reports very quickly. It has also improved the turn around time of business requests. 

In Aginity there should be a way to format the SQL queries. I think we can't format the query the way we can do it in Oracle editor (beautifier). Say, for example, if we are trying to get the DDL of an existing view, we lost the formatting. It's a minor issue, but important from usability point of view. Other than this, I think we are good so far with Netezza as a whole.

We have been using this product from last 5 years. 

We did not experience any issues.

We haven't had any issues.

We've not experienced any issues.

If volume is the issue, use Netezza. Nothing is better than this product.

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.

In my opinion the product is the best for the purpose it has been built.

I've used it for six years.

Not much, IBM guys are quite professional and ready to help with every bit and piece.

Not much, IBM guys are quite professional and ready to help with every bit and piece.

Not much, IBM guys are quite professional and ready to help with every bit and piece.

The level of customer service is good.

The level of technical support is good.

I've never used any other solutions.

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.

Both ways, as the box got setup by us and IBM provided a huge set of documents, which made life easier.

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.

• Scalability
• User friendly
• Always innovative

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.

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.

I've used it for eight years.

No issues encountered.

No issues encountered.

No issues encountered.

It's the best.

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.

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.

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.

We had a significant ROI as business increased multi-fold with such a scalable solution.

Compared to other MPP's, Netezza's pricing is quite reasonable considering long term business expansion with low maintenance cost.

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.

• Supports both business intelligence and advanced analytics
• Efficient even if being used by thousands of users at the same time
• Streaming architecture based on blades
• Compatible with the most popular business intelligence and analytic tools
• Standard SQL, ODBC, JDBC, and OLE DB interfaces

We had lot of POC's on data warehousing project with the help of Netezza, we have proved that it has really improved time on doing analytics

I have used this solution for more than two years

There were no issues with the deployment.

It's reliable and available, with 99.99% uptime.

There were no issues with the scalability.

Support for this product is good.

Initial set-up was straightforward.

It was done by an in-house team.

It is good product if you are choosing to go for datawarehouse business intelligence.

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.

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.

Data lineage on column or even object level does not exist, therefore external applications have to be used

We've been using it for three to four years.

There were no issues deploying it.

It is generally a reliable and stable platform.

There were no issues scaling it.

As a developer I am not dealing with IBM customer service related activities.

As a developer I am not dealing with IBM customer service related activities

No other solution was used previously.

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

No other solutions were looked at.