What users are saying about
7 Ratings
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 101

Likelihood to Recommend

Aginity

Aginity is well suited for writing ad-hoc queries and data analysis, having all of the features that data analysts come to expect in a database querying tool. Aginity is also great for basic operation and management allowing an engineer or DBA to store multiple databases and credentials, see how tables are distributed or sorted, and see table sizes and row counts. However, for more advanced database management another tool or the RedShift console is still required
Jordan Squire profile photo

Pros

Aginity

  • Transparent database -> table information. The columns for a specific table/view is listed out within the object browser, and the object browser is easy to navigate, for providing a clear picture of the tables/views, and what it's made up of. Including column data types, data length, and space usage. The object browser follows a collapsible format, breaking down databases by schema names, following with the table/view names, and then the columns specific to that table/view. This in my opinion, is easier than the object browser that Toad provides, where you have to select into a specific table in order to see it's contents and details, rather than being able to compare and have everything on one page.
  • The output window is easy for further data extraction, one can simply copy the data out onto an email, into an excel spreadsheet, or other places as necessary. Data could also be exported from the output window, into either excel spreadsheets, or CSV format files, without the need to convert between one or the other. A special area is reserved for dragging column headers into, and what it does is it groups information by that column. This allows flexible user grouping, without the need of writing SQL queries to group on columns. Often times, in my experience, I find the need to group columns on a to-go basis, where I review the data output, and find the need to group on certain columns for further research and analysis, this option allow me to manipulate the result I currently have, without the need to rerun a query for grouping inclusions.
  • Able to cascade query windows between different environments. I often need to cascade query windows between an UAT environment, a RESEARCH environment, and a PRODUCTION environment. To be able to cascade between them, and to reference queries and its results, is a huge plus, that I didn't find in some of the other products I've used. This allow me to reference information in between different environments, without the need to connect back and forth.
Roger Luo profile photo

Cons

Aginity

  • Default query tuning hints and parallel joints.
  • Improve response time when it’s objects are selected.
No photo available

Support

Aginity

Aginity 8.0
Based on 1 answer
Prompt technical support.
No photo available

Alternatives Considered

Aginity

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.
No photo available

Return on Investment

Aginity

  • Since the tool is free it doesn't take much to get a positive ROI.
  • Since RedShift is a PostgreSQL derivative, tools designed for that DB can be used to access RedShift. However, it is much nicer to have a tool that is RedShift aware and understands the slight differences.
  • Query auto-completion makes writing queries much quicker and less error prone.
  • The database management features are a nice plus that many comparable tools for RedShift and other databases don't provide.
Jordan Squire profile photo

Pricing Details

Aginity

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison