erwin Data Modeler vs. Informatica Cloud Data Quality

If you have a database environment that gets frequent schema object change requests. erwin Data Modeler is a great tool for version control and release control. Also, it's very useful to communicate between database and application teams.

Incentivized

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

• Creation of logical data models
• Reverse engineering
• Excellent communication tool in conversations with Developers and BAs
• As a company, Erwin provides lots of tutorials and how-tos.

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

• erwin Data Modeler allows only 25 entities in a trial version. It really limits you when you want to try out the product before actually deciding to pay for licensing cost. It would be rather helpful if they limit the trial period by days instead.
• The UI is pretty good but sometimes the large diagrams are hard to manage. A little improvement in that area would be helpful.

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.

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.

The product is well designed and intuitive to use. The number of buttons and options can look a bit overwhelming initially but they come very handy when you get used to product.

Incentivized

Easy to use not only for developers but also business users

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

CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.

Incentivized

I have used few other data modeling tools like Toad Data Modeler and SQL Developer Data Modeler. erwin Data Modeler is easy to use and has additional features that make overall data modeling productive and easy to manage.

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

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

Incentivized

• Reduced rework from when models were maintained individually.
• Reduced the amount of time to generate and compare models during development.
• Massively reduced the amount of time to reverse engineer 3rd party data models for analysis.

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