Informatica Intelligent Data Management Cloud (IDMC) Reviews

 A stand-alone application used for any integration with third party tools, like Oracle, it may be SAP, or it can be their local in-house build, or HRMS. It can be any application from A to Z. But this acts like in the web services. 

The data mapping capability is a valuable feature. 

Certain applications aren't accepted. For example, for IBM applications, it takes a lot of time. And certain applications are not being synced with the ION.

I have been using Informatica Cloud Data Integration for two and a half years. 

Its a very stable solution. 

There are twenty five customers at present. 

The initial setup is straightforward. The deployment takes two hours time. 

It's an expensive solution. 

Overall, I rate the solution an eight out of ten. 

It's about mastering various domains. For example, an organization might want to master customer data residing within their IT landscape. This includes all master attributes related to customers, like name, email ID, phone number, address, and potential information like stores they visit. Ideally, if the organization also stores data related to those stores, all that information, files, and everything would be included. So, these master attributes would lie within the MDM system.

Here's where things get interesting. I'd bring this data from disparate sources. For example, accounting systems hold phone numbers, email addresses, and maybe even bank information (just an example). 

But another system, like the ER system, might have different information, like the customer's spouse. So, I'd likely get streams from both these systems, but there might be an additional attribute in the ERP system, like the spouse's name.

Now, looking at all these different attributes lying in different systems, one system might have my name as "Raja S.," while another might have it as "Raja Soni." So, the question becomes: are Raja S. and Raja Soni the same person? How do you identify them from these records?

They try to match these records based on phone numbers or any other common attribute between the two systems. Then, I would have a complete record in MDM, which is called the "Golden Record" - the single version of truth within the system.

Furthermore, MDM can also contain additional attributes that the ERP or accounting systems didn't have. So, imagine ten different applications or data sources feeding customer information. I can gather all of that information and create a single version of the truth for a particular customer within the MDM system.

