Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Associate at a tech services company with 10,001+ employees
Real User
Valuable features include data quality improvement, analytics, and reporting.

What is most valuable?

Valuable features include:

  • 360 degree view of customer data
  • Data quality improvement through better decision making with respect to BI
  • Analytics and reporting
  • Improvement in he customer experience with better services provided to the application users
  • Consistent support to the business through process standardization supported by effective Change Management and Data Governance

How has it helped my organization?

We had implemented it across leading Life Science domain. Clients looked to implement a MDM solution for Customer data, which will create a Golden Record from multiple source systems.

Single and consistent view of Customer Data arising from a centralized data set with unique customer records.

Customer data is a critical asset that must be managed within the enterprise.

An integrated Master Data Management solution is needed to enable a 360-degree view of its Customers and provide accurate and timely Customer information.

The ability to link customer information across HCPs (Healthcare Providers), managed markets, hospitals and institutional accounts enables an enhanced view of the customer.

What needs improvement?

I am looking forward to integration with leading data providers, such as DaaS in the Life Science domain.

For how long have I used the solution?

I'm using Informatica MDM since 2012 in various version XUSP2,9.1,9.5.1,10.1 and 10.2

Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
March 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
841,152 professionals have used our research since 2012.

What do I think about the stability of the solution?

There were a few stability issues, but overall it is a stable product.

What do I think about the scalability of the solution?

When it comes to scalability, it is the best product in the market.

How are customer service and support?

I would give technical support a rating of 9/10.

Which solution did I use previously and why did I switch?

I looked into other products in this segment, but we never implemented them.

How was the initial setup?

The setup was pretty simple.

What other advice do I have?

I would suggest to just go for it. It is the best MDM solution in the market.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user852315 - PeerSpot reviewer
it_user852315Senior Technical Recruiter at a training & coaching company with 201-500 employees
Real User

Hi Man,

10/10 !!! Thank you for making your blogs an embodiment of perfection and simplicity. You make everything so easy to follow.

Q1, Update Strategy vs. Treat Source Rows As: wrong. The UPD just tells the pmdtm process whether the current record shall be inserted into the target, updated (according to the update details!), deleted from the target, or rejected. Data Driven just means that the flag set by the UPD shall be observed, instead of handling all records the same way.
When the UPD flags a record as DD_UPDATE, then the choice between Update Else Insert , Insert Else Update, or Update As Update will be followed.
In all other cases this choice does not apply.

OK, one additional BUT: if you flag a record for DD_INSERT but you don't check the checkbox "Insert", then the record will NOT be inserted into the target table.
The same holds true for the three Update flags and the Delete flag in the appropriate manner.

Q2, SCD without an UPD: if you want to work without an UPD transformation, then you will need separate mappings and sessions for the INSERT records, the UPDATE records, and the DELETE records.

Q3: where's the difference to Q2?

Q4, default values:
Treat Source Rows As = Insert
Insert, Update As Update, and Delete are checked by default.

I am so grateful for your blog. Really looking forward to read more.

Thank you,
Sanjay

See all 3 comments
PeerSpot user
Enterprise Architect at Cognizant
Real User
It's flexible and intuitive, but workflow and the UI needs some improvement.

What is most valuable?

Overall product management, flexibility, intuitiveness and governance.

What needs improvement?

Workflow & UI

For how long have I used the solution?

2 Years

How are customer service and technical support?

4/5

Which solution did I use previously and why did I switch?

I used IBM PIM before, I switched because of customer centricity, enriched out of box product data management features in Informatica PIM.

How was the initial setup?

Straightforward

What about the implementation team?

Vendor team

Which other solutions did I evaluate?

Yes, STEP, Oracle PIM

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
March 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
841,152 professionals have used our research since 2012.
Kholoud  Kandil - PeerSpot reviewer
Data Engineer at BBI
Real User
Provides valuable functionality for task replication, but the user interface needs enhancement
Pros and Cons
  • "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."

What is our primary use case?

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.

What is most valuable?

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. 

What needs improvement?

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.

For how long have I used the solution?

We used Informatica Cloud Data Integration for six months. 

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How was the initial setup?

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.

What other advice do I have?

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

I recommend it to others and rate it a seven. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Yauheniya Sazonava - PeerSpot reviewer
Lead Software Engineer at a tech vendor with 10,001+ employees
Real User
Provides good deduplication capabilities but the UI is outdated and not user-friendly
Pros and Cons
  • "It provides all the typical MDM capabilities like deduplication and machine survivorship."
  • "The UI is terrible and not user-friendly."

