Coginiti Professional, Scientific, and Technical Services Reviews & Insights

Score9.3 out of 10

13 Reviews and Ratings

Community insights

TrustRadius Insights for Coginiti are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Intuitive User Interface: Many users have found the user interface of the big data analytic software to be intuitive and easy to use, especially when connecting to various databases. They appreciate how it simplifies their workflow and makes it easier to navigate through different features.

Transparency of Database: Reviewers have appreciated the transparency provided by the software's database, which includes detailed table information such as columns, data types, data length, and space usage. This feature has been particularly helpful in understanding and analyzing the structure of the database.

Collapsible Object Browser: The object browser in the software is highly praised by users for its ease of navigation. It allows them to have a clear picture of tables and views, along with their composition. Users prefer its collapsible format organized by schema names, table/view names, and specific columns over other similar software options.

Coginiti Reviews

4 Reviews

Professional, Scientific, and Technical ServicesInformation Technology & Services2Marketing & Advertising1Human Resources1

My Great Adventure and Experience with Aginity

Rating: 9 out of 10

Incentivized

December 13, 2021

Use Cases and Deployment Scope

Aginity had empowered our employees with BI, database management, and analytics tools that make it effective to re-use SQL codes. Aginity is used in a few selected departments to drive more innovations by sharing the team's SQL skills in one central location.

Pros

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.

Cons

The vendor hasn't offered enough tutorials inform of documentations and articles for all Aginity features.

Likelihood to Recommend

Aginity once customized to optimal can suit a lot of business processes such as data cleansing, business process automation, and sharing SQL code lines with others. We have been able to collaborate in one secure platform in our organization with this tool where we share useful SQL codes for free.

Sabah Abdi

Associate Consultant in Research & Development at BTI Executive Search (Human Resources, 51-200 employees)

Vetted Review

2 years of experience

Aginity for Metadata under control

Rating: 8 out of 10

Incentivized

December 9, 2021

Use Cases and Deployment Scope

Aginity is the tool we use in order to query the database. We [use] it for IBM Pure Data (Netezza), Hortonworks and we had some trials with DB2. We use it in order to see all objects' metadata, to review DDL and DML on existing structures, and to see information regarding columns, keys, distribution, and so on.

Pros

See the list of tables, views, procedures
help preparing some queries, such as select top 100, reclaims, etc
run many queries all together and monitor the execution of each of them

Cons

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

Likelihood to Recommend

Aginity is almost always friendly and easy to use. Therefore anybody could start using it without any doubt. The queries helping you to prepare some fix or other operation on the DB are really useful and allow users to save some time. Stored procedures are also well done, and export to file on the selected information is really easy to use.

Verified User

Manager in Information Technology (Information Technology & Services company, 201-500 employees)

Vetted Review

8 years of experience

Analytic Agility with Aginity

Rating: 9 out of 10

Incentivized

April 26, 2017

Use Cases and Deployment Scope

Our business intelligence department all use Aginity to access our RedShift data. Our analyst team uses the tool to generate reports and run analysis on our data warehouse which lives in Amazon RedShift. Our business intelligence engineering team uses Aginity to perform some of the RedShift operational tasks and to validate data within the data warehouse.

Pros

Query auto-completion
Database exploration including schemas, tables, columns, distribution keys, sort keys, etc.
Common scenario query samples, and easy access to table DDL
Table size operational report
Free community edition

Cons

It would be helpful if the table size report could make it more obvious which tables need to be vacuumed. You can figure it out with the report, but can't just glance down a list.
Error message windows often auto close before you can read them leaving me hovering my finger over the print screen trying to capture them.
The auto-complete feature is a bit finicky. Many common scenarios which happen while writing a query by hand such as an unclosed parenthesis can cause the auto-complete not to trigger.

Likelihood to Recommend

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

Business Intelligence Engineer in Engineering at Experticity (Marketing and Advertising, 201-500 employees)

Vetted Review

2 years of experience

View profile

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

Rating: 7 out of 10

Incentivized

April 26, 2016

Use Cases and Deployment Scope

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.

Pros

Cleaner than most GUI's.
Easy to read.
Drag in table names instead of writing them.

Cons

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).

Likelihood to Recommend

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.

Verified User

Consultant (Information Technology and Services company, 11-50 employees)

Vetted Review

1 year of experience

Loading Reviews List....