Informatica Intelligent Data Management Cloud (IDMC) Reviews

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.

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 Informatica Cloud Data Integration to migrate to the cloud, upgrade our data warehouse, and implement master data management. It helps us with in-depth analysis, leveraging shared history, and addressing data governance questions.

The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services. It excels in mapping development, searching for contracts in data governance, creating data quality rules, and designing merging processes. The ability to identify duplicates and automate analysis coverage is particularly beneficial. Additionally, the cost-effective option of using Informatica Cloud Data Integration for smaller projects or departments has made it more accessible and attractive for experimentation.

One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities. For example, for master data management, having additional accelerators could streamline implementation. Additionally, enhancing compatibility with metadata sharing across different applications, similar to what is achievable with PowerCenter, would further enhance the product's capabilities.

I would like to see more connectors for on-premise databases in the next version of Informatica Cloud Data Integration. Currently, CDI free is a great option for cloud integration, but expanding the connectors to include databases like Oracle or MySQL for on-premise environments would make the tool more versatile and accessible for smaller businesses or those not fully in the cloud.

I have been working with Informatica Cloud Data Integration since 2016.

Informatica Cloud Data Integration has been generally stable, with occasional editor issues. However, SLAs are consistently respected, and we typically experience minimal downtime, averaging around two to three hours per month.

The scalability of Informatica Cloud Data Integration is high. With advanced pushdown optimization, it performs well in various environments like Snowflake and AWS. It is suitable for companies of all sizes; for small to medium enterprises, starting with fewer IPUs is cost-effective, and scalability allows for growth as needed.

I would rate Informatica's vendor support as a seven out of ten. It is generally good, but there is room for improvement, especially as they shift focus from on-premise to the cloud. We often find answers in the community for software issues, but sometimes we encounter challenges that require official support tickets.

Neutral

The initial setup for Informatica Data Integration is straightforward. Deployment is simple, involving exporting and importing development processes. The ability to pilot the Informatica Data Integration platform from various APIs makes continuous integration and deployment easy to manage through API calls.

I would rate Informatica's pricing as an eight out of ten in terms of affordability. Starting with a small IPU volume is cost-effective, and as we grow, the pricing adjusts favorably based on consumption, which makes it reasonable for our needs.

I would rate Informatica Cloud Data Integration overall as an eight out of ten. It is a comprehensive platform covering data integration, API integration, data quality, data governance, master data, and privacy tools—all within one platform. The accessibility to all functionalities with the purchase of IPUs is a significant advantage compared to the past where certain features required additional payments and permissions.

My company does not specifically focus on selling the solution to a particular sector. My company generally sells the solution to various sectors, including manufacturing and finance.

Informatica Enterprise Data Catalog is a compact tool. Many products operate as a data system solution or as a data catalog tool. The product is helpful when it comes to data transformation. If you would like to solve specific data-related problems, Informatica Enterprise Data Catalog can serve as a useful product.

I cannot specifically point out an area in Informatica Enterprise Data Catalog that needs improvement since it properly functions as a data catalog tool. You cannot use something like Atlas to get catalog ranges, making Informatica Enterprise Data Catalog a comparatively powerful tool. The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future.

If I want to get some extra features in the product, I can contact Informatica's research and development team, who can add some new features to the product and make the tool available in the market.

I have been using Informatica Enterprise Data Catalog for more than ten years. My company has a partnership with Informatica.

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

Though there are some bugs in the solution, Informatica's research and development team, along with Informatica's customer service team, supports my company in solving such bug-related issues.

Scalability-wise, I rate the solution a seven out of ten.

Informatica Enterprise Data Catalog can be a good solution that is really easy to use when it comes to enterprise-sized companies, but it may pose some challenges for small and medium-sized companies.

Most companies to whom my company provides the solution are enterprise-sized businesses.

I rate the technical support a ten out of ten. My company has a partnership with Informatica, and we provide Informatica's products to the end users or customers. Informatica has to provide my company with good support in order to hold on to its customers who deal with my company.

Positive

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

Most of the companies to whom my company provides the solution deploy it on an on-premises model. My company also sells the cloud version of the solution while also offering our customers the option to move from on-premises to the cloud version of the solution.

