Aginity - Flexible GUI, but it has its quirks...https://www.trustradius.com/data-analytics-and-bi-servicesAginityUnspecified971012016-04-26T16:09:57.524Z
April 26, 2016
Aginity - Flexible GUI, but it has its quirks...
Score 7 out of 101
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.
- 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.