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.

IBM PureData System for Analytics Reviews

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

"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
Puredata review by Consultant
Consultant
Validated Reviewer
Review Source

"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 Hossein S.
Hossein S.
Validated Reviewer
Verified Current User
Review Source

"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 Kushal R.
Kushal R.
Validated Reviewer
Verified Current User
Review Source

"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 Bhuvaneshor A.
Bhuvaneshor A.
Validated Reviewer
Verified Current User
Review Source
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
Review Source

"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.

Puredata review by Ramakant S.
Ramakant S.
Validated Reviewer
Review Source

"Impressively fast data warehousing appliance"

What do you like best?

Lightning fast performance even with half of Terra byte Size of Tables

Very fast loading and offloading of Data

Faster Backup and restore

What do you dislike?

Keys are not enforced

Small bugs. i.e. Different SPU may have different system Time resulting into different time stamps while loading data into tables or in similar use cases

Database generated surrogate keys are not in Order - although it doesn't matter much

Slow Updates

Costly

Lack of maturity observed at some occasions where it went down due to silly reasons- i.e Query getting queued up

Recommendations to others considering the product

It is costly but worth it. You may ignore few flaws of MPP architecture once you get the benifits of performance. Also teh administration is easy. Say, most of the things are handled by IBM support team.

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

Business take:

Using as data-warehouse for reporting and analytics purpose. Needed Nightly Batch load to finish quicker and making the data ready for Business use as soon as possible across different timezones

Benefits:

The Nightly Load has drastically reduced

Reporting layer became faster

Able to throw Complex Algorithm to Database

Puredata review by Milind O.
Milind O.
Validated Reviewer
Review Source

"Performance beast as long as you KISS it"

What do you like best?

The hardware platform approach surely is the core processing power behind Netezza. The ability to run standard SQL queries is a huge plus as this helps development and eliminates yet another language learning curve. With multi server architecture the performance improvements are easily realized.

What do you dislike?

The performance of the system seems to break down with implementation of views, especially layers of views. The appliance is designed around table joins and so I think its best to avoid views or at least keep them non nested. That means creating more tables and more ETL. Any table once organized and distributed on particular set of columns only those queries will see advantage, so if you have a huge variety of queries against that table then not all of them will see improvements. Another pain was disk failures and the fact that IBM certified technician has to come to replace the disks every time. I was just surprised by the rate of failures!

Recommendations to others considering the product

Definitely stay away from creating views especially nested views, do more ETL and load more tables!

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

We were migrating an overnight batch system that took hours to produce reports onto a faster more robust platform. The entire process was now much faster and data capture and data consumption were granular and we had several batch running constantly , thus resulting in reports reflecting data within minutes rather than next day

Puredata review by Dustin W.
Dustin W.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Honestly, Netezza/PDA is the absolute best platform I have ever worked with as a DB and BI Developer"

What do you like best?

The lack I time I spend tuning queries and running maintenance routines is nice. However, the best thing about Netezza is its ability to chew up monster queries that would kill other RDBMS platform and spit out results quickly to my user base. Also, the cross-pollination of the Netezza Engineers with the IBM Engineers has benefited the platform a great deal in some key areas.

What do you dislike?

It is an IBM product, which means you get to deal with IBM and we know that can be a love/hate relationship. I worked with Netezza when it was still Netezza so I have just had to get used to the "classic IBM upsell". However, if you get a good Sales Engineer and then an good TAM (Technical Account Manager) most of your IBM issues with not exist.

Recommendations to others considering the product

Find a good consulting/development partner and have the POC done on their dime so make sure you get you feet wet with Netezza before you jump it head first. This will save on the upfront cost and help you development team learn the Netezza. Also, look and ask about returned POC Netezza Appliances as they can be had at reduced cost and you get a brand new box.

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

Basically, every business problem in the retail, manufacturing, merchandising, and marketing space. IBM Netezza/PDA is not a one-trick-pony like some other MPP technologies on the market.

