Informatica Cloud Data Quality vs. SAS Data Management

We used Informatica Data Quality to measure the "Data Quality Score" of internal and external reports at my company. Business users set up data profiling and prepared detailed analysis documents for business analysts. and developers developed Data Quality Mapplets for other IT teams to import their Informatica Power Center repositories. Results are stored in a centralized data quality space and then reported and summarized to related business users in detailed ways. At the end of each project, we are now able to place a "Data Quality Score" watermark score on each report involved.

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

• Watch the data real time- After creating the job the data quality engine checks and run the custom rules creating a navigation window at the bottom for review and accessing the data right away.
• Character Set Mapping
• Makes sense of our own data, which in turn gives us confidence that we can provide to the end users. IDQ helped us with erroneous data in accounting and HR for accurate and immaculate reports

• 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

• Several partnerships diminishing the value of technologies
• Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
• Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.

• 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

I gave a rating of 8 due to the fact that we use Informatica for both our data quality product and ETL product. Having both integrated makes it so much easier. Microsoft had a similar product of finding duplicates, but at the time it didn't seem mature enough. The usability also in IDQ was pretty easy to navigate and use.

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

Easy to use not only for developers but also business users

Incentivized

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

The application works well except an occasional error out while using the system. It usually gets fixed when restarting the Infa server

Incentivized

Performance works just fine. It was able to load 200+ business terms, 150+ DQ automation, etc. very well.

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

Informatica Data Quality has a wide range of cleansing features, that are detailed, professional, and accurate in scaling down the required database. Further, Informatica Data Quality ensures there is proper collaboration, and this fosters businesses to have the freedom of working closely with several programs. Finally, Informatica Data Quality design is authentic and allows personalization.

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

Scalability works as expected and it is truly an enterprise system.

Incentivized

• Integration with tools like PowerCenter helped faster delivery of product, and at the same time conversion
• Reduce overall project cost due to bad data , bad quality, exceptions identified nearing go-live and post production
• Employee efficiency is increased exponentially due to more automated, customized tool

• 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