Aginity - Flexible GUI, but it has its quirks...
April 26, 2016
Aginity - Flexible GUI, but it has its quirks...
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.