Aginity for Metadata under control
December 09, 2021

Aginity for Metadata under control

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Aginity

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
  • Be able to save and create a lot of different queries in different tabs. Everything is well organized
  • the simplified queries proposed by Aginity are very useful
  • possibily to keep many connection open
  • The tool helped us to implement all Supply Chain and Retail data into the DWH
  • The tool allowed us to control ETL and reporting access, monitor them, and prioritize user's access
  • If you do not use the tool in the correct way, the risk is to delete some business information
Aginity is simpler than Toad to be used. The negative part is that it is not as flexible as DBeaver as you need to have more [agility] interfaces to access different DBs, while with DBeaver you can you the same interface. Still, sometimes Aginity is more precise when retrieving metadata from the Database.

Do you think Coginiti delivers good value for the price?

Yes

Are you happy with Coginiti's feature set?

Yes

Did Coginiti live up to sales and marketing promises?

Yes

Did implementation of Coginiti go as expected?

Yes

Would you buy Coginiti again?

Yes

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.

Comments

More Reviews of Coginiti

  1. Home
  2. Data Analytics and BI Services
  3. Coginiti Reviews
  4. User Review of Coginiti