My wife runs a pharmacy, and she uses an ERP solution for sales-related activities, the data of which I can move to the cloud in ten minutes if she chooses Informatica Enterprise Data Catalog.

With Informatica Enterprise Data Catalog, measuring the return on investment can be hard. I rate the return on investment a seven on a scale of one to ten, where one is zero return on investment, and ten is a hundred percent return on investment.

The price of the product is something that may vary from customer to customer. I rate the product's pricing a five on a scale of one to ten, where one is cheap and ten is expensive.

If a customer or business wants to easily maintain their data domains, they can opt for Informatica Enterprise Data Catalog.

I rate the overall product an eight to nine out of ten.

We use Informatica MDM to enable the master data for getting the customer's product 360.

Informatica MDM has data quality, mastering the data's capability.

Inserting the GenAI into the master data management will reduce the overall effort of operational activities.

I have been using Informatica MDM for five to six years.

Informatica MDM is quite a stable solution. I rate Informatica MDM a nine out of ten for stability.

Informatica MDM is quite a scalable solution. Most of our clients for Informatica MDM are enterprise businesses.

Usually, it takes six to eight months to deploy Informatica MDM.

Master Data Management is always only 20% implementation; the remaining 80% defines all other components. So, if users have the right process, the tool will do its job. The tool will do whatever we give input for.

Informatica MDM is quite a good product in terms of mastering all the data and ensuring that we will be able to get a 360 degree of the master data.

Overall, I rate Informatica MDM a nine out of ten.

We are using it for multiple purposes, such as real-time data integration and data migration. It allows seamless integration of various cloud-based applications and services.

The solution provides increased efficiency while still being user-friendly and easy to operate. It includes built-in features that ensure data consistency and accuracy, resulting in excellent data quality. 

It would be helpful if there was a GenAI feature integrated into the system, especially regarding the data quality. It would ensure improved decision-making processes and better insights. 

I have been using this solution for three to four years.

Our experience with the stability has been quite good. I would rate it nine out of ten.

The solution's scalability is one of its key aspects. It facilitates the scaling of data integration capabilities based on customer's needs. 

The deployment process depends on the client's requests. If it requires complex tools and features, the process will take longer. But for normal operations, it is really easy and not very time-consuming.

I have been very satisfied with the feedback I was getting with Informatica Cloud Data Integration. Its automated performance enables the processing and integration of large volumes of data quickly and efficiently. I would rate this solution nine out of ten. 

Test data management is a common use case. When conducting testing in lower environments, we want to avoid exposing sensitive information. To achieve this, we use Data Masking to modify the data. 

For example, we change personally identifiable information, phone numbers, and emails so that they cannot be viewed. The modified data retains the structure and format but doesn't reveal the actual information.

The tool is mainly valuable for testing teams, as it helps protect sensitive data during testing. It can also be used to mask production data for different users, ensuring that only authorized individuals can access sensitive information. These are the main reasons why we use this tool.

I think there's only one area that could be improved. Currently, when we apply the Data Masking rate, we don't have a way to view the masked data. It would be helpful if there was a feature to allow us to see the actual information.

Once the data is masked, it cannot be reversed. Having the ability to revert it back to the actual value would be beneficial, especially if we need to see the original information. Although our enrollment has decreased, it would still be helpful to have that feature.

I have used Data Masking as part of my work.

Stability is good. It's definitely reliable.

Scalability is good. It's definitely scalable to handle higher volumes across different platforms as well. It performs well in terms of scalability. 

Additionally, when it comes to implementing more source systems, there haven't been any issues.

Our experience with customer service from Informatica has been excellent. They are always available and responsive.

Positive

The initial setup is generally straightforward. However, there can be some challenges during the on-prem installation process, even though we have the steps and prerequisites. Dealing with installation issues is quite common, but overall, it's not excessively complex to set up.

The need for maintenance depends on the team. Sometimes, the solution you configure in the tool determines the level of maintenance required. However, overall, maintenance hasn't been a significant issue.

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

We used the solution for data storage, and data cleaning to improve data quality. The solution also served as a data lake for reporting purposes.

The solution has made it easier for us to retrieve and maintain the data as well as saves us time.

The ability to clean out data and improve the data quality is the best feature.

The solution is user-friendly and easy to navigate.

The cost of Informatica MDM is expensive and has room for improvement. Although the solution is good, it is not worth the high cost.

