Informatica Intelligent Data Management Cloud (IDMC) Reviews

• Matching, merging and survivorship
• Maintaining cross reference and merge history information

A lot of my pharmaceutical clients had to implement an Aggregate Spend application to track how much money they are spending on their prescribing physicians. This was need to comply with the Sunshine Act and their was a need to uniquely and unambiguously identify these physicians. The Informatica MDM tool provided a very robust and cost effective solution to implement a single view of physicians.

The major area of improvement is its GUI front end. The out of the box solution call Informatica Data Director is not at all user friendly, it is a data stewardship tool. A user friendly and feature rich front end will be a great improvement.

I've been using it for over eight years.

Only minor issues which can usually be resolved by the Informatica Support team.

Never when the implementation and sizing guidelines were followed.

Never when the implementation and sizing guidelines were followed.

Customer Service: Customer service is very timely and consists of very capable and competent staff.Technical Support: Technical Support is very timely and consists of very capable and competent staff.

I was implementing the Siebel UCM product before while working for Oracle. I had to switch because my client opted for the Informatica/Siperian MDM solution. I have been implementing this product ever since.

The initial set up and configuration is fairly straight forward, which is one of the strengths of this product.

I have implemented this solution with vendor teams as well as in-house ones. A rigorous Vendor Selection process including reference checks are a must if using a vendor to ensure successful implementation. I prefer to work with in-house teams so that it becomes a great learning process for everyone who will have to enhance, maintain and support the MDM application.

In most of the implementations we used relative implementation costs rather than ROI and the Informatica MDM solution is very cost effective.

It varies by the size of the projects based upon number of sources, data volumes and quality, complexities, etc.

Most of my clients go through a Product Evaluation and Recommendation phase during their MDM implementation and the other options usually evaluated are solution offerings from IBM, Oracle, SAP, SAS, Trillium, etc.

Always start by forming a robust Data Governance organization to ensure implementation of good data quality standards, policies and processes.

Data cleansing and address validation are the most valuable features. Also the web services which can be called on the fly. Data Duplication plays a very important role.

It has improved the customer data management where we had the incorrect addresses and data cleansing. Also in finding the duplicates so as to ensure the customer data is not duplicated.

Asia pacific region address validation needs to be improved.

3 years

None

None

None

Customer Service: 4 out of 5Technical Support: 4 out of 5

We previously used Firstlogic as a data quality tool. We found that Informatica is more feasible and user friendly than Firstlogic.

In-house.

Yes. Trillium.

IDQ integration with Power Centre Designer Repository. On the fly you can move your IDQ artefacts to Power Centre Designer. Later you can use them in a workflow and for scheduling etc.

Improved Data Quality, after we run the IDQ session which we customize for each client (Developed custom business rules in IDQ).

GUI is poor in IDQ

Over a year

No

No

No (Depends upon your design and architect)

Customer Service: Customer service is OKTechnical Support: Technical support is OK

Earlier we used ODI and IDPQ, but the new client wants the development in Informatica.

It was a ittle complex, as there are post installation services you need to create in Informaitca Administrator.

In house team (I was part of the team as an Informatica Administrator and IDQ Developer)

Better data quality

IBM Data Stage, IBM Information Analyzer and IBM Quality Stage (More cost Centric). Oracle ODI (Oracle Data Integrator) and ODPQ (Oracle Data Quality and Profiling).

Informatica Data Quality is a solid Integration tool.

- Seamless integration of MDM, data quality and data integration modules - Repository of data models from other customers - very useful! - Support for multiple domains including product and location data - Flexible architecture supports registry, consolidation, coexistence, and transaction styles. We use the coexistence style. - Management of party data - Performance is good, even as our database has grown in size over the past year

- When we compared Informatica to SAP, we realized that we lose the ability to integrate easily with our SAP business applications - Needs more preconfigured business rules and services - Weak in data stewardship. The UI in particular needs improvement. - Reporting can be improved.

Facebook integration looks interesting, but we haven't taken advantage of it. Informatica is a very innovative company in my opinion.

The solution was part of building our data warehouses, where we needed a tool for bulk data migration that didn't require mappings when migrating from a source to a target.

The product's most valuable feature is the replication tasks. It allows the creation of identical tasks that can be applied across multiple tables, ranging from 100 to even 1,000 tables. 

The product interface could be improved to be more intuitive. It requires navigating through several steps to access mappings and pre-created metrics. Enhancing it to provide a more streamlined structure or dashboard would allow quicker access to maps and other essential features.

We used Informatica Cloud Data Integration for six months. 

The product was stable. I rate the stability a ten. 

We had 30 Informatica Cloud Data Integration users in our organization. I rate the scalability an eight. 

The solution didn't require much setup, and since it was browser-based, it was fairly easy to use. I rate the process a ten out of ten.

The product was pretty easy to use. The connections to other platforms worked fine. 

I recommend it to others and rate it a seven. 

I have received feedback from certain teams and there is a steep learning curve to use this solution.

In a future release, there should be better integration with other governance tools.

I have been using Informatica Cloud Data Integration for approximately three years. We have been using it consistently for one year in a large project.

The solution is reliable.

Informatica Cloud Data Integration has a strong enterprise customer base and this is one of the main reasons why we choose to work with them. The solution is scalable.

We use other similar products similar to Informatica Cloud Data Integration.

The initial setup is not easy.

The implementation would be best to be done by experts.

Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor.

I rate Informatica Cloud Data Integration a seven out of ten.

Our primary use case of this solution is for data integration; integrating cloud warehouse or cloud layout. Cloud Data Integration offers capabilities that didn't exist in the on-prem version. I'm the company product manager.

The mass ingestion functionality and the elasticity of the solution are great. It enables you to leverage the elasticity capability that the cloud provides. You can build a process, scale-up and leverage all the elasticity and the automatic provision the cloud has. What took 10 hours to do in the on-prem version, takes less than an hour in the cloud. It's a huge difference. The solution is designed for a cloud-native approach with native components and connectors for all the cloud-ready solutions we need nowadays.

I think the price modeling could be improved. Currently, the IPU consumption is defined on a monthly basis and if you don't use all the IPUs available in a particular month, they are lost. A more flexible pricing model is something Informatica should look at. 

The solution is scalable. 

The technical support is good, we raise the tickets in the Informatica Support Portal. 

The solution is great once you have a clear roadmap of migration to the cloud. In the cloud migration journey, it's important to be clear of the entire process.

I rate this solution nine out of 10. 

I starting with the design and discovery phase to detect data issues by using the profiling service, then started to analyze the data to determine and fix issues with it.

This product really improves my organization and fits all of the needed requirements for working with cleansed data. This helps to prevent issues from appearing in the business layer.

The user interface is flexible and the visibility of the data flow is amazing. You can see your data throughout the flow and then you can determine where issues are before fixing them.

The tool's performance is an area that should be given further consideration.

I have been using Informatica Data Quality for more than one year.

This is a stable product.

The solution is scalable.

Technical support has been very helpful. Whenever we have a problem, they are able to solve it.

I have experience with a similar solution by IBM.

Informatica platform installation is straightforward. As long as the prerequisites check is done successfully, it will be very easy to do.

On-premises

IBM