Puredata review by Sumughan (Sumu) A.
Sumughan (Sumu) A.
Validated Reviewer
Review Source

"At Nielsen, we use Netezza as our primary reporting DB."

What do you like best?

High through put. On the fly fact calculation is very robust and returns data on huge amounts of data quickly. This helps us create and report facts directly from dis-aggregated data on the fly.

We are handling heavy volume of transaction data and pre-aggregating the facts would be prohibitively costly and almost impossible to do. Having the capability to do mass data operations on the fly is very helpful for our organization.

What do you dislike?

The max size a Netezza box can handle is pre-determined by the configuration. Meaning, it is not infinitely scalable.

Cost of the servers are too big for a small size firm.

Recommendations to others considering the product

This is a good selection if you are looking to process huge volumes of data on the fly.

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

On the fly fact calculation using dis-aggregated data. We have 1000's of facts and many dimensions at various levels of hierarchies. It is impossible for us to pre-calculate the fact values like a regular DW. So, we use Netezza to calculate the fact values on the fly and use a virtual OLAP env.

Puredata review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"I am working with this appliance from last 4 years and its amazing "

What do you like best?

If you are looking for database with high storage and parallely high performance then Netezza is best for that . Netezza is usefull for data warehouse appliances and advanced analytics applications for uses including enterprise data warehousing, business intelligence, predictive analytics and business continuity planning.

Quick Technical Support Team of IBM

What do you dislike?

You need to know better and best way to design your database . How to use organize key and distribution key to make it better and best . There is nothing in it to dislike it . One suggestion i want to give to IBM Team that make NZadmin more better than other ....

Recommendations to others considering the product

Yes

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

We need to find out better Marketing and sales strategy . So netezza play a key role in that . We use netezza fpr several ways like , reporting purpose and statistical purpose . Now we are looking to make connectivity with Hadoop

We are working on that

Puredata review by Administrator in Financial Services
Administrator in Financial Services
Validated Reviewer
Verified Current User
Review Source

"Robust MPP in BI/DW Space"

What do you like best?

Not having too much experience with other BI/DW solutions, I like that the administration of the appliance is so simple. From a design perspective, I like that there is careful consideration in obfuscating the physical and logical elements of the appliance.

What do you dislike?

My oganization has invested millions in the procurement of Netezza appliances when Netezza was its own company. Not to put IBM at fault here but with security being a mainstream focus, I was not thrilled to the idea of any organization acquiring new hardware to benefit from hardware encryption. Personally, I think there should be some legacy support to not only have a softwrae based encryption solution.

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

The "synergy between the logical and physical" aspects of the appliance make it a real pleasure to fine tune BI quries and see the improvement in real-time. Our BI queries run so much faster than when ran on a traditional OLTP transactional database.

Puredata review by John H.
John H.
Validated Reviewer
Review Source

"Raw speed opens up new possibilities for dev & testing, but lack of flexibility can cause problems"

What do you like best?

The raw speed of the system allows for a development process not typically undertaken. For example, it's possible to run full performance testing as you unit test. You can also create tables that are much larger than you would make in a typical database (eg storing current and archive rows in the same tables).

The simplicity of the system allows for minimal maintenance. DBA involvement can be next to zero.

What do you dislike?

The simplicity of the system can also cause issues in mixed use cases.

In other databases, you also have the ability to improve performance by multiple means, such as partitioning, indexing, allocating server hardware, etc. Netezza essentially has only two ways--as far as physical architecture goes--to handle performance: sorting data and distributing data.

Sorting data is done directly in the table, avoiding the need for clustered indexes. But that's only helpful if the query you run utilizes that sort. For instance, if you sort on date by making the Date field the ORGANIZE BY key, any query that doesn't utilize Date in the WHERE clause will have to tablescan. You can create materialized views that essentially act like indexes, but you can't use both MVs and ORGANIZE BY keys. In other words, if you use even one MV to sort, you can't force-sort the data in the table unless you actually reload the data with an ORDER BY clause in the INSERT statement. The problem with the MVs is that even though they act like an index, you have to refresh them like a typical MV in order to sort any new data. In a system that is loaded or updated intraday, that can cause problems.

