Informatica Intelligent Data Management Cloud (IDMC) Reviews

The solution helps with cataloging and obtaining the data lineage. Informatica Enterprise Data Catalog also helps in identifying vital datasets, including the critical data elements and cataloging them. In our company, we have to manage the life cycle of the critical data elements and maintain the business glossary.

The definitions of the critical data elements, their linkage, lineage, as well as the relationships are managed using the solution. Informatica has been in the industry for decades, so they are one of the top SMB partners. 

At our company, along with the solution, we also use Informatica Intelligent Cloud Services REST API for app and system integrations in the packaging industry. Of our total portfolio, we integrated applications for about 20%, but we did not have any cloud presence; only a setup application was in the cloud. But for all the on-prem projects, the key components of the customer's product were integrated and governed by using Informatica. 

Data lineage is a valuable feature when, at our company, we design the physical elements and the logical components and need to identify the relation between them. 

The duplicate identification feature for two tickets, synonymous fields, or attributes is another vital aspect of Informatica Enterprise Data Catalog. The categorization of whether data is critical or not in the business glossary is another vital feature of the tool.  

The product is difficult for an untrained professional to operate. Specialized skills need to be acquired by learning the tool and executing it for data operations. Informatica Enterprise Data Catalog needs to be more user friendly, the UI is extremely complex.

For instance, if I have to view the tool, the first deterrent is that it gets highly technical. Thus, a limited number of professionals can understand the tool processes. Unless you are a data professional, it's very difficult to use Informatica Enterprise Data Catalog. The tool operates with Power BI sometimes.  

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

At our company, we haven't faced any downtime or business issues with the solution. The solution allows a limited number of users, so it's easier for the vendor to manage stability. 

I believe the solution is scalable and integrates satisfactorily. Our company was successful with scalability because, for the majority of our applications, where the key data was being hosted, we could integrate the apps quite easily with the cloud.

If Informatica Enterprise Data Catalog is being used, scaling the data up or down shouldn't be a problem. The solution's cloud integrations make scalability easier, unlike the on-prem version, which requires implementing complex security protocols. 

I would rate the customer support a nine out of ten. The product's support team has been highly responsive while solving the issues faced by our organization. 

Positive

At our company, during the product deployment, we had to asses our applications and APIs that would be connected, whether they were available out of the box or not. But the capabilities of customer connections are available with similar tools.

Informatica Enterprise Data Catalog offers custom connectivity. Therefore, the deployment process has been troublesome for our organization except for the mainframe. But as we kept using the tool we realized the integrations could be smoothly completed. At our company, we implement the product if customers are convinced to integrate the tool and make it their central, single source of data management for integrators and technicians. 

The deployment of the solution took more than a year in our organization, which included upgrades, contract renewals, and demonstrations similar to IDMC, provided by the same vendor. For deploying the on-prem version of Informatica Enterprise Data Catalog, a team of five engineers was needed in our company to manage the whole deployment and support process.

A couple of business analysts are needed to gather the users' requirements. Our organization has about ten members who provide on-call support on Informatica for its customers, comprising developers, business analysts, and testers. 

In our organization, we were able to derive about 70% of the critical data lineage. 

It's a costly solution. I would rate the pricing of Informatica Enterprise Data Catalog as six out of ten. 

The automated data lineage feature utilization depends upon the integration, which is why, in our organization, we had all our key applications integrated that derived automated lineages. But there were unknown applications as well, which, due to the lack of integrations, needed to be manually plugged in.

The mainframe integration with Informatica Enterprise Data Catalog is highly complex. At our organization, due to the aforementioned complexity, we had to import all the data of the mainframe into Informatica. If you are able to integrate the tool with your core applications and systems, then the data lineage duration is pretty simple and this structure is the same for competitor tools as well. 

In our company, we might explore in the near future how Informatica Enterprise Data Catalog can assist with AI capabilities. I would overall rate the solution as eight out of ten. To anyone looking to use Informatica Enterprise Data Catalog, I would say if they are willing to understand the company data, then the professional should gather sufficient technical knowledge about the product or take assistance from an Informatica expert because it's not a straightforward tool. 

