Coginiti

Formerly Aginity

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.

Cons:

Tedious Navigation: Some users have found the navigation in Aginity to be tedious, causing frustration and slowing down their workflow. They mention difficulties in finding specific features and navigating between different sections of the software. Automatic Character Creation: Several reviewers have expressed dislike for the automatic creation of parentheses and other characters in Aginity. This feature often leads to deleting unnecessary parts, resulting in wasted time. Users suggest that having more control over this auto-creation process would improve their overall experience. Lack of Log Feature: Users have mentioned that Aginity lacks a log feature for running codes and troubleshooting. This omission makes it difficult for them to track errors or identify issues with their code execution. They feel that having a log would greatly enhance their ability to debug and optimize their queries.

Users commonly recommend the following when it comes to using this software:

1. Prioritize SQL proficiency: It is important to be well versed in SQL before using this software. This will allow for better utilization of its capabilities.

2. Minimize simultaneous queries: To avoid freezing and optimize performance, it is recommended to minimize the number of queries running simultaneously.

3. Give it a try: Trying out the software is suggested to see if it meets one's expectations. This will help determine if it aligns with specific needs and requirements.

Users find this software worth using for data analysis and analytics on large data warehouses and big data. It has been compared to MySQL Workbench and praised as a great tool for working with Amazon databases, particularly RedShift. The simplicity and usefulness of the SQL command area and the ability to view data simultaneously are appreciated. The learning curve for this software is reported as manageable, making hiring a consultant unnecessary.