Home/Machine Learning Software/Aginity
Updated on: October 21, 2021

What is Aginity ?

Aginity

Integrated Analytics Management Solution
(16 Ratings) Write Review

Aginity is an integrated analytics and data management platform. It provides a powerful set of tools to access as well as integrate data from an external file or relational database. The easy to understand SQL interface facilitates the easy and quick building of custom analytics. Past work can be easily accessed through its catalog feature and assets can be shared with the entire team of data analysts, data engineers, data scientists, and business users. Data and math can be co-located easily, which enables data engineers and data scientists to create and manage analytics to be consistently reused in the enterprise. When reusing SQL, there’s no need to recode it. Users can track analytic provenance, record how analytics are built or changed, speed up the development process and even enable analytic probability across applications and users with APIs. Core feature is that users can easily integrate and analyze data from their favorite databases including Snowflake, Amazon Azure, Amazon RDS, Apache Spark, and so on.

Aginity Technical details

Support Online Customer Type Freelancers Large Enterprises Medium Business Small Business
API Location / Phone Number Evanston, IL - 60201 / +1 224-307-2656
Deployment SaaS/Web/Cloud Category Machine Learning Software

Aginity Pricing

Pricing ModelFreemium , Subscription
Aginity Pro
Free

For Individuals

Features

  • 1 Editor
  • Object-oriented analytics
  • Code titles and descriptions
  • Roles : Editor
  • Programming Languages : SQL
  • Data Platforms : Redshift, Snowflake, Hive, IBM Pure Data for Analytics, Spark, Pivotal Greenplum, PostgreSQL
  • Deployment Model : Desktop
Aginity Team
$89 /Month

$89 per Month per Seat billed Annually

For Teams

Features

  • 3-40 Editors
  • Additional Seats
  • Includes features of Aginity Pro plan, plus
  • Shared code catalog/repository
  • Roles : Viewers, Admin
  • Deployment Model : Server
Aginity Enterprise
Custom

For the Enterprise

Features

  • Multiple Editors
  • Includes features of Aginity Team plan, plus
  • Programming Languages : Python, SCALA
  • Data Federation
  • APIs : JDBC, OBDC, RESTful
  • Enterprise Authentication : LDAP, SSO
  • Deployment Model : Cluster
Screenshot of the Vendor Pricing Page
View Full Screen

Disclaimer: The pricing details were last updated on 24/07/2019 from the vendor website and may be different from actual. Please confirm with the vendor website before purchasing.

Learn more about Aginity pricing.

Aginity FAQs

Yes, Aginity provides API.

Ask the Community View Community

Aginity Alternatives Aginity Alternatives

MorphL AI
MorphL AI MorphL AI software is a platform to build intelligent e-commerce apps. Engage your customers with... read more
Visit Website
Verfacto
(5 RATINGS)
Verfacto Verfacto is a machine learning tool that helps small and medium eCommerce businesses to study the... read more
Visit Website
neptune.ml
(5 RATINGS)
neptune.ml Neptune.ml is a smart collaboration platform that assists uses in managing their workflow. It is a... read more
Visit Website
Amazon Personalize
Amazon Personalize Amazon Personalize is a machine learning platform that empowers developers to create individualised... read more
Visit Website
ByteBridge
ByteBridge ByteBridge is an accurate data labelling platform comprising exclusive tools that help users with... read more
Visit Website
Recombee
(10 RATINGS)
Recombee Recombee is a machine learning software. All recommendation models as mentioned before, work in... read more
Visit Website

Aginity Reviews

OVERALL RATING
3.9
Based on 16 Rating(s)
Rating Distribution
  • 18.2 %
  • 81.8 %
  • 0 %
  • 0 %
  • 0 %
SHARE YOUR EXPERIENCE Write a Review
Sort By
Filter by Source
Ash Z
Ash ZSource : g2crowd.com
(Reviewed on 27 August 2020) ""One Stop Tool""

What do you like best?

Interface has nice layout and very quick and easy to set up multiple databases and run queries all from one tool!

What do you dislike?

There is nothing in particular that I dislike

Recommendations to others considering the product:

Try it and see for yourself, it will most likely not disappoint!

What problems are you solving with the product? What benefits have you realized?

I realize that Aginity is very easy to use and have clear interfaces compared to something like SSMS especially in setting up and connecting to various databases. It also provides an easy to read windows panes in displaying the query results.

