Try our new research platform with insights from 80,000+ expert users
it_user272106 - PeerSpot reviewer
Graduate Assistant with 1,001-5,000 employees
Real User
It helped us realize our goal of maintaining a distinct (golden) record for better decision making and reporting, but we used to face some Java application problems using it.

What is most valuable?

It allows you to build your own rules to identify the golden records as part of master data management.

How has it helped my organization?

It helped my client, a technology company, to identify a unique customer and remove the redundant customer information. For example, a customer might be linked with a product to the organization directly, indirectly or as a retailer. Informatica MDM helped us realize our goal of maintaining a distinct (golden) record in our database for better decision making and reporting purposes.

For how long have I used the solution?

I've been using it for 15 months.

What do I think about the stability of the solution?

In general, it is good. We used to face some Java application problems, approximately two issues a month.

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 scalability of the solution?

As the data keeps growing, we have to clear temporary storage space. Otherwise, we encountered issues in starting the batch jobs.

How are customer service and support?

Customer Service:

3.5/5.

Technical Support:

3.5/5.

What about the implementation team?

I worked as a vendor for one of my clients. As I heard recently, the contract is still on, so I think we are doing pretty well.

What other advice do I have?

I used this product almost 18 months ago. Informatica is one of the renowned names in Enterprise Information Management and there has been some changes for their MDM product. I would suggest you check their recent upgrades and take an informed decision.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user528747 - PeerSpot reviewer
Senior Consulting Partner at GINNOVATES
Real User
I recommend reviewing and assessing the volume of data you will incorporate into the MDM, because the pricing seems to be based on row count used at the MDM Entities you built.

What is most valuable?

The flexibility to interact with many different sources and targets like Oracle, MySQL , Flat Files, Informix, SAP thru PowerExchange, applying different transformations that you can configure in an intuitive way, gives both business and IT teams the opportunity to track the data lineage and also to provide value to the data workflows you create, integrated to feed the MDM solution together with Data Quality processes.

How has it helped my organization?

The portability to use your integration flows into MDM and Data Quality helps to improve the data stewardship and also provides value for the metadata management you can take advantage of to document your business rules while interacting with different business data.

What needs improvement?

The product ranking we provide is 8 out of 10 -- because there are parts of connectivity with SAP Non-Unicode that are not supported by Informatica, since they only provide connectors to write on SAP Unicode. Then, we had to develop and enable the connectivity to write into SAP Non-Unicode.

Mainly, MDM requires improvement when you need to migrate your version to a later one -- because it is very difficult and takes a lot of time to convert the processes you have already developed and implemented on a previous version, and can cause a need to rework the processes.

For how long have I used the solution?

We've been using the Informatica Solution for Data Integration and Data Quality for 12 years. We've been using MDM for seven years.

What do I think about the stability of the solution?

Sometimes the IDD console connectivity.

What do I think about the scalability of the solution?

The difference between components and functionality from one version to the immediate latest one.

How are customer service and technical support?

It is good, however response time is always depending on the support contract you acquire.

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

SAP MDG. At that point in time, it was not prepared to provide flexible integration and data quality process to generate a 360 view.

How was the initial setup?

The initial setup was kind of complex while polishing the business requirements to be translated into technical flows.

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

I recommend reviewing and assessing the volume of data you will incorporate into the MDM, because the pricing seems to be based on row count used at the MDM Entities you built.

Which other solutions did I evaluate?

Yes -- SAP MDG and IBM MDM .

What other advice do I have?

First, you need to assess the status quo of data integration and data quality at your organization, then, after you settle these strategies and implement the solutions, it is advisable to go for MDM.

If you do it the other way around, it will cause a lot of headaches and will cost you many more resources, time, and overall creditability to generate value beyond just results.

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.
it_user328848 - PeerSpot reviewer
Manager at a tech services company with 1,001-5,000 employees
Consultant
It reduces duplicate, inaccurate, and poor-quality data, but I would like to see more ETL capabilities.

Valuable Features

  • Integration - it provides a single code-base with all data management technologies, and handles all entity data types in all modes (for operational and analytical use)
  • Model-Driven - it models an organization’s business definitions according to its own requirements and style. All metadata and business services are generated on the organization’s definitions. Informatica MDM Hub can be configured with history and lineage.
  • Flexible - it implements all types of MDM styles registry. Reconciled trusted source of truth and styles can be combined within a single hub. Informatica MDM Hub also coexists with legacy hubs.
  • Reporting – it has an integrated Data Stewardship User Interface Application which has been recently integrated with Jasper reports. One of the most powerful open source reporting engines which can provide on demand MIS (Management Information System) reporting

Improvements to My Organization