Distribution has two components that can sometimes be at odds with each other: evenly hashing the data to share workload and colocating data for joins. But if the column that makes sense to distribute on for colocation purposes doesn't evenly distribute the data, you will be forced to make a compromise on one for the sake of the other.

Furthermore, in a star schema, you can colocate the fact table's foreign key with a dimension's primary key, but that is best used if you query with a parameter on that dimension in the WHERE clause. If you run a query that can't filter on that dimension, the distribution key might not help you. Also, you can only ever pick one dimension to colocate with the fact. Choosing a multi-column distribution of the fact based on multiple dimension keys does not colocate the fact with _each_ dimension. It instead distributes the fact with a hash key based on the concatenated combination of the values of the multi-column distribution key (ie the fact will not be colocated with _any_ dimension).

Also, the fact that Netezza has not come out with in-memory or columnar options makes me wonder if the architecture of the appliance even allows for such possibilities. In other words, the lack of flexibility might be cropping up again if the nature of the appliance doesn't allow for such varied functionality.

Recommendations to others considering the product

If you can design a system that makes sure to take advantage of Netezza's strengths, then I'd say buy it. But keep in mind that the lack of flexibility of the system means you might lack flexibility in your design in the future.

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

We used Netezza to perform in-database transformation processes in near-real time while simultaneously allowing user queries. The lack of traditional locking for WRITE/READ combinations allows this to work quite well.

Puredata review by Jonghun L.
Jonghun L.
Validated Reviewer
Review Source

"Great Engineering machine for DW"

What do you like best?

First of all, Netezza requires minimum DBA administration. It means it can maintain with less sys and dba resources.

Second, it has nothing share disk resource nothing like Oracle shared storage. It has own architecture and algorithm to move data. And it is not using index at all. So called "Zone mapping" it help a lot for heavy query from the BI users.

What do you dislike?

Our company Netezza was not actually built for real time replication. I have to spend a lot of time to fix this issue so called CDC.

Recommendations to others considering the product

I recommend this machine to any BI system for DW.

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

Netezza is built for DW. And it can be used bulk load. It compared to Oracle and MS DB. It reduced the time to load the data compare to both DBs. Great machine for DW.

Puredata review by Consultant in Higher Education
Consultant in Higher Education
Validated Reviewer
Verified Current User
Review Source

"Getting lost in the cloud"

What do you like best?

It is straightforward interface, useful when I just want to dump out data and process it in C or R.

What do you dislike?

It needs a more powerful query builder and a more updated GUI.

Recommendations to others considering the product

Our company is moving to the cloud, and we are dropping Netezza.

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

Analysis of large transactional databases. It is the front end for more detailed statistical analysis. I use other tools when I want to do more processing SQL.

Puredata review by Naresh K.
Naresh K.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Extremely fast. "

What do you like best?

Extremely fast is designed properly, even with terabytes of data. You will never go back to oracle or any traditional db's once using netezza

What do you dislike?

SQL toolkit functions is not extensive like Oracle and not many parellel processes allowed

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

handles huge volumes of data very quickly

Puredata review by Durai N.
Durai N.
Validated Reviewer
Review Source

"Netezza for High Volume Data Analysis"

What do you like best?

This is a great data warehouse appliance if you want to keep things simple and solve data problems that require scale.

What do you dislike?

Too many hardware outages (albeit hot swappable) causing constant request to IBM support.

Recommendations to others considering the product

It is certainly a platform to consider if the volume of data processing is very large (hundreds of millions of rows and beyond)

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

We used Netezza to address a problem that needed to load and process several hundred million new rows a week. Additionally, the analytical process needed multi-phased consolidation of all the data (totaling several billion rows). Netezza not only simplified the whole process but it could handle what took several months of processing down to a few hours.

Puredata review by Internal Consultant in Retail
Internal Consultant in Retail
Validated Reviewer
Review Source

