Informatica Cloud Data Quality vs. PowerProtect DD Series

For effective data collaboration, systematic verification of customer information, and address, among others, Informatica Data Quality is a fruitful application to consider. Besides, Informatica Data Quality controls quality through a cleansing process, giving the company a professional outline of candid data profiling and reputable analytics. Finally, Informatica Data Quality allows the simplistic navigation of content, with a dashboard that supports predictability.

Incentivized

We have huge data coming in from different sources and also from multiple organizations in our Data centres. This data had multiple copies of the same data and was huge in size therefore, we wanted to have a solution in place which can help us with a good amount of deduplication at the deepest possible level to make sure that our ecosystem does not have multiple copies of the same data and is also efficient at the same time. Having said this, we wanted this solution to be secure and reliable since it had to be exposed to a huge critical set of data in the market. To add, backup and restoration was something that we were also keen on evaluating so that once we have efficient data within our system, the time it takes to backup and restoration also reduces. And all this was justified by this solution when we signed up with them. From the pricing perspective and the implementation side, the solution needs improvement to make it more efficient and user-friendly.

Incentivized

• The matching algorithms in IDQ are very powerful if you understand the different types that they offer (e.g., Hamming Distance, Jaro, Bigram, etc..). We had to play around with it to see which best suit our own needs of identifying and eliminating duplicate customers. Setting up the whole process (e.g., creating the KeyGenerator Transformation, setting up the matching threshold, etc..) can be somewhat time consuming and a challenge if you don't first standardize your data.
• The integration with PowerCenter is great if you have both. You can either import your mappings directly to PowerCenter or to an XML file. The only downside is that some of the transformations are unique to IDQ, so you are not really able to edit them once in PowerCenter.
• The standardizer transformation was key in helping us standardize our customer data (e.g., names, addresses, etc..). It was helpful due to having create a reference table containing the standardized value and the associated unstandardized values. What was great was that if you used Informatica Analyst, a business analyst could login and correct any of the values.

• It writes backups quickly. DDBoost add-on is very useful as well for improving backup speeds.
• DD is very efficient in its use of capacity. It dedupes and compresses very well.
• It spans to large capacity amounts.

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 can be expensive to implement, especially when used in conjunction with other applications/hardware such as Avamar.
• The TCO can be high, especially when it needs its storage expanded.
• Recovery speeds can be slow (compared to other solutions) for when recovery is time sensitive.

Incentivized

As pointed out earlier, due all the robust features IDQ has, our use f the product is successful and stable. IDQ is being used in multiple sources (from CRM application and in batch mode). As this is an iterative process, we are looking to improve our system efficiency using IDQ.

DD has performed flawlessly for almost 10 years as our backup/recovery storage with offsite replication. Given its track record and great support from EMC, we're unlikely to look elsewhere any time soon.

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

Customer support has had some ups and downs here. We've had several issues with EMC support before and during the acquisition by Dell, but in the last 18 months support has been top notch. Quick and knowledgeable help is but a chat away, or they will call you back so you don't have to wait on hold. The team supporting us is responsive and is quick to assist with any request or issue.

Incentivized

IDQ is used by a department at my organisation to ensure and enhance the data quality.
The usage was started with address standardization and now it had been brought to altogether a next level of quality check where it fixes duplicates, junk characters, standardize the names, streets, product descriptions.
In the past we had issues mainly with duplicate customers and products and this were affecting the sales projection and estimates.

We selected Data Domain due to its integration with our backup software. The Data Domain works well for what we need it to do.

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

• We were able to immediately discontinue our remote tape storage and TBU maintenance.
• Reduced backup footprint in the data center.
• It is costly to expand so buy it with a purpose.

Incentivized