Coginiti vs. Blacklight

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

Incentivized

• Explore, model and analyze data across all company platforms.
• With Aginity, we improve team engagements where we can access and re-use colleagues' SQL.
• Make faster data-driven decisions with BI capabilities.

Incentivized

• with Hortonworks, you have to modify manually some settings in order to correctly see the metadata (HCAT properties)
• with reclaim, the generate only express statistics and "limit 100" on the select is a little risky if you do not pay attention.
• Saved views cannot be retrieved with the same [syntax] you wrote them, but they become really hard to read

Incentivized

Aginity learning curve was smooth and we didn't need to hire a specialist to teach us the system. it also offers free trials and a free version which enabled us to use and test the system's compatibility with our organisation's needs before fully investing in one. moreover, its ability to drag and drop tabs has made our work easier.

Incentivized

• I think Aginity really allows us to quickly dive into the data, by providing easy and quick access to our database. This allowed us to solve our business problems on an efficient and timely manner. But since it is not a critical component of our department, (a lot of people also use Toad for the same thing, since Netezza is retiring soon, and Aginity, which belongs to IBM, has had legal issues, and is no longer available to new hires of our department. It is sort of our legacy software.)

Incentivized