Ataccama ONE vs. Informatica Intelligent Data Management Cloud vs. SAS Data Management

Usage for enterprise wide data management and governance across wide range of user group. Ataccama ONE enables achieving higher data quality amongst the data products. It is a powerful platform that supports integration of several checks on different data sets that can be also consolidated in reports later on. Data discovery works quite fast and easy.

Incentivized

Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.

Incentivized

When data is in a system that needs a complex transformation to be usable for an average user. Such tasks as data residing in systems that have very different connection speeds. It can be integrated and used together after passing through the SAS Data Integration Studio removing timing issues from the users' worries. A part that is perhaps less appropriate is getting users who are not familiar with the source data to set up the load processes.

Incentivized

• It is one of the leading data quality tools in the industry, in our opinion.
• Offers free data profiling.
• Integrates with other tools for complete end-to-end lineage.

• Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
• The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
• The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.

Incentivized

• SAS/Access is great for manipulating large and complex databases.
• SAS/Access makes it easy to format reports and graphics from your data.
• Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs.

Incentivized

• Performance in loading
• Reduction of pop-up messages

Incentivized

• The User Interface can be a bit difficult to get in initial stages.
• Error messages are hard to understand which sometimes takes a lot of time for the resolution
• Cannot Implement complex SQL queries which should be fixed in future release.

Incentivized

• Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres.
• Debugging errors from the logs is a complicated process.
• E-mail alert system is very primitive and needs customization to make it more modern,
• Cannot send SMS alerts for jobs.

Incentivized

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

One of the key factors in our choice to onboard Ataccama was its usability - general end users have everything at their fingertips, it is not difficult for IT developers to setup the tool, and it has been an overall pleasure.

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

Support has been excellent to date - very user friendly and knowledgeable to help support our needs and issues as they arise.

I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.

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

Ataccama ONE is a designated tool for Data quality monitoring. Supports end to end. Quite easy to deploy. Alteryx is more about coding or almost as complicated while Ataccama ONE is a bit easier to use. Different interfaces. Many views automatically available for data sets in Ataccama ONE. Output is vizualized in the tool. While more data transformation is required in Alteryx.

Incentivized

First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.

Incentivized

Because of ease of using SAS DI and data processing speed. There were lots of issues with AWS Redshift on cloud environment in terms of making connections with the data sources and while fetching the data we need to write complex queries.

Incentivized

• Less data inconsistencies in the system enable processes to run smoother without interruptions

Incentivized

• Cut costs on the number of staff we need for data import.
• Cut costs for automation that can be done for data that no longer has to be manually imported.
• We've saved countless dollars by eliminating duplicates in our system with this tool.

Incentivized

• We have more users who can connect to the many different data sources.
• Our users do have existing SAS programming knowledge and that can carry over.
• Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction.

Incentivized