What is our primary use case?

We use this solution for MDM in the commercial sector. I'm a lead software engineer for EPAM Systems.

What is most valuable?

The product provides all the typical MDM capabilities like deduplication, machine survivorship, and other things. 

What needs improvement?

The downside of this solution is that the UI is terrible and not user-friendly. The solution was developed a long time ago and it no longer provides a lot of value. Our organization is considering decommissioning the solution or reducing usage. The problems seem to be more about the design and not the tool. The UI and general user experience need to be improved. Making changes on Informatica takes a lot of time compared to making changes on other MDM tools.

For how long have I used the solution?

I've been using this solution for seven months. 

What do I think about the stability of the solution?

I haven't heard any complaints about stability. 

What do I think about the scalability of the solution?




Which solution did I use previously and why did I switch?

Before my time, the company used a legacy MDM solution for dealing with customers. It was created for reporting purposes, to create some compliance reporting, but its functionality didn't allow the addition of more MDM features, so they decided to build a new solution based on Informatica MDM, and from there they basically merged two solutions, the legacy one and this one into Informatica MDM.

How was the initial setup?

The initial setup was carried out prior to my joining the company. 

What's my experience with pricing, setup cost, and licensing?

A lot of the solutions on the market are expensive and Informatica is at the top end in terms of licensing costs. They use a bundle model so you choose what you want to include in your bundle and that's what you pay for.

What other advice do I have?

Informatica MDM is a typical MDM tool. I've worked with others and they are all more or less the same. It requires more work than some other tools in terms of development and adding additional features. It has lots of features and is rated highly by Gartner. 

I rate this solution seven out of 10. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Andre Collin - PeerSpot reviewer
Consultant at Viatic
Consultant
Top 5
A tool with the ability to aggregate and put together data from multiple sources into a single place
Pros and Cons
  • "The ability to aggregate and put together data from around fifty sources into one environment allows us to have a preview of everything in a single place, which is something we did not have previously in our company."
  • "I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required."

What is our primary use case?

I use Informatica MDM to align data in my company.

How has it helped my organization?

The ability to aggregate and put together data from around fifty sources into one environment allows us to have a preview of everything in a single place, which is something we did not have previously in our company.

What is most valuable?

The most valuable feature I see in Informatica MDM stems from everything that touches the area of data governance.

What needs improvement?

I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required.

For how long have I used the solution?

I have been using Informatica MDM for five years. I use the solution's latest version. I am a user of the solution.

What do I think about the stability of the solution?

Stability-wise, I rate the solution an eight out of ten.

What do I think about the scalability of the solution?

Scalability-wise, I rate the solution an eight out of ten.

Around 250 users of the solution exist in my company.

There is a need to use the solution in my company at least three times a week.

How are customer service and support?

I rate the technical support an eight out of ten.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

I have experience with other solutions. I switched to Informatica MDM from other solutions since it offers better scalability options and interoperability.

How was the initial setup?

I rate the product's initial setup a seven on a scale of one to ten, where one is a difficult setup process, and ten is an easy setup process.

My company has deployed Informatica MDM with the services offered by our cloud partner.

Informatica MDM's deployment phase takes around a year to be completed.

Two people, who are data engineers specialized in Informatica MDM, are required for the deployment phase of the product.

What about the implementation team?

Informatica MDM's deployment phase was carried out with the help of my company's in-house team and Informatica's partner.

What's my experience with pricing, setup cost, and licensing?

I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price.

What other advice do I have?

Ideally, only one person is required to take care of the maintenance part of the product, but with the number of terminals where the solution is deployed, there may be a need for three or four people.

I recommend the solution to those who plan to use it.

I rate the overall solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2284368 - PeerSpot reviewer
Data Quality Consultant at a financial services firm with 1,001-5,000 employees
Real User
Top 10
A stable and reliable solution for enhanced data excellence
Pros and Cons
  • "We use it for various use cases, including data provisioning, data validation, continuous monitoring of data quality, and data standardization."
  • "Exploring the possibility of incorporating AI capabilities that can suggest additional rules would significantly streamline our data analysis process following data profiling."

What is our primary use case?

We use it for various use cases, including data provisioning, data validation, continuous monitoring of data quality, and data standardization.

What is most valuable?