I've never been a client, but can suggest the usage across industry verticals.

  • Regulatory compliance, such as financial reporting and data privacy requirements
  • Avoid corporate embarrassments. For example, you can improve recall effectiveness and avoid mailing to deceased individuals.
  • Cost savings by streamlining business processes, consolidating software licenses, and reducing the costs associated with data administration, application development, data cleansing, third-party data providers, and capital costs.
  • Productivity improvements across the organization by reducing duplicate, inaccurate, and poor-quality data, helping to refocus resources on more strategic or higher-value activities.
  • Increased revenue by improving visibility and access to accurate customer data, resulting in increased yields for marketing campaigns and better opportunities for cross-selling and up-selling to customers and prospects.
  • Strategic goals, such as customer loyalty and retention, supply chain excellence, strategic sourcing and contracting, geographic expansion, and marketing effectiveness.

Room for Improvement

UI application performance was quite disappointing until v9.0.x, but with 9.5 and later versions, they have facelifted the UI. Still there are some performance improvement scopes.

I would like to see a custom service based integration of MDM Hub with the Informatica Data Director (presently JMS and SIF) and a seamless usage of Informatica 9.5+ versions with other databases such as SQL server which still has quite a few bugs.

I would like to see more ETL capabilities inside the MDM tool to be a self-sufficient in handling data extractions

Use of Solution

I've used it for about five years, including 9.0.x (7/10), and 9.1.x (7.5/10).

Stability Issues

No issues encountered.

Scalability Issues

Sometimes, but it depends largely on the design decisions.

Customer Service and Technical Support

Absolutely brilliant. Their on-demand support is really good speaking from a development team perspective.

Initial Setup

Very straightforward. You just need to finalize the version based on business requirements, and I always suggest you get the latest version. And there is a Product Availability Matrix available which will guide you through the rest of the process.

Disclosure: My company has a business relationship with this vendor other than being a customer: We have a vendor partnership with Informatica.
PeerSpot user
it_user845028 - PeerSpot reviewer
it_user845028Staff Software Engineer at a tech services company with 10,001+ employees
Real User

Hi Mate,

THANKS SO MUCH for sharing this! I would love to buy you a coffee since I now won’t be up all night that has been driving me crazy (until now!!). I just wish I knew what was going wrong but so glad it’s in the right place now! Thanks again:)

The foreign key value stored on the cross-reference (X-ref) is the same as the value stored on the base object. This facilitates certain MRM internal processes on parent merge.
However, it makes it difficult to tie child X-ref’s back to their original parent X-ref.
Delta Detection is done at the Staging level by comparing the Delta column(s) of Current Landing records to those of Previous Landing Table(staging_PRL).
Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.

Thanks,
Rahul

reviewer2074323 - PeerSpot reviewer
Lead Data Engineer at a tech services company with 51-200 employees
Real User
Excellent for extracting technical metadata, but tricky to scale
Pros and Cons
  • "The most valuable feature is its ability to extract metadata from various sources- be it an old SaaS application or the latest cloud application."
  • "The scalability is tough."

What is our primary use case?

The primary use case of this solution is to extract technical metadata, tag the data dictionary, and profiling. We also use it for lineage and relationship aspects.

How has it helped my organization?

I recommend Informatica to my clients based in the finance and banking sectors. It has been very helpful.

What is most valuable?

The most valuable feature is its ability to extract metadata from various sources- be it an old SaaS application or the latest cloud application. They have a custom resource that allows us to customize no matter which source system we have, and we can customize it to extract the technical metadata.

What needs improvement?

They are moving from on-premises to the cloud. I expect all the on-premises features in the cloud version as well.

For how long have I used the solution?

I have been using the product since 2019.

What do I think about the stability of the solution?

It is a perfectly stable solution and a leader in data governance tools in the current market.

What do I think about the scalability of the solution?

The scalability is tough. For example, if you want to increase the scalability in the middle of the project, it would be a challenging process, but it is doable. As consultants, we analyze the requirements from the client end and, based on that, suggest the infrastructure for scalability.

How are customer service and support?

Customer service is a piece of cake if you are a premium member. You need to raise a ticket, and they will immediately respond. For example, they will let you know if it is a limitation; if it is a bug, they will provide you with emergency bug fixes.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is easy. If we compare version 10.4 and version 10.5, they had a major architectural change in terms of infrastructure. The setup for version 10.5 became easier.

What about the implementation team?

The deployment was straightforward, and it took 10-15 minutes to deploy the solution, including migrating technical metadata (importing and exporting).

What other advice do I have?

I would recommend that rather than implementing it on a complete whole enterprise project, start with some small system or a small project first. And from there on, you can move on one step at a time.

I would rate the product an 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: Partner and consultant
PeerSpot user
Architect at Wipro
Real User
Best tool for matching capability and handling large volumes
Pros and Cons
  • "Informatica MDM stands out as a tool that can give you the flexibility needed for doing channel-specific data quality or business validation."
  • "The configuration process is pretty lengthy and challenging and could be made easier to understand."

What is our primary use case?

Typical use cases for Informatica MDM include consent management (for a large telecom vendor in Australia), master-data consolidation and analytics for vendors, facilitating vendor onboarding, and syndicating and automating global data synchronization networks.

What needs improvement?

The configuration process is pretty lengthy and challenging and could be made easier to understand.

For how long have I used the solution?

I've been using Informatica MDM for over ten years.

What do I think about the stability of the solution?

