Coginiti vs. SAS Data Management

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

SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.

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

• SAS supports the main database connection options that allow you to optimize the performance of your extracts and loads.
• Simplicity of the syntax for a basic connection.
• Ability to configure by an administrator in a BI environment so that all users can benefit from the connection without having to establish it by themselves.

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

• It is a versatile product but sometimes difficult to use due to the very close link with the proprietary programming language where specific knowledge is required.
• Compared to competitors on the market that offer the same functions for the integration perimeter, it is certainly very expensive.
• It is very simple to use when combined with products from the SAS suite, less so it is being used stand-alone or integrated with other well-known brands.

Incentivized

We are happy with the software and its functionality. As a SAS-shop, DataFlux is a logical choice for complex data integration.

The main negative point is the use of a non-standard language for customizations, as well as the poor integration with non-SAS systems. However, there is no doubt that it is a high-performance and powerful product capable of responding optimally to certain requirements.

Incentivized

It worked as expected.

Incentivized

With SAS, you pay a license fee annually to use this product. Support is incredible. You get what you pay for, whether it's SAS forums on the SAS support site, technical support tickets via email or phone calls, or example documentation. It's not open source. It's documented thoroughly, and it works.

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

Because SAS Data Integration Studio is the third party it seems to work equally well with all our systems. That is to say that it doesn't really work better with Microsoft or Oracle but really just seems to work equally well with all of them. It has a very powerful back-end that allows us to transform and load our data quickly and efficiently programmer time wise.

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

• The platform enabled us to have a single repository of customers to run campaigns on.
• Feedback from various campaigns is stored in a single database, which makes running A/B analysis easier.
• Helped improve data quality due to SAS Dataflux being a part of the SAS Data Management Platform.

Incentivized