Additionally, if I want my customers to update any information, I can provide a form where they can enrich their data. For example, they could potentially enter their Social Security number (although this wouldn't be common practice). This is just an example of how someone might want to collect this information. So, I can create a form and say, "Okay, can you directly feed this into the MDM system?" This becomes an enrichment opportunity as well.

With Informatica MDM, before you consume the data, you need to check what kind of data it is. There could be some systems where the first name is missing, or the last name is listed as "missing." 

This is where, before consuming or ingesting data into any MDM system, I can filter it out or rather do profiling using Informatica's data quality tool, which is a different tool called IDQ. I can profile the data, okay, and see the current state of the data from our system, any other database, or any source system. 

This is where I'll identify issues like missing phone numbers, incorrect cities, and other things.

So, when I see that the data is incorrect or incomplete (not just incorrect, but also incomplete), I can go back to the source system based on these profiling reports. I would say, "Source XYZ, you have missing data. Can you please ensure that you send it?" So, when I ingest data into the MDM system, I will only ingest it with certain rules. 

These rules define that only records with a first name, last name, city, phone number, and email address should get into MDM. If any of this is missing, I'm not going to let it get into the system.

I would ask the business to review those and then probably ask the system to correct them and then feed them again until the defined criteria are achieved. That's how I improve data quality using Informatica MDM.

Plus, I can also decide that once the data is in MDM, it can feed back to these source systems from where it was originally consuming the data. So, whatever is corrected gets looped back to these sources if they allow me to publish it to them. 

Then, this automatically becomes a cycle: data comes in, gets a data quality check, then enters MDM, and then can be fed back to the source systems if they accept it.

First and foremost, data profiling is a very important aspect, because it allows me to understand the state of the data from the different source systems and applications I'm going to pull into MDM. This is crucial, as it helps me understand the existing data landscape.

Next, Informatica MDM allows you to perform fuzzy matching. Like the example of Raja S and Raja Soni mentioned above. With fuzzy matching, I can define a threshold, and the system will let me know whether these two records are the same or not. 

This is where I think MDM shines - with its strong fuzzy matching algorithm. This is the essence of Informatica MDM. Based on these results, I can write our match conditions and then perform the corresponding data management activities.

When it comes to how data is governed - how accurate it is, what's missing, and what's not.

There are other Informatica tools involved: Informatica Enterprise Data Catalog (EDC) and Informatica Axon, which is specifically a governance tool. With these tools, users can understand data quality. 

Data quality, Informatica EDC, and Axon work together - they "talk" to each other. The moment Axon identifies that data is bad, incomplete, incorrect, or whatever, the governance tool allows you to monitor all of these things and feed them back into the organization.

For example, if someone within the organization is using the governance tool, which is connected to data quality, they might realize: "This particular source isn't giving me certain information, like city data. But I need city information for my XYZ data usage. So, I should focus on another data source or application where customer cities are available." Based on this, data governance can be implemented, and workflows can be established.

MDM also provides workflows. When records come in or if a customer wants to update a record directly in MDM, different personas can be defined. 

A workflow would then be triggered, and someone could review the data being fed through these forms or sources. They might reject or accept it based on predefined criteria. This is how data entering MDM is governed, ensuring everything is correct and meets organizational standards.

I feel the out-of-the-box APIs or the API management could be improved slightly from their current state. It could be more user-friendly.

In future releases, I would love to have more reports and dashboards available within Informatica MDM specifically for master data reporting. 

Currently, there aren't many reporting functionalities offered. While it's true that reporting isn't a core feature of any MDM system, they do have basic dashboard reports. I'd like to see them made more customizable and offer more options for creating reports.

I have been working with it for more than ten years. 

Stability-wise, it's also pretty decent and stable. So, I would rate the stability an eight out of ten. 

I would rate the scalability an eight out of ten. It's pretty good because mastering data across various domains like suppliers is crucial. Informatica is probably the best when it comes to multi-domain solutions.

There are around 500 end users. 

The quality of resources is good, and the time is acceptable. However, the initial quality of resources assigned to support tickets could be better.

Neutral

I'd rate Informatica higher. The biggest reason is the multi-domain capability. Not all vendors offer that flexibility. 

Additionally, Informatica is actively working on a clear, built-in AI engine for its tools. The SaaS version functions well, and they've introduced CLAIRE AI engine for on-premise versions. This engine learns from usage within your organization, further enhancing the experience.

The complexity of the setup depends. For example, it is different for the on-premise version. Now, Informatica has mostly shifted towards a SaaS model, which is essentially plug-and-play. You just need to log in and start using it, making it very simple. 

However, for the on-premise version, the setup process requires some expertise. It's not something just anyone can do. You need experts in place to handle the setup effectively.

Within the organization, businesses have benefited significantly. Tasks that used to take four to six weeks now only take three to four days.

Pricing can vary because Informatica doesn't have a standard price across the board. It depends more on the sales representatives in different regions. They essentially call the shots and decide the discount percentage for each customer.

So, it's quite flexible, like a bargain, in a way, but it depends on the salesperson.

Overall, I would rate the solution an eight out of ten. 

I absolutely recommend it. If you're looking to implement a Master Data Management (MDM) solution, Informatica MDM is the most flexible tool available in the market. Compared to its competitors, it offers several advantages.

Firstly, it provides the option to move seamlessly between on-premise and SaaS versions. If you start with the on-premise version, you can easily transition to the SaaS model later, if needed. 

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 the product to define policies and for data discovery management.

It is complicated to establish the lineage in EDC using PowerCenter mappings. We have to do the process manually every time. This particular area needs improvement.

We have been using Informatica Axon for five years.

It is a stable platform. However, we need to raise the ticket even for the smaller issues. There needs to be proper documentation available. They should provide enough information.

We have eight to ten customers for Informatica Axon. It is a scalable product.

The technical support team takes time to complete the debugging process.

The initial setup process is fine, but there are a lot of infrastructure issues. It includes errors on the node cluster for EDC. Deployment is easy, but debugging is time-consuming. Whenever we raise the ticket to the support team, they take two to three days to evaluate the issue.

The licensing price of the product depends on the organization's requirements. It is less costly than Collibra.

I recommend Informatica Axon to others and rate it a seven out of ten.

I am a consultant and I use the solution to scan databases and lineages for my clients.

We can scan anything. We can scan reports, XML and JSON files also. That's a good thing about the Informatica Enterprise Data Catalog.

IEDC can improve the comparison of lineages, which is one thing I see in other data catalog tools that Informatica does not have, basically data catalog tools.

I have been using Informatica Enterprise Data Catalog for three years.

I rate the stability of the solution an eight out of ten.

I rate the scalability an eight out of ten. We currently have ten to 15 users using the solution and our client is a medium-sized business.

I rate the initial setup a seven out of ten, because it is pretty straightforward. The solution took two to three days for the initial setup.

When deploying IEDC, one should have a server ready and a lot of open ports, but otherwise it is straightforward.

I rate the solution an eight out of ten.

Our organization operates in the financial industry and we utilize the solution to gather and incorporate high-quality data, making it available in the data marketplace.

We are satisfied with the entire solution in its current state and eagerly anticipate its transition to cloud technology.

The tools required to migrate existing mappings and server rules through cloud data quality are not available. Additionally, there is no alert mechanism in place for the existing IDQ that can be integrated with email alerts.

I have been using the solution for over ten years.

I give the stability a ten out of ten.

I give the scalability an eight out of ten.

The technical support responds quickly.

Positive

The initial setup is straightforward. I give the setup a nine out of ten. The deployment took around one and a half hours and two administrators.

The implementation is completed in-house.

I give the solution a ten out of ten.

We have a two-person admin team that takes care of the maintenance.

I would recommend Informatica Data Quality as it has been consistently identified by Gartner as one of the leading solutions in the market.

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. 

Informatica MDM is used for all data management practices use cases, such as centralized master data, cataloging, and metadata management.

The most valuable features of Informatica MDM are its reliability, match functions, and integration capabilities. The out-of-box functionality of deduplication and built-in data models ensure faster implementation.

Informatica MDM could improve the interdependency with integration. The solution sometimes becomes a bit difficult to change considering a lot of interdependency with the integration. There can be some improvement in the workflows and they can introduce more artificial intelligence.

In a future release, Informatica MDM could improve the UI and create an easier way to change the existing setup.

I have been using Informatica MDM for approximately 20 years.

Informatica MDM is stable.

Informatica MDM is scalable. However, sometimes it becomes difficult to perform the change. When it comes to volumes, it's fantastic and very fast.

We have an entire organization of approximately 80,000 using the solution.

The technical support from Informatica MDM is good.

I have previously used IBM, SAP MDG, and Parallels.

If an organization has a quite complex setup with different systems then I would recommend Informatica SAP MDM because of the integration capabilities. If the organization only has one ERP, then it's not advisable to use Informatica MDM because SAP MDG is quite integrated with SAP.  The IBM solution I use quite a long time before, but I don't know how they are doing today.

The setup of Informatica MDM is easy.

We have two people that do the development and maintenance of the solution.

Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing.

Whether to use Informatica MDM or not is highly depends upon what is the use case and the core structure you have in the organization. If you have a small company with limited systems, then you use something lightweight MDM. Where you have more than one ERP, all technology interacting with each other, then I would suggest a solution, such as Informatica MDM, it is a good deal.

I rate Informatica MDM a seven out of ten.