Informatica Intelligent Data Management Cloud (IDMC) Reviews

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. 

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

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

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.

I've been using this solution for seven months. 

I haven't heard any complaints about stability. 

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.

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

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.

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. 

I use Informatica MDM to align data in my company.

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.

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

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

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

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

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.

I rate the technical support an eight out of ten.

Positive

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

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.

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

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.

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.

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

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.

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.

I have been working with it for almost seven years.

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

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.

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

Positive

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

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.

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. 

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. 

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. 

I've been using this solution for three years. 

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

The solution is scalable. 

The support process needs to be more agile. 

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.

Licensing costs are generally on the higher side.

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

I rate this solution seven out of 10.

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

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.

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.

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

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

MDM is scalable with no problems.

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.

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

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. 

The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations.

The designer allows for the creation of mappings to be leveraged as templates. Within the templates, parameters can be set up that serve as variables for deployment to mapping configuration tasks.

Mapping Configuration Tasks, MCTs, are specific uses of a mapping to fit a situation or set of circumstances.

With my firm, our use of Informatica Cloud is primarily to implement a set of financial integrations from various accounting systems into a Salesforce environment.

By leveraging Informatica Cloud Mapping Designer, we were able to create sets of reusable templates that were source agnostic. This made supporting the integration for hundreds of customers feasible with just a small team of integration specialists.

There are a small number of UI bugs that occur on occasion.

In several browsers, such as Chrome, elements of the UI can disappear when navigating through steps in any of the integration tasks' wizards. Additionally, on data synchronization tasks, the source fields in a mapping can disappear altogether as well.

Also, the product is so new, that any points not covered in the documentation prove difficult to research online.

I have been using Informatica Cloud for two years.

There is currently no active failover for Informatica Cloud Secure Agents. This is the service used to process source information in client environments.

Therefore if a Secure Agent running a job goes down, the job will not wait or failover to another agent. It will fail as well.

We have not had any scalability issues so far.

Technical support is stellar. The time zone can prove an issue, as their support is all in Pacific Standard Time (PST).

We did not have a previous solution.

The installation and configuration of the Secure Agent is a breeze.

Jitterbit, SnapLogic, and MuleSoft were evaluated.

Informatica is likely to make this their flagship product. It is a solid investment to move to this ETL now. There will continue to be a slew of new features and product improvements in the near future that may increase the cost of the license.

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.

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.

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.

Approximately 4 years.

Some technical issues have been encountered and resolved during migrations and cutovers. 

We have seen stability issues with older versions, particularly 6.x and below. Newer versions have proven stable.

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.