...more
Consultant in Computer & Network Security
Consultant in Computer & Network SecuritySource : g2crowd.com
(Reviewed on 03 December 2019) "Aginity Workbench for puredata system for analytics"

What do you like best?

This application gives a robust UI for writing smaller queries as well as for complex functions and Stored Procedures. Option to select different databases gives a user friendly and one of a kind experience. This makes analytics of data more interesting and enjoyable.

What do you dislike?

Even when the database name is given in the query, this application is not smart enough to pick that and it picks whatever database is already selected. Other than this,i found no major drawbacks.

What problems are you solving with the product? What benefits have you realized?

As a DBA for a retail giant, I along with my team, need to analyse loads of history data, recommend and collect stale statistics, take backups and tune bad queries. All of this work is preety data intensive but when Aginity comes in picture, the experience is so smooth and the UI is so soothing, time goes by hurriedly.

...more
Bhawna G
Bhawna GSource : g2crowd.com
(Reviewed on 29 August 2020) "Extremely User friendly"

What do you like best?

People who know SQL can easily work on Aginity as it's front end coding contains SQL as the language to interact with the Hadoop framework. Also, you can run different queries on different tabs which makes parallel processing easy.

Very reusable and scalable in terms of user friendliness. I have used the Analytics Management extensively. Aginity Amp makes sure that analytics use is consistent across your company. It catalogs both the data and the math utilized to create analytics, which makes it simpler to build trustworthy and consistent analytics.

Heard that the governance and data cleansing feauture is also amazing.

What do you dislike?

The dashboard could be more appealing and simple. Sometimes, it gets stuck before of large query handling but that's only sometimes. Initially I had some installation issues too.

Recommendations to others considering the product:

1. Be well verse with SQL before using this. As most of the syntax is really SQL based, it would be better.

2. You can run different queries on different tabs, that's the good part. But try minimising them as well.

What problems are you solving with the product? What benefits have you realized?

Extracting datasets, designing queries to look into big datasets etc. Aginity makes it very simple to do all such stuff. I have used the Azure SQL Data Warehouse to combine query performance with data security. My other team members used to integrate it with other products as well as their roles were of developers. I was a tester and my main job was to find loopholes in the analytics workload demands and expectations.

...more
User in Marketing and Advertising
User in Marketing and AdvertisingSource : g2crowd.com
(Reviewed on 28 August 2020) "Never had major issues using Aginity"

What do you like best?

Is quick, is oointing our the errors in the code

What do you dislike?

Sometimes it freezes when i press execute

Recommendations to others considering the product:

if a query takes longer than expected to run it may freeze the wwindow

What problems are you solving with the product? What benefits have you realized?

Checking right aWay what data is being retrieved (because where i use sql doesn’t show me the data itself but rather the number of rows that are selected)

...more
Matej A
Matej ASource : g2crowd.com
(Reviewed on 11 March 2020) "No-fuss SQL IDE ideal for Analytics Data Preprocessing"

What do you like best?

Simple interface, snippet catalog, compact UI elements that leave enough space to display code and results, in-application resource center, SQL history tracking, moderately fast execution and result fetching, complete intellisense, database inspect on background, csv inspector

What do you dislike?

Lack of DDL inspection for views, limited number of supported database drivers, absence of dark mode in the editor, no git support, csv import wizard is not a particularly useful feature, csv export would be appreciated, on the other hand. The keyboard shortcut execution is somewhat confusing as of March 2020 release. Vertical split of sidebars would also be very useful for tall screens.

Recommendations to others considering the product:

Aginity is a great for beginners or users who engage in many other activities than just writing SQL. It is not suited for DBAs or database developers. The purpose of the product is to provide a comfortable workspace in direct communication with your data warehouse.

What problems are you solving with the product? What benefits have you realized?

Being directly connected to our data wrehouse, most of my activity is comprised of writing database views in Redshift SQL dialect, creating snapshots and utilizing the finalized queries further in BI platforms and with data science tools. Seing the whole query is not an option anymore, even with a vertical screen, but the more space there is for code in the viewport, the better. And that is the main strenght of Aginity. Its code completion and syntax highlighting features are flawless and general ease of use satisfying. Regarding database connectors, there are few, but those I use are reliable even when those of alternative products break. The automatic update feature is very pleasant as well.

While I do not use Aginity as my main IDE and I don't make use of the paid Aginity Team plan, I do greatly appreciate the overall feel and would highly encourage others to give it a try, especially those who are new to SQL or struggle with organizing their work.

