- Data Replication Tasks: Easy to configure, for the most part reliable, and also what my system deals with the most.
- REST API: Excellent for scripting control and reporting mechanisms
Informatica Cloud System Lead at a pharma/biotech company with 10,001+ employees
Some of the valuable features are data replication tasks and REST APIs.
Pros and Cons
- "REST API: Excellent for scripting control and reporting mechanisms"
- "User/group administration could use improvement."
What is most valuable?
How has it helped my organization?
Ease of use, configurability, maintainability, and good aesthetics make for a more fluid functional process.
What needs improvement?
User/group administration could use improvement.
For how long have I used the solution?
I have been using this solution for 15 months.
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
December 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,371 professionals have used our research since 2012.
What do I think about the stability of the solution?
No stability issues as of yet.
What do I think about the scalability of the solution?
The REST API could have the ability to generate tasks, and certain manual functions like updating/deleting data replication tasks could come with a bulk update option somehow.
How are customer service and support?
I would give technical support a rating of 10/10. They are just incredible.
Which solution did I use previously and why did I switch?
I inherited this solution in its infancy, but I don't have the details.
How was the initial setup?
The setup was straightforward.
What's my experience with pricing, setup cost, and licensing?
Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful.
Which other solutions did I evaluate?
I did not evaluate any alternative solutions.
What other advice do I have?
Pose any and every question/doubt/concern to the team, especially with respect to licensing. They are excellent in their communication.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Informatica Lead - Architect at a pharma/biotech company with 1,001-5,000 employees
We value the data replication and data sync jobs. We would like to see stable connectivity.
Pros and Cons
- "Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
- "Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
What is most valuable?
I particularly value data replication and data sync jobs. Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job.
I also appreciate the flexibility of the reset target option to reflect the source object structural changes to be implemented on the target database table side. This is awesome.
How has it helped my organization?
It helped the organization to always have the backup of SFDC data in-house for data warehousing purposes.
What needs improvement?
- Stable connectivity: No matter what, our business requires steady, stable, and consistent connectivity. Regardless of how many columns in an SFDC object or how many rows in an SFDC object, we must have steady connectivity.
- Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations.
For how long have I used the solution?
I have used this product for five years.
What do I think about the stability of the solution?
There are stability issues, especially when connecting to SFDC. At times, we do see connection time-out errors, though we have changed the properties in Informatica secure agent properties. We have also noticed that sometimes it does not cooperate well with SFDC read and write operations.
What do I think about the scalability of the solution?
We did not encounter any scalability issues.
How are customer service and technical support?
Technical support can be described as average.
Which solution did I use previously and why did I switch?
The client was using data loader, but as the demand increased to replicate the data and frequency of data replication, they moved on to Informatica Cloud.
How was the initial setup?
The initial setup was pretty straightforward. You just have to login to the server where you want to download, install, and run the Informatica secure agent
What's my experience with pricing, setup cost, and licensing?
The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous.
Which other solutions did I evaluate?
The client had already purchased this solution and it was up and running in all of their different environments
What other advice do I have?
It’s a great product which allows the connection to a number of cloud based technologies such as Workday and Salesforce.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
December 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,371 professionals have used our research since 2012.
Director at a tech company with 10,001+ employees
Integration is flexible and loosely coupled.
Pros and Cons
- "It is quite easy to use and flexible."
- "The vendor should have more training resources: online classes, free tutorial videos, etc."
What is most valuable?
It is quite easy to use and flexible.
How has it helped my organization?
With recent versions of cloud-based products in use for all applications, it provides flexibility in integrating the different applications. With AWS S3 and Informatica, integration is flexible and loosely coupled.
What needs improvement?
The vendor should have more training resources: online classes, free tutorial videos, etc.
For how long have I used the solution?
I have used this product for six months.
What do I think about the stability of the solution?
We have not yet had any issues with stability, as we are just beginning our journey.
What do I think about the scalability of the solution?
Yet to be determined.
How are customer service and technical support?
So far, so good.
Which solution did I use previously and why did I switch?
We recently started migrating and using SaaS-based application solutions. On-premises, there are multiple integration platforms being used, such as BizTalk and SAP PI.
How was the initial setup?
Since it is SaaS based, no setup was required, except for the installation on a secure agent.
What's my experience with pricing, setup cost, and licensing?
I was not involved in pricing and licensing.
Which other solutions did I evaluate?
I was not involved in the selection process.
What other advice do I have?
It is quite useful and flexible compared to other vendors in terms of cost of implementation and use case.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Manager Global Business Services at a tech services company with 501-1,000 employees
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.
Tech Lead at a tech company
Provides the basic functionalities to implement ETL logic. The error information provided is not informative.
Pros and Cons
- "The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
- "The error information provided is not informative, as compared to Power Center."
What is most valuable?
The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic.
How has it helped my organization?
- Provides the basic functionalities to implement ETL logic
- Can be accessed from a web browser or from any device with internet connectivity.
- We need not be in the office to perform tasks
- We use it to run jobs, even at midnight, based on the requests of the business users.
What needs improvement?
It needs lot of improvement from the admin to the development side. There are many known issues while mapping. The error information provided is not informative, as compared to Power Center.
For how long have I used the solution?
I have used this solution for around six months.
What do I think about the stability of the solution?
There used to be performance issues. Throughput is slow when we do not have the Informatica Secure Agent running on the DB instance.
What do I think about the scalability of the solution?
It has not yet been identified.
How are customer service and technical support?
I would give the technical support a rating of 2/5. Informatica doesn't provide on-call or technical support for AWS instances. We need to rely on responses from the forums if we raise any queries.
Which solution did I use previously and why did I switch?
I have used Power Center. I switched to the Informatica Cloud (IC), as it is cheaper compared to Power Center. It gave us a chance to explore a new tool and technology.
How was the initial setup?
The setup is straightforward
What's my experience with pricing, setup cost, and licensing?
It is cost effective and an easily accessible tool.
What other advice do I have?
It totally depends on the business requirements and the budget. I have been working on Informatica for more than nine years, and I recommend using their products.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Delivery Manager of PIM at a tech vendor with 1,001-5,000 employees
Valuable features include: flexible task-based workflows, dashboards and graphs, and channel specific exports.
Valuable Features:
New ProductBusiness user-friendly web user interface, dashboards and graphs, flexible task-based workflow, ability to use library of out-of-box data quality rules or define custom DQ business rules, channel specific exports, fully customizable BPM workflow engine for task management and notifications, enterprise scalable performance, flexible data model and hierarchy management.
Improvements to My Organization:
Our Implementation Delivery team is able to design and implement robust business solutions for PIM and Product MDM for our many large, global Retail, Manufacturing and Distribution clients.
Room for Improvement:
Additional pre-built, "plug and play" out of the box functionality should continue to be built. Additional pre-built capabilities and connectors to better integrate with social product data for ratings/reviews, additional Ecomm and external DAM solutions.
Use of Solution:
Approximately 4 years.
Deployment Issues:
Some technical issues have been encountered and resolved during migrations and cutovers.
Stability Issues:
We have seen stability issues with older versions, particularly 6.x and below. Newer versions have proven stable.
Scalability Issues:
Scalability is on par or better than any other solution on the market. One of our customers has over 21 million SKUs in PIM, and others have 100's of international users.
Disclosure: My company has a business relationship with this vendor other than being a customer. Infoverity is an implementation partner of Informatica and many other PIM/MDM best-in-class vendors
IT Director of Data and Analytics at a marketing services firm with 501-1,000 employees
Excel-like, so adoption is easy with users.
What is most valuable?
Excel-like, so adoption is easy with users. The exporting and importing of information makes data management easier.
How has it helped my organization?
We have been able to assimilate our vendor products enhance the data for our web sites and other internal systems and then sync the data out to our customer facing systems with updated prices and product information. It is helping our purchase orders to be more accurate to our vendors.
What needs improvement?
The job scheduler needs improvement.
For how long have I used the solution?
3 years
What was my experience with deployment of the solution?
The deployment went very well. We contracted with a smart partner who specializes in product information data implementations. This made all the difference.
How are customer service and technical support?
Customer Service:
Excellent
Technical Support:Excellent
Which solution did I use previously and why did I switch?
This was new for us to move our product data to this system.
How was the initial setup?
Our data was complex so our implementation was. Our contractor who had worked with this tool as an implementer really helped us to configure the data.
What about the implementation team?
Vendor team.
What was our ROI?
We reduced product data setup time from 1.5 hours to 30 minutes.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Manager at a tech services company with 1,001-5,000 employees
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.
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: December 2025
Product Categories
Data Management Platforms (DMP) Cloud Master Data Management (MDM) AI Data Analysis Data Observability Product Information Management (PIM) Test Data Management Services Integration Platform as a Service (iPaaS) Metadata Management Data Masking Data Integration Test Data Management Data Governance Cloud Data Integration API Management Business-to-Business Middleware Business Process Management (BPM) Data QualityPopular Comparisons
Microsoft Azure API Management
Microsoft Purview Data Governance
Informatica PowerCenter
MuleSoft Anypoint Platform
SAP Signavio Process Manager
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Reltio: Question about Master Data Management Capabilities
- Has anyone compared Informaticta to IBM to SAS for an MDM solution?
- Informatica MDM or Hybris PCM? Buy vs. Build?
- Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
- How does Microsoft MDS (vs Informatica MDM) fit with Azure architecture?
- Which is the best choice for cloud integration: AWS Glue or Informatica Intelligent Cloud Services (IICS)?
- Looking for feature comparison: Collibra Governance vs Informatica Axon vs IBM Data Governance vs ASG Enterprise Data Intelligence
- What are the biggest benefits of using Informatica Cloud Data Integration?
- Is the support provided by Informatica Cloud Data Integration helpful?
- What industries does Informatica Cloud Data Integration serve?














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