I have been using the solution for five months.

I give the stability a ten out of ten.

I give the scalability a ten out of ten.

We had ten people using the solution in our organization.

We previously used EXAScaler and switched because we were moving to the cloud.

I give the initial setup a nine out of ten. The deployment took us one month. We prepared the environment and the deployment was completed by the Informatica engineer.

The implementation was completed by an Informatica engineer.

The solution is very expensive. I give the cost a three out of ten.

I give the solution an eight out of ten.

The solution is good and I recommend it as long as the pricing fits the organization's budget.

Informatica Enterprise Data Catalog is being used for recording enterprise assets, such as customers' products and vehicles. 

We a consulting service that provides information on how to enter the catalog or forms to collect the data catalog and enter them into Informatica Enterprise Data Catalog.

The most valuable feature of Informatica Enterprise Data Catalog is it provides clients with a full view of the enterprise data assets. For example, how many data assets they have and who owns them.

Informatica Enterprise Data Catalog could improve by having a much better user interface. It is not user-friendly.

In a new release of Informatica Enterprise Data Catalog, it would be beneficial to have some new features including data sharing.

I have been using Informatica Enterprise Data Catalog for approximately three months.

The solution is stable. There are some issues that can arise with Informatica Enterprise Data Catalog, but the vendor can resolve them.

We have 10 people that use the solution.

Informatica Enterprise Data Catalog sends support to our clients if they are having problems.

The initial setup of the Informatica Enterprise Data Catalog can be difficult. It can take approximately one week to install all the components, such as metadata.

There are vendors to do the installation and it can cost a lot of money over the week that it takes.

I recommend this solution to others. There is a large market in China for Informatica Enterprise Data Catalog.

I rate Informatica Enterprise Data Catalog a seven out of ten.

We use Informatica Cloud Data Integration because we have multiple sources for data integration, and we transform that data and load it into the database or QuickBooks.

There are fewer than 10 people using this solution in my organization.

I'm an integrator. I'm working with the latest version. 

It's deployed on cloud.

Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier.

We would like to have accessibility to the repository. We had that feature in Informatica PowerCenter, and we were able to have access to the repository query, which helped us build some tools, audit tools, and review tools. In Informatica Cloud, accessing the repository query is a challenge.

I have used this solution for about six years.

It's very stable.

It's scalable. 

We reach out to technical support frequently. We've had good experiences with them.

We previously used PowerCenter, DataStage, and Oracle Data Integrator.

I prefer Informatica Cloud Data Integration because of the ease of connecting to various connectors and various enterprise applications. The UI is also a valuable feature.

Initial setup isn't straightforward or complex. It's about medium difficulty. 

Deployment took about one week. It's not difficult to maintain.

Deployment was done in-house.

From the usage perspective, there is minimum ROI.

The pricing is high compared to other tools on the market.

We chose Informatica Cloud because we have Salesforce. If you're using Data Integration, App Integration, and many other features like operational insights, then the price is worth it. If you're only using the solution for data integration, then the price definitely isn't worth it.

We export APIs, and anyone can seek those APIs to have the data for target use cases. We hit the APIs that are exposed by external systems, and we get the data from them and process it.

We're using the latest version. It's deployed on cloud.

There are about five people who are using this solution in my organization.

We chose Cloud API Integration to connect to Salesforce.

The OAuth feature is the most valuable for authentication.

Recently, we're trying to connect to the Amazon API. There's no direct way to connect to Amazon APIs from Informatica Cloud. From Postman, there's a signature site called AWS Signature, which would actually generate the signatures for us with AWS APIs. In Informatica Cloud, we have to build the logic, and then we can generate the signature and hit the AWS APIs. Instead of generating that signature, it would be better if we could have the same connector in Informatica Cloud.

Sometimes when I open the processes or any service connectors, the labels are not properly displayed. The backend names are displayed rather than the front end label. I usually log out and log back in, and sometimes it disappears, and sometimes it doesn't.

I have used this solution for six years.

It's pretty stable. We don't have any concerns.

It's scalable.

I would rate technical support as six out of ten.

Setup is straightforward. It takes a week to do the installation and configuration.

It's not difficult to maintain.

I would rate this solution as eight out of ten. 

I would recommend this tool to other users.