Netezza Review

We are now able to analyze products, stores, suppliers and sales as quickly as we need.


What is most valuable?

  • Easy Deployment
  • No Indexes
  • Extremely fast to respond queries with high amount of data
  • Data distribution based on hashtable concept
  • Zonemap
  • Easy to migrate data

How has it helped my organization?

My customer is one of the biggest retail companies of Brazil. The company uses SAP and other technologies to manage their process but they didn't have an efficient way to process data and take a better view about their business.

The appliance Netezza gave us the capability of process terabytes of data and gave us new directions and ideas to make our business more profitable. We are now able to analyze products, stores, suppliers and sales as quickly as we need to take a decision to handle any kind of issue or prevent loss of sales.


What needs improvement?

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.

For how long have I used the solution?

For the last 4 years. I am a data architect responsible for the design, the implementation and optimization of all process related to it.

What was my experience with deployment of the solution?

No, I haven´t found any issues.

What do I think about the stability of the solution?

No, I haven´t found any issues.

What do I think about the scalability of the solution?

Yes. If the Demand for clock or disk space grow over the limit, it will be necessary to change the appliance, because it's not possible to upgrade any component of this machine. You have to buy a new one with a bigger capacity.

How are customer service and technical support?

Customer Service:

6/10 – Some issues about this equipment I had to discover by myself. I think that the vendor did not give me the best support to use the appliance. The machine is excellent, but I had to discover everything by myself as well figure out how to use the equipment in the best way.

Technical Support:

6/10 – I don't know if it is related to the SLA of my customer, but I think that the things are not as fast as they should be when we need help.

Which solution did I use previously and why did I switch?

I used to have Oracle as my Data Warehouse solution, but despite the fact of it is very good to manage transactional environments, it does not work as fast as Netezza. We have analytical demands so we need an analytical solution. Sometimes we need to retrieve and process our whole table of inventory so it means around 16 billion of rows. Netezza can process all this amount of data and give a result in less than 40 seconds. I have never seen this performance in another database solution before.

How was the initial setup?

The setup was not complex. It was fine. Initially the vendor gave us all the support, including a hands-on course before using the machine.

What about the implementation team?

We implemented by ourselves, my team and I implemented everything.

What was our ROI?

I do not have this information.

What's my experience with pricing, setup cost, and licensing?

I am not able to give this information.

Which other solutions did I evaluate?

Yes, I evaluated Teradata and Exadata. Initially I thought that Teradata would be better, so my customer was not able to afford the costs. Now I am sure they made a good choice.

What other advice do I have?

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.


Disclosure: I am a real user, and this review is based on my own experience and opinions.

1 visitor found this review helpful
Add a Comment
Guest
1 Comment

author avatar
Vendor

Hi Leo, this is a very helpful and detailed post I have read so far. Good job!