We had proof of concepts where certain test cases were given to improve the functionality of the vendor regarding the supply chain.

So, it was a proof of concept. It was not applied in production.

It was just illustrating the capabilities of the platform, and we were comparing it with other platforms.

If we use it comprehensively, we can improve the data quality metrics or KPIs. 

So use as much data as you process, and have a solid strategy in place. If you don't have a comprehensive approach, then you don't draw any benefits or value from such a complicated platform. So, you have to have the objectives very well set up and be part of your daily activities in order to benefit from such a platform.

I like the connectivity and richness of features for the technical team, the maturity of the product, and that it had a cloud version. There is Informatica Cloud, and it is part of the Informatica Cloud platform.

It also has integration with other data governance tools from Infromatic, which is also good. 

It offers integration with some of the latest data platforms, streaming platforms like Kafka, for example. And the setup of the platform is very challenging.

Regarding the cloud, it is deployed in the private cloud of the vendor, so it poses challenges regarding the security of the data and the confidentiality of the data. There was no offering of a cloud version deployable in the client's tenant where all the data would reside.

I used it for a couple of months because it was only demoed for the client.

It is a stable product. 

The customer servive and support could be faster. There is a slow turnaround. 

Neutral

We just compared the data profiling features or data quality features between the tools. There was a rich functionality available in the system, but we did not draw any conclusions regarding how it improved or may have improved.

It was set up by the vendor for the demo. To deploy the Informatica Enterprise Data Catalog, you need at least two admins and architects. 

It enables business processes by providing trusted data that can be integrated into many processes around data.

It's very expensive. It's subscription-based. There are several levels of subscription.

The price is high, but the competitors are even higher and more experienced, like Collibra.

Overall, I would rate the solution a nine out of ten. 

I would recommend it due to the consistency of vision and very good integration between different products of Informatica. It offers wide coverage, the widest coverage of technologies from the major players.

What I like best about Informatica MDM is its structured, table-based approach. Unlike Reltio, where data is only visible through the UI and cloud-based, the solution allows access to normalized tables. This means I can directly query and see data in each table. For instance, I can easily get all customer details from the customer table. However, for more complex queries, like seeing all customer interactions with the organization, some SQL knowledge is needed to join different tables and retrieve the details.

The tool could be improved in terms of ease of use, particularly for those without technical expertise. Understanding and extracting data from the table-based structure requires some SQL knowledge and technical skills. Additionally, while Informatica MDM has moved towards a cloud-based MDM with a UI similar to Reltio, I haven't used it, so I can't comment on its effectiveness.

I have been working with the product for six months. 

I haven't had any issues with the tool's stability. 

I'm not entirely sure about scalability, but I've heard that adding custom features can be complicated. We have to go through several steps. First, we need to determine if we're adding a column to an existing Informatica MDM table or creating a new one. Then, we have to contact Informatica with our customization request. They do the customization. After that, we have to check if it's working correctly.

In our organization, we use Informatica MDM in a specific way. It's primarily based on tables; users don't directly log into it. The process works like this: data flows into the MDM tables as an inbound process. Once the master data merge has been completed, the output data flows out as an outbound process.

The tool's support team is good. The product is quite technical, and so is the support team. When we have questions, we reach out to them, and they provide answers. Their response time is also good—we don't have to wait long for replies.

Positive

I rate the overall product a seven out of ten. If you don't have the budget for Reltio, then you can go for Informatica MDM. 

The use cases attached to Informatica MDM may vary for different industries. Suppose I talk about industries related to healthcare and life sciences. In the aforementioned scenario related to healthcare and life sciences, there have been situations where a lot of sales representatives have issues while trying to set up calls with different physicians. Informatica or any MDM solution usually helps people in the healthcare industry optimize their business processes, especially when setting up calls with different physicians. Typically, Informatica MDM helps to reduce the number of duplicate details related to a physician or the data related to a particular organization data so that the sales representatives don't end up sending duplicate call invites to the same physician, especially those physicians who have probably different versions of their own name.

I think the integration feature is probably one of the key features in Informatica MDM. When compared to other Indian products, Informatica MDM has an edge due to its integration capabilities.

I don't see any area of improvement required when it comes to Informatica MDM since it is one of the leading products in the market. Some unification in Informatica MDM's UI side would probably make it better. I find Reltio more intuitive when compared to Informatica MDM's UI. Informatica MDM's UI is not intuitive enough. Informatica MDM's UI can be made a bit more intuitive.

I think all the latest up-to-date features are made available in Informatica solution. When it comes to Informatica MDM, all the features are mostly included, because of which there is nothing that needs to be added.

The long response time taken by the technical team of Informatica can be considered for improvement.

I have experience with Informatica MDM. I currently work for a company that has an alliance partnership with Informatica. I use Informatica to develop MDM solutions for my company's clients. I work as a solution provider since my company wants its employees to work as middlemen for Informatica products. In my company, we use Informatica to build solutions for clients. I use the latest version of Informatica MDM.

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

It is a highly scalable solution. Scalability-wise, I rate the solution a nine out of ten.

If it is for a single region deployment, the number of users who use the solution can vary somewhere between ten to fifteen, but if it is for a global deployment, then there could be hundreds of users who would use the solution.

The solution is used on a daily basis in my organization.

If there is a super high-priority issue, then the technical team of Informatica is super responsive. However, if it is a low-priority issue, they usually take a little longer than their usual response time. I rate the technical support an eight out of ten.

Positive

When it comes to Informatica MDM, it is mostly a cloud or SaaS-based product, because of which the configuration or setup phases may not pose a challenge. Most of the MDM solutions are now SaaS-based products that the product vendor maintains, and so such products are mostly accessed through web URLs over the cloud. Right now, any configuration or setup is not challenging, which used to be the case several years ago when these solutions were deployed on an on-premises model, because of which installation and other such procedures were required. Currently, most products are SaaS-based solutions, so there are no such challenges with respect to setup.

I rate the initial setup phase of Informatica MDM as a nine on a scale of one to ten, where one is difficult, and ten is easy.

Predominantly, Informatica MDM gets deployed on a public cloud. There is a provision to go ahead with if any of our company's clients want the product to be deployed on a private cloud, but it comes at a very high cost.

The time taken for the end-to-end deployment process depends on the complexity of the project that you are working on, but if I have to give you a standard answer, it would be approximately six months to start from scratch until production goes live.

Considering the members from the production and UAT departments, the UAT department dealt with the product for three weeks, and the overall deployment process took place over a month to a month and a half. Around eight staff members were required for the deployment process, including an Informatica developer responsible for configurations, a lead developer, two people for integration, a project manager, and one solution architect.

One of the in-house teams in my company carried out the deployment process.

I would say that the return on investment from the use of the solution is fairly good.

I rate the product's ROI a nine on a scale of one to ten, where one is zero percent return on investment, and ten is one hundred percent return on investment.

I rate the product's pricing a nine on a scale of one to ten, where one is low price, and ten is high price. The product does come at a certain cost since it is one of the best products in the market. The payments for the solution are made on a subscription-based model, meaning it is a pay-as-you-go model. In general, the costs attached to the solution depend on its usage.

The costs, in addition to the standard licensing fees for the solution, depend on users' requirements.

The people required for the maintenance of Informatica MDM depend upon the requirements of the clients who use the product.

I would say that a team of five people that includes a solution architect who operates in a partial capacity would be good enough to take care of Informatica MDM's maintenance phase.

I recommend the solution to those who plan to use it.

I rate the overall product a nine out of ten.

In my company, we use Informatica Cloud Data Integration because I work in the insurance sector, where we use the tool for data migration from one environment to another. We also use Informatica Cloud Data Integration in scenarios where the clients switch from their legacy system to Informatica Cloud using Azure Synapse, because of which we have to migrate all the data to Azure Synapse.

The most valuable features of the solution are pushdown, optimization, and partitioning, which can be used for frequent data loading, especially when we have a huge data volume in our company.

While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag. I feel that Informatica is still in the process of improving its cloud. Sometimes, there are connectivity shoes in the product causing it to have multiple issues, because of which the solution hangs or lags. The product may have issues because they are new to the market and are trying to improve their services.

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

Stability-wise, I rate the solution a six out of ten.

The solution can be easily scaled up since we just need to take the aid of some PIM processor and increase the data volume as per what we want.

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

The solution's technical support is good. I rate the technical support a seven out of ten.

Neutral

I have an experience of more than ten years with Informatica PowerCenter.

Informatica Cloud Data Integration's on-premises version is very good, considering the faster performance and efficiency it provides. Informatica Cloud Data Integration's cloud version is also getting enhanced since Informatica has been regularly doing some patching to increase the product's performance. Considering the current scenario, Informatica PowerCenter is a good product, especially its on-premises version.

The deployment doesn't take much time, and only a few minutes are needed to deploy the solution.

I rate the product's price a seven on a scale of one to ten, where one is the cheapest and ten is the most expensive. The product is a bit expensive.

In the cloud, Informatica has migrated to a different environment in a single platform named IDMC, on which one can have cloud data migration, cloud application integration, data quality, and data governance, making everything combined with a single platform. Earlier in our company, we had to rely on different software or platforms for each functionality, but now we can use a single URL and work on a single platform.

I would like to speak about Informatica Cloud Data Integration's performance, which is too slow but works overall as a tool. To those planning to use Informatica Cloud, I would say that it is the second-best product in the marketplace, and soon it will become the leading product.

On a daily basis, the product has been increasing their overall availability and performance .On a weekly basis, the product gives out some new updates while fixing its old defects. It will be a good product in the coming years. Improvements in the current product will continue for some time.

I rate the overall product a seven out of ten.

We were trying to publish a compendium of all our various assets using an Oracle-based data warehouse. We also had vendor-based solutions like Epic for electronic medical records on an SQL Server base. We had many research systems on various platforms because it's a cancer research institution. 

We wanted to pull together a comprehensive data catalog to show people all the different assets we had and where they could go to find things. If there were vendor-based definitions of things, we'd pull in the definitions and various attributes. It's a heterogeneous environment data-wise. We get a lot of value from a comprehensive enterprise catalog.

It's available on our intranet through a data governance portal. You could go there for a catalog, quality reports, etc. In a year, there may have been 500 unique visitors. It was my job to publicize it, but I didn't necessarily do a good job. I worked with research groups and clinicians to get their stuff on it, and they would tell other people about it. The nice thing about Informatica is that it was easy to link from our internal web portal to their catalog. I had excellent developers working for me. It didn't require much development, and it took less and less as time went on. 

I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar. 

The purpose of the Enterprise Data Catalog was to build an internally searchable catalog of stuff. You may not have permission to see this data but at least you could find out where it was and contact the person who owns it. 

Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms. 

It was a challenge to promote data visibility while also jumping through hoops to take some of the proprietary things and make them part of the calling, especially when the vendor doesn't necessarily support interoperability. You need to export things from a vendor program and import them again. 

We used Informatica for a lot of the data governance stuff I worked with when I joined the company, including things like cataloging and profiling data. The organization has really changed a lot in the last year and went with Informatica EDC. They're moving from the on-prem version to the cloud.

Informatica is a strong company, and EDC is a solid platform. 

The scalability is excellent. Informatica really knows what it's doing. They're smart people and great engineers. 

Informatica's customer service and support were decent. They listen to their customers. If something is missing or wasn't working, they will put it on their roadmap. They were listening to customers for roadmap stuff. 

We wound up building a staging database to pull stuff out of the EDC, stage it, and then access that. It was open, so we would often have an intermediary layer at Oracle. If we wanted to show, for example, data quality over time, we would have a weekly quality process that would run. We staged that in an Oracle database, and the portal could access that.

We had to build Informatica pipelines and do some Azure work to feed data to them. With data warehousing, you typically have static data that is timestamped daily or weekly and sometimes monthly or annually.  We were trying to get real-time data, like blood pressure monitoring and stuff like that. That was a lot of work. I didn't do it. The integration team. 

When I joined the company, it was an Oracle-based solution. Then Epic took over, which was SQL Server-based. After that, they went to Azure. Now, all the analytics are supposed to be on this platform, and it's not particularly open. 