We have implemented both data profiling and data quality transformations for data validation. These are the two major components we rely on, with data profiling helping us understand the data's characteristics, and data quality transformations ensuring data validation.

What needs improvement?

Exploring the possibility of incorporating AI capabilities that can suggest additional rules would significantly streamline our data analysis process following data profiling. Many other tools offer this feature, enabling them to suggest rules, which can be generated with just one or two clicks.

For how long have I used the solution?

I have been working with it for almost seven years.

What do I think about the stability of the solution?

Once it was implemented, we din not encounter any stability issues. I would rate it nine out of ten.

What do I think about the scalability of the solution?

The scalability of the solution depends heavily on the design approach. Regardless of the tool used, the effectiveness of the data quality framework hinges on proper design. If the framework is not well-designed, it may not deliver the desired results. I would rate it eight out of ten.

How are customer service and support?

We receive excellent support on a priority basis. I would rate it nine out of ten.

How would you rate customer service and support?

Positive

How was the initial setup?

I would rate the installation and configuration process as moderately complex.

What other advice do I have?

If it has been implemented effectively, I would say it is the best solution. When considering the use of the data governance package, combining Axon ADC and Informatica Data Quality together provides a comprehensive approach. I would rate it eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Chiradeep Bhattacharya - PeerSpot reviewer
Practice Leader at a tech services company with 1,001-5,000 employees
Real User
Top 10
Good customization for data search and sharing; GUI needs to be upgraded
Pros and Cons
  • "Able to customize data search and data sharing."
  • "The GUI needs to be a little more user-friendly and appealing."

What is our primary use case?

We use Axon for controlled and governed data sharing as well as for the policies and principles from a data governance perspective. Our use case was for an airport company and we used Axon in tandem with Datacat Log EDC. We customize data search and data sharing. We have a partnership with Informatica. 

What is most valuable?

The management of the policy is very useful. The ability to customize data search and data sharing is useful. The solution has all the necessary features. 

What needs improvement?

The GUI needs to be a little more user-friendly and appealing. Salesforce, for example, although in a different category, is very user-friendly and I think if they were to include some of the Salesforce principles, it would be helpful. Informatica needs to do a better job in terms of educating users. 

For how long have I used the solution?

I've been using this solution for three years. 

What do I think about the stability of the solution?

The solution is stable and dependable as long as we keep an eye on the servers. 

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and support?

The support process needs to be more agile. 

How was the initial setup?

The initial setup took a few days. It wasn't very complex but there were some initial challenges because we were trying to setup the Informatica Data catalog, EDC, at the same time. The deployment was reasonable but not very smooth. We have around 300 users.

What's my experience with pricing, setup cost, and licensing?

Licensing costs are generally on the higher side.

Which other solutions did I evaluate?

Collibra was a solution we evaluated but Informatica was the final choice.

What other advice do I have?

I rate this solution seven out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Per Olav Nymo - PeerSpot reviewer
Director Consulting Expert at a computer software company with 10,001+ employees
Real User
Strong data management tool that allows all kinds of domain modeling in one system
Pros and Cons
  • "MDM is very stable - it can handle millions of hits daily and still run 24/7."
  • "The on-prem solution is harder to learn than the cloud-based versions."

What is our primary use case?

I use MDM to collect customer information and ensure that there is no duplicate information on our system.

What is most valuable?

The most valuable features are that MDM has a very strong master merchant, and it's possible to model all kinds of domains in one solution.

What needs improvement?

An area for improvement would be that the pricing model is not very visible, which makes it hard to understand how much things will cost. In addition, the on-prem solution is harder to learn than the cloud-based versions. I also understand that Informatica is not porting their on-prem system to cloud, so I would like the new cloud solution to include all the features from the on-prem solution and make it the proper multi-domain MDM.

For how long have I used the solution?

I've been using Informatica for around twenty-five years.

What do I think about the stability of the solution?

MDM is very stable - it can handle millions of hits daily and still run 24/7.

What do I think about the scalability of the solution?

MDM is scalable with no problems.

How are customer service and support?

As a customer, you can raise tickets, but you also have a Customer Success Manager in Informatica who is responsible for customers and helps them get the best value out of their investment. So you can raise your ticket with them, and they will help you with it.

How was the initial setup?

The initial setup is straightforward on cloud, but the on-prem version is not so easy.

What other advice do I have?

Don't underestimate how much work you will have with integration (though this is an issue with every MDM solution, not just Informatica). I would give this solution a score of eight out of ten. 

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.