Informatica MDM is a very stable product.

What do I think about the scalability of the solution?

Informatica MDM is highly scalable - we've set it up for a customer with over a hundred million customers, and the system worked quite well.

How are customer service and support?

Informatica's technical support is great - I was amazed by the quality of their technical people and the support they provide, as well as their willingness to provide it.

How was the initial setup?

Because it's on-prem, the initial setup is of medium complexity.

What other advice do I have?

Informatica MDM stands out as a tool that can give you the flexibility needed for doing channel-specific data quality or business validation. I don't think any tools come near it in terms of its matching capability and the volume it can handle. Unless your budget is a constraint, it's definitely the way to go. I would give Informatica MDM a rating of nine 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
ChristopheFournel - PeerSpot reviewer
Fondateur at Data Integration Consulting
Real User
Top 5
The data integration features are good and the technical support is fast and effective
Pros and Cons
  • "The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
  • "I would also like to have profiling functionalities and quality transformations in the cloud."

What is our primary use case?

We use Informatica Cloud Data Integration mainly for monthly mapping tasks. We work with it on cloud because we help customers to use the solution and to integrate it on their database and on their information systems.

What is most valuable?

The features I find most valuable is the synchronization, verification, functionalities and all the data integration features. I have been academically trained and earned the Cloud Academy badges 101 and 201. Currently, I am training to use this solution in real-time.

What needs improvement?

It's very easy to develop with the solution whenever we have an evolution for the data integration. Perhaps the web services need to improve because when you create a new data file and add some changes, we must edit it and create a web service transformation again. So, in my opinion, the functionality is bad and it needs to improve to make web service transformation better and easier.

For how long have I used the solution?

I have been working with Informatica solutions for more than 16 years now.

How are customer service and technical support?

I have developed a good relationship with the technical team and they usually assist me immediately whenever I have an issue.

What other advice do I have?

On a scale from one to ten, I rate this solution an eight. I haven't seen the functionalities of this tool yet. The data quality is good but I still need to test the B2B gateway of the data quality. I would like to have profiling functionalities and quality transformations in the cloud so that I can directly integrate quality transformations inside the cloud. In the next version, I would like to have more tools for monitoring and perhaps also a system dashboard on our homepage.

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller.
PeerSpot user
it_user628038 - PeerSpot reviewer
Senior Manager Global Business Services at a tech services company with 501-1,000 employees
Consultant
It has no complex software nor does the startup need to be installed. It is easy to share with others.

What is most valuable?

It is a cloud-based solution. This means it has no complex software nor does the startup need to be installed. However, a cloud agent is required.

How has it helped my organization?

Like most cloud-based solutions, it is easy to share with others. For example, let's say I am working on a site and decide to hand-off to another team member. He can essentially pick up where I left off, provided that he has the same set of files.

What needs improvement?

Informatica goes down for maintenance quite a lot due to the upgrades. They also need to improve their security. As an administrator, I could very easily make connections to other people's machines through their agent without their knowledge.

For how long have I used the solution?

I have used this solution for two years.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

There is a slowdown when using the mapping feature. This may be due to the processor's speed or may be a result of the complexity of the browser.

How are customer service and technical support?

I would give the technical support a rating of 9/10. They are very good, once they are aware of the issues. However, sometimes we need to fill out multiple help desk tickets and give them reminders in order to get an active response.

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

We are partners with a number of different companies. This is the first cloud-based solution. It serves the client's needs well, as the solution is not overly complex, such as during replication between different databases or systems.

How was the initial setup?

The setup was very straightforward. Once the agent is installed, you can then be up and running.

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

We work with Informatica to establish the pricing and licensing fees. I personally have not sold this product to clients, but I have been involved with presales and demos.

Which other solutions did I evaluate?

We chose to be Informatica partners, so we just ended up with this version.

What other advice do I have?

Understand the needs of your organization. I strongly advise an understanding of the Informatica PowerCenter, so as to achieve the full effectiveness of this tool.

For simple replication, it works well. However, there are some other free tools that can also do the trick of replication just as nicely.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are Informatica Partners.
PeerSpot user
Enterprise Architect at a consumer goods company with 501-1,000 employees
Real User
Comes with a lot of connectors, and it is easy to set it up and create integrations
Pros and Cons
  • "We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
  • "Its pricing model can be improved. The response time from technical support can also be improved."

What is our primary use case?

We use it to take data from one source to another.

It's a subscription service. It's in Informatica's cloud, and because we have the cloud version, we are up to date in terms of its version.

What is most valuable?

We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors.

What needs improvement?

Its pricing model can be improved. The response time from technical support can also be improved.

For how long have I used the solution?

I have been using this solution for a little over three years.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

It is easily scalable.

How are customer service and support?

It is not great, but it is good. Sometimes, they take a lot of time to respond.

How was the initial setup?

It was really easy to set up the product.

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

Its pricing model can be improved.

What other advice do I have?

I would recommend this product. From a technical point of view, it's a great product. It's very user-friendly. It's really easy to create integrations, and it's very stable.

I would rate it a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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.