Coginiti vs. Azure Data Lake Analytics

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

For us we have an enterprise of SQL users at all skill levels, and this product is very SQL friendly and extremely fast in creation of data aggregates and analysis. If you are an Azure storage user, considering using Lake Analytics over top of your blob or any other storage just adds complementary services and functions native to your existing architecture.

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

• It combines big data.
• Monitors and alerts are helpful.
• Report visualization relies on analytics.
• It is compatible with Power BI services for report generation.

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

• There's a bit of bias towards cloud with ADL Analytics. Depending upon a company's infra strategy and investment plans, there are some challenges with migration and integeration.
• Not worth the time/effort/money if the organization doesn't have "Volume" of data. Cost effective only when daily loads exceed around 1million.
• While training materials are available online, Adoption rate - Yet to pick up.

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

Azure Data Lake simplifies extensive data analysis. It runs Hadoop, HDInsight, and Data Lakes, and even complex queries run smoothly and quickly. We write queries to transform data and extract insights instead of configuring hardware. It can handle any size job by adjusting the power. Azure's servers, networking, and data entry are fantastic. It provides security and assured data access.

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

• Since we have implemented this solution, we have been more able to follow what is going on in our process and sells.
• We are also sparing some money by comparing the costs now against the costs we had on-premise.

Incentivized