IBM PureData System for Analytics

(17)
3.9 out of 5 stars

IBM PureData System for Analytics is a purpose-built, standards-based data warehouse and analytics appliance that integrates database, server, storage and analytics into an easy-to-manage system. It is designed for high-speed analysis of big data volumes, scaling into the petabytes.

Work for IBM PureData System for Analytics?

Learning about Puredata?

We can help you find the solution that fits you best.

Find the Right Product

IBM PureData System for Analytics Reviews

Ask Puredata a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 25 Puredata reviews
LinkedIn Connections
Puredata review by User in Gambling & Casinos
User in Gambling & Casinos
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Great MPP Data Warehouse Appliance

What do you like best?

I like that Netezza is an old player in the DW world. They were one of the first to come out with a commercially available Data Warehouse Appliance. They've also made great improvements along the way. The sheer processing power of the appliance makes most jobs run without any issues. The analytic functions provided have also proven to be very useful. It is also easy to set up a distribution key so you know how the data is being sharded across all the nodes. Another thing I like are the CLI tools. NZLOAD for example has been an integral part of our near real time load process. NZMIGRATE has proven to be a great database copy tool. I could go on, but there are definitely some great tools included with this product. I would recommend to at least speak with an IBM representative to see if this Appliance is right for you.

What do you dislike?

Sometimes the SQL language Netezza uses (it's a PostreSQL variant) can get a little annoying. But if you're used to PostreSQL you can certainly get up and running.

Recommendations to others considering the product

Knit a tight relationship with IBM Netezza support. They've been really helpful in proposing solutions and upgrades.

What business problems are you solving with the product? What benefits have you realized?

Most of the data that sits on our Netezza Appliance is an Operational Data Store that feeds Data Marts for our Marketing department. The end users then use Cognos to consume the data. This has proven to be a good solution. They're able to access their data quickly and in an efficient manner.

Sign in to G2 Crowd to see what your connections have to say about IBM PureData System for Analytics
Headshots
Puredata review by Consultant
Consultant
Validated Reviewer
Organic
Reviewed On

IBM QUERY

What do you like best?

I use this application everyday for writing sql queries and it a very friendly and helpful tool because of its easy to use features and ability to connect to multiple instances of schema.

What do you dislike?

Look and Feel should be improved. Previous sessions are not being stored sometimes.

Recommendations to others considering the product

I personally use this tool and found it to be very helpful especially for people who query tables to retrieve data for validation and analyses. This is similar to Toad and other query based tools but definitely meets my needs.

What business problems are you solving with the product? What benefits have you realized?

I'm able to validate data in multiple environments between the source and target tables. I'm able to use the queries and trying to avoid much work in MS Excel.

What Data Warehouse solution do you use?

Thanks for letting us know!
Puredata review by <span>Hossein S.</span>
Hossein S.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

An HPC appliance for a full stack database

What do you like best?

I was introduced to Netezza in a research project in Dalhousie university a couple of months ago. Since then, I believe Netezza is definitely one of the best machines for big data analytics. Having well designed HPC techniques in any single part, I found it well tuned, fast and easy to use. There are some good and free client applications available to manage the server and run scripts.

One thing which is amazing is its built-in DBA that work as a 24-7 support team.

What do you dislike?

Unlike its well written official documents, there are almost no active user community on Netezza topics. Having said that, it is sometimes very tough to find a solution to an obvious question. I checked only three different client management tools to work with it. They shared one thing in common that is all of them provide something that the other two doesn't provide. This results to have all of them and work on different client tools to have everything done. In addition, the official IBM client that comes with Netezza can be said to be the worst of them.

In addition, lack of demos or tutorials on very common problems is another issue that I think should be added to Netezza official document.

Recommendations to others considering the product

Having an intelligent built-in DBA, you don't need to employ a lot of DBAs! If you can afford it, it's a good choice.

What business problems are you solving with the product? What benefits have you realized?

I started to work with Netezza in a research project in Dalhousie University. Because of confidentiality I can't talk about the details but in a nutshell, there was a human and AIS trajectory mining project on huge datasets in which we used Netezza.

Puredata review by <span>Kushal R.</span>
Kushal R.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Fast and High Volume data compatible

What do you like best?

Its very fast when compared to other DBs present. Aginity tool by IBM is great to work on the Netezza DB.

What do you dislike?

As you adopt this DB, you have to make few changes for your builtin functions.

Recommendations to others considering the product

If your data is huge, you can try this out

What business problems are you solving with the product? What benefits have you realized?

High speed of retrieval of data and analysis of data is easier.

Puredata review by <span>Bhuvaneshor A.</span>
Bhuvaneshor A.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

Very good product... Opportunity to become better

What do you like best?

Less Administration Required

Easy to move data and fetch data

What do you dislike?

Since this is unix based less user interface available to manage. Need better managements tools with intuitive user interface. Provide more utilities to manage performance and reporting about performance. Need utility to migration of code and data.

Difficulty finding material about Natezza or books and best practice related documents

Finding resources developers and dba is very hard

In Nashville are you going to do some conference?

Recommendations to others considering the product

There should be forum where Nashville TN Natezza user group should meet in person and share their knowledge

What business problems are you solving with the product? What benefits have you realized?

It is fast and works great with cognos.

We are providing dashboards to business users and they are they are rendering data very fast

Less administration and maintenance.

Puredata review by Administrator in Marketing and Advertising
Administrator in Marketing and Advertising
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Very fast if you follow the best practices and understand the architecture

What do you like best?

The MPP (Massively Parallel Processing) architecture is very strong feature of this appliance which helps in running ugly time consuming warehouse report queries very fast - These would have taken forever to run on other RDBMS databases. The key is the fact that most of the unwanted data is filtered (projection and restriction) as close to the disk as possible. Standard SQL queries can be used with the appliance which makes it easier for porting existing applications and avoid a new learning curve in that front.

If the best practices are followed in terms of distribution keys, data-types etc. you can get real good performance boost.

What do you dislike?

Since this is an appliance, it has many hardware components inside and we have experienced lots of sporadic hardware failures - we are then at the mercy of IBM to replace them (Scheduling, webX, field Engg) which really reflects on the SLA. Many companies have complained about the Moose disks (bad batch of disks) which had to be completely replaced. For small shops this could be really inconvenient.

There aren't enough active user community for Netezza and so it gets very difficult sometimes. You again would need to open a ticket with IBM and get understanding of what it is (eg - SEU single bit vs Multi bit error) and get some documentation on the issues.

Also dislike the fact that the catalog backup pauses the system. (Understand that the catalog is in the host file system) But if IBM can allow a hot catalog backup, that would be very useful.

What business problems are you solving with the product? What benefits have you realized?

We use Netezza primarily for doing analytic's - this is used for doing market research and running campaigns using various tools.

Learn more about IBM PureData System for Analytics

IBM PureData System for Analytics Downloads

Kate avatar
Kate from G2 Crowd

Learning about IBM PureData System for Analytics?

I can help.
* We monitor all IBM PureData System for Analytics reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.