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.
Improvements to My Organization:
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.
Room for Improvement:
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.
Use of Solution:
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.