Aginity Team seems helpful but the pricing is steep compared to other options in the market.

...more
shridhar s
shridhar sSource : g2crowd.com
(Reviewed on 14 September 2019) "workbench for redshift"

What do you like best?

UI is one simple and best to extract data from redshift .

What do you dislike?

look and feel and website is very much outdated

Recommendations to others considering the product:

Worth using its similar to mysql workbench

What problems are you solving with the product? What benefits have you realized?

we are extracting data from multiple database and using this aginity it helps to understated table and columns very easily

...more
Source : g2crowd.com
(Reviewed on 31 May 2019) "Good tool for Amazon Databases"

What do you like best?

It is easy to use and it is very fast to connect databases in the cloud. I used the version for Redshift. It has a complete set of tools to operate and develop your own databases. It can connect databases with native connector or ODBC. It seems to be simple application, but there are many features that can be used. At same time, it supports all your needs for a daily basis job.

What do you dislike?

It seems that the software was developed with old components. UI could be more updated. Sometimes the application seems to be lower when running complex data queries, but not too slow. It is acceptable.

Recommendations to others considering the product:

It is a great tool to be used together with Amazon databases. I used for some time for RedShift and it worked very well. For me it is important to have a good SQL command area and also do not lost screen for data and this application works very good for this purpose. Another competitor tools don't have so simple and at same time useful resources. It was used for all our team and it fits perfect for everyone. The learning curve was very good, so wasn't necessary to hire a consultant to teach the application.

What problems are you solving with the product? What benefits have you realized?

We are using the application to develop and manage data of Amazon RedShift. It is easier than perform directly in the cloud. We are solving lack of tools provide by Amazon to perform Redshift operations.

...more
User in Paper & Forest Products
User in Paper & Forest ProductsSource : g2crowd.com
(Reviewed on 31 May 2019) "Good tool for Amazon Databases"

What do you like best?

It is easy to use and it is very fast to connect databases in the cloud. I used the version for Redshift. It has a complete set of tools to operate and develop your own databases. It can connect databases with native connector or ODBC. It seems to be simple application, but there are many features that can be used. At same time, it supports all your needs for a daily basis job.

What do you dislike?

It seems that the software was developed with old components. UI could be more updated. Sometimes the application seems to be lower when running complex data queries, but not too slow. It is acceptable.

Recommendations to others considering the product:

It is a great tool to be used together with Amazon databases. I used for some time for RedShift and it worked very well. For me it is important to have a good SQL command area and also do not lost screen for data and this application works very good for this purpose. Another competitor tools don't have so simple and at same time useful resources. It was used for all our team and it fits perfect for everyone. The learning curve was very good, so wasn't necessary to hire a consultant to teach the application.

What problems are you solving with the product? What benefits have you realized?

We are using the application to develop and manage data of Amazon RedShift. It is easier than perform directly in the cloud. We are solving lack of tools provide by Amazon to perform Redshift operations.

...more
Source : g2crowd.com
(Reviewed on 11 January 2019) "Not the most user friendly, but effective"

Describe the project or task the product helped with:

SQL workbench for querying the redshift database. I write my queries in aginity, then it calls the database.

What do you like best?

It’s pretty quick to get up and running, and once you’re all set up, the interface is pretty straightforward.

What do you dislike?

There is no automatic SQL formatting, so you have to create line breaks yourself. If you want to add that option, you have to really get into the technical nuts and bolts

...more
G2 User in Internet
G2 User in InternetSource : g2crowd.com
(Reviewed on 11 January 2019) "Not the most user friendly, but effective"

Describe the project or task the product helped with:

SQL workbench for querying the redshift database. I write my queries in aginity, then it calls the database.

What do you like best?

It’s pretty quick to get up and running, and once you’re all set up, the interface is pretty straightforward.

What do you dislike?

There is no automatic SQL formatting, so you have to create line breaks yourself. If you want to add that option, you have to really get into the technical nuts and bolts

...more
Read All Reviews

Videos on Aginity

Build Your Analytics Once - Use Everywhere
Build Your Analytics Once - Use Everywhere
Aginity Amp Overview
Aginity Pro - A Personal Active Analytics Catalog

Aginity Screenshots

Aginity screenshot
Aginity screenshot
Aginity screenshot
Aginity screenshot
Aginity screenshot

Disclaimer

The research is compiled using multiple sources, let us know of any feedback on feedback@saasworthy.com