Aginity - Flexible GUI, but it has its quirks...
April 26, 2016

Aginity - Flexible GUI, but it has its quirks...

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Aginity

I used Aginity Workbench to build, update, and read from Netezza. Mainly, I used Aginity as a consultant to help build hand written ETL processes for a company I contracted with. In the organization itself, very few people used it aside from a few SQL-savvy business analysts. It is possible more people used it since I complete the contract more than 10 months ago. It really isn't being pushed by the organization, but served more as a portal to building an EDW.
  • Cleaner than most GUI's.
  • Easy to read.
  • Drag in table names instead of writing them.
  • Would not sort fields alphabetically!
  • Hard to tell when it was running and locked.
  • Navigating can be a pain and can be buggy (click one table, and another table is selected).
  • Built a small EDW in 6 months with this tool.
  • Tool is not used other than read operations today.
  • Data is more of a cost center, so I wouldn't say that there is a dollar amount associated with an EDW in ROI.
To be honest, our client had already selected Aginity to be the layer over Netezza. However, I have spent a lot of time in Teradata SQL Developer and Microsoft SQL Server Management Studio. If I had to rank them in order, I would put Teradata SQL Developer first, followed by Aginity, then Microsoft SQL Server Management Studio.
I believe it is the standard GUI when working with Netezza. In that sense, I would recommend it. However, most GUIs are best suited for their native client. I'm not about to connect this to Redshift, Greenplum, or anything else. Then again, I have not tried connecting to those, so I can not speak poorly of its capability to do so. I just tend to choose the recommended tool.