Setting up Informatica EDC is usually pretty straightforward. The challenge is working with vendors like Oracle and Microsoft, which have APIs for integrating things. You can query what they have. They want it to play well with other vendors because they know customers don't only have one brand of product. In some cases, you get vendors in there that are, "No, we're not going to do that because we're so special." It was a challenge. The platform of choice for data initiatives at the cancer research institution is Palantir. 

We didn't look for an alternative, but Azure has its own catalog.

I rate Informatica Enterprise Data Catalog nine out of 10. It's a great solution, and I was happy with it. It did everything I wanted, and Informatica dramatically increased the integration points over time. When we started, it was like Oracle and SQL Server, but now they're adding NoSQL databases and others.

Informatica has user groups and listens to user input. One of the people that worked for me hosts an annual Informatica user group in Houston. You can try to build your own Oracle-based or SQL-based solution. They listened to the market, and they're working on improving the interoperability. Maybe it works better with Palantir since I left, but they work across all platforms. They're making it Cloud-based. I didn't know anything about them before I got here. I was dropped into a department where Informatica had been for at least five or six years, and it was a good choice.

We use the tool to implement customer, product, and entity masters. We also use TDM to generate synthetic data, but not in real-time scenarios.

It's a multi-domain master data management system. The solution is easier to use compared to the other solutions. The security is good. The governance model is good. All the elements that I expect are available in the product.

The user interface can be a bit more functionality-aligned.

I have been using the solution for the last 15 years.

I rate the stability a nine out of ten.

The product is scalable.

The support team does not provide much support.

Negative

The initial setup was okay. I rate the ease of setup a five out of ten. The tool can be deployed in a minimum of eight to ten months. The implementation requires at least a team of five members. Maintenance depends on the customer's requirements. If the customer's requirements keep changing, we need a team to maintain the tool. Otherwise, one or two Informatica developers are sufficient to maintain the product.

The price is comparable.

All the tools have similar capabilities. There is nothing superior in Informatica. I'm a software integrator. I work for an IT company. I'm not the consumer. I will recommend the product to others, but it depends on the customers’ needs.

If an organization needs a good customer master, product master, or partner master, Informatica MDM will be a good choice. The solution has been in the industry for quite a long time. It has all the elements I look for in a master data management system except for customer support. All other things are fine.

Overall, I rate the solution a seven and a half out of ten.

It is used for our SharePoint data, and it is used for our financial data, so we prepare some kind of data lakes about data. And for a lot of financial things. For example, when somebody has to put the user, like, what we have in your organization. You have a user, and some joint venture partners are there. So, we use it for multiple financial master data. Basically, financial master data, we use it.

We are basically partners, IT partners because a lot of data is being used in multiple applications for Informatica. So, basically, we have partners. It's like Shell. So, it's an end user, but as well as a partner.

It's helpful in integration, and it can be moved around in SharePoint.  So, from the SharePoint View, data integration and reporting, it help a lot in that way.

The speed with which the data should be moved could be improved because of the firewall. It's becoming quite slow. And the integration with Teams or with Microsoft is not so smooth. So these are the areas of improvement. 

So, probably, they might even look for some upgrades or some changes over there. But these are the two key areas that we are facing issues with. One is the data moves a bit slow, and the integration within Microsoft products.

Maintenance is another issue that takes a lot of time and money. It can be a challenge in the long term.

I have been using this solution for six to seven years. 

It is stable, I would rate the stability a nine out of ten. 

I would rate the scalability a seven out of ten. Because of the maintenance issue, we want to scale it up, but we're not able to do so because of the maintenance issue and delayed response.

It breaks down quite often, and it takes time and money to get the issue fixed. These are challenges that need to be addressed from a global perspective, not just from my process.

The support from IBM might not be good, or the IBM people might have to contact Informatica for the solution. That could be a reason. But the resolution takes longer than expected.

There is room for improvement in the support. The response time could be faster. 

Neutral

It is easy to install because our laptops come pre-configured. There were no issues. However, it is not easy to maintain. 

We have a team that IBM handles for maintenance work. If there are issues, we raise a ticket, and they get sorted out, but it takes too long. It is not quick enough. The resolution takes more time than expected. 

We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics. This aligns with our company's initiative to implement a data lake strategy and drive digital transformation.

Overall, I would rate the solution a seven out of ten.