"Awesome for Data Warehouse. Has its' own quirks. On the whole a thumbs up."

What do you like best?

Blazingly fast for Queries.

Very little maintenance, hence needs minimal support from DBA.

What do you dislike?

Concurrency - performance dips with number of concurrent queries. If more than 48 queries concurrently, it ques up.

Scalability - If your data increases, you need to go for a bigger appliance. Cannot add incrementally

Backup and Replication :-(

Some kinds of Correlated Queries not supported

Recommendations to others considering the product

Have a strong Technical Team who understands Netezza. We learnt it the hard way. Netezza is awesome for some problems, average for some and sucks out right for some.

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

Using it for the Enterprise Data Warehouse. Currently servicing Finance, Store Operations and Supply Chain groups using only one appliance. Queries (Reports) are faster, this has its own problem(s). Users want more complicated reports.

Business Problems Solved: Allocation, Planning, Store Operations, Inventory Control, Sales Forecasting etc.

Benefits: Business Users can simulate complex models rapidly.

Puredata review by Saugata G.
Saugata G.
Validated Reviewer
Verified Current User
Review Source

"Netezza user review as a data architect"

What do you like best?

As a data warehouse architect I built star schema data mart in netezza.I liked the netezza parallel architecture which helped processing multi terabytes of data at lightning speed.

What do you dislike?

There is nothing much to dislike. But it would be great if netezza improves its performance monitoring and alerting system.

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

We were building an olap data mart on top of data warehouse.

Puredata review by Krishnakumar S.
Krishnakumar S.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Netezza"

What do you like best?

I have been using netezza since three years , I have worked extensively in twinfin, striper and now in mako. I can definitely say it's the best analytical query processing I have every seen. This is a good candidate to meet or beat mainframe processing speed in terms of batch processing.

What do you dislike?

Waiting how they are going to handle big data

Recommendations to others considering the product

100% I would suggest

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

Confidential

Puredata review by Rama K.
Rama K.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"MPP "

What do you like best?

data loading and query.Easy to use for developers to developer ETL/ELT/BI Systems

What do you dislike?

Costly and not useful for small business and also IBM charges more for support

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

more than 10k users can use the application to use for query their data for analysis and time to take load millions of data with in minutes is really great

Puredata review by Prasanna M.
Prasanna M.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Great to work"

What do you like best?

Performance, archietecture and flexibility

What do you dislike?

Limitations on application integrity with SAP systems.

Recommendations to others considering the product

NA

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

application integrity with SAP HANA

Puredata review by Gnana s.
Gnana s.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Netezza Usage"

What do you like best?

best to handle large volume and efficient

What do you dislike?

No proper help forum or tutorial and client tool can be improved. Heard like its not extendable based on future need

Recommendations to others considering the product

make it as more flexible

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

used to build independent data mart , efficient to handle large volume

Puredata review by Consultant in Computer Software
Consultant in Computer Software
Validated Reviewer
Review Source

"ETL using Netezza as a data source"

What do you like best?

Immense time to value

Low administrative costs

Great hardware compression capabilities

Scalability

What do you dislike?

Load utility not as fast as competition

Large overhead for conversions from an existing implementation to Netezza (largely due to lack of indexes)

Recommendations to others considering the product

Terrific hardware compression abilities

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

Used Netezza as the primary data warehouse. Used IBM DB2 to complement OLTP systems to complement the NEtezza data warehouse.

Puredata review by Consultant in Retail
Consultant in Retail
Validated Reviewer
Review Source

"IBM Netezza is most powerful data warehouse appliance to handle large volume of data."

What do you like best?

Easy to handle large volume of data.

Robust architecture with 99% of performance and system availability.

Flexible to interface with market leading BI tools.

Very Less maintenance.

What do you dislike?

I don't have any specific comments to dislike.

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

Handling large volume of data in daily/ weekly data load process. Users are very happy to visualize any sort of data with quick response time.

Learn more about IBM PureData System for Analytics

IBM PureData System for Analytics Downloads

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.