Informatica Intelligent Data Management Cloud (IDMC) Reviews

It can be used for different kinds of use cases. You can use it for data deduplication purposes for any industry. For example, in the pharma, healthcare, or life science sector, often a lot of medical data gets duplicated across different business functions of the enterprise. As a result, the sales and marketing channels may face a lot of challenges in marketing their medicines to the right physicians. In such a scenario, Informatica MDM could be really helpful in standardizing the data and creating a golden copy of it, which can then be published to the sales and marketing channel so that the sales representatives have accurate data to market their medicine or product. This is one of the use cases.

Its deployment depends on the project and client requirements. I don't have Informatica MDM deployed for my organization. We build solutions for our clients by using Informatica MDM. So, it entirely depends on what a client wants. For some of the projects, it is deployed on-prem, and for some of the projects, it is deployed on the cloud. In the most recent scenarios, it is mainly on the cloud. Informatica, just like other MDM solutions, is also moving toward the SaaS platform. So, I'm sure that going forward, for any kind of project opportunity, we'll be using the SaaS model when it comes to the deployment of Informatica MDM.

The Provisioning tool is something that is really handy for everyone. It is my pick as the best feature.

It is a very mature tool. It has been in the market for more than a decade.

If I compare it with other MDM solutions in the market, one thing that can definitely be improved is automation to help with the configuration. Currently, when we are creating any staging of base object tables, all the columns have to be configured manually in the Informatica Hub Console. A lot of tables and different kinds of business columns have to be configured manually. There should be an automated process for this, especially in the Dev environment. When people are creating tables and columns from scratch, if there is a backend automated process for that, it would be really helpful. In Stibo, a similar feature is there wherein you can tag attributes to certain objects. It would be helpful if Informatica also provides a similar option. It would reduce the manual effort. It could be that such a feature is already there, but I am not aware of it.

Their support can also be improved. They sometimes take long when an incident is not a priority incident.

I have been using Informatica MDM for the past five or six years.

It has been in the market for more than a decade. Over the last decade, Informatica has proved to be the best MDM solution that is available in the market. Informatica is one of the leaders as per Gartner and Forrester. There are no second thoughts about the stability of the tool. It's definitely the best one in the market right now.

I would rate them a four out of five. There is definitely room for improvement when it comes to technical support. Sometimes, when an incident is not a priority incident, they take their own sweet time to meet the SLA. For a priority one incident, they jump in and resolve the issue really fast. 

For someone trying it for the first time, it would definitely be a little bit complex, but once you get used to it, over a period of time, the complexity reduces. With experience, it becomes easier.

The deployment duration depends on the complexity of the configuration and the complexity of the import configuration on Informatica MDM. There is a feature called import where you get the chance to import it from the lower environment to a higher environment. The import process is pretty straightforward, but sometimes, when very complex configurations are done in the lower environment, it can get a little bit complicated to import the delta changes. It can take a while. 

Its maintenance isn't a big headache. For on-prem deployments, the maintenance is pretty easy and straightforward. It is not a very big overhead. With the SaaS solution, there is no overhead at all.

It was done in-house. There was no third party.

There is no doubt that it is very expensive, but the brand value comes at a cost. Other MDM solutions in the market that haven't proven themselves like Informatica are also pretty expensive. We need to understand that MDM itself is very expensive to implement. So, Informatica is also pretty expensive. I would rate it a two out of five for being pretty expensive.

One piece of advice that I would like to give to anyone implementing Informatica MDM or any other MDM solution is to be in regular touch with business users during the implementation. Because it's an MDM solution, it's business-driven rather than IT-driven. So, always stay in constant touch with business users or data stewards to best understand the data. Never try to make decisions related to the data on your own. It is always good to be in regular touch with business users and let them make the decisions. Based on their decisions, you do the implementation. Do not make any decisions yourself because the businesses understand their own data best, and they are the best decision-makers when it comes to their own data. 

I would rate Informatica MDM a nine out of ten.

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.

Axon is a platform that lets everyone see all the data assets, business glossaries, lineage, catalog, classification, etc., but the real activities are being done on EDC.

We have only been using Axon for a short time in my organization, and we are decommissioning it, but I used the solution at my previous organization for data governance projects. Data owners, software developers, and architects all access the solution. In total, we have around 150 to 200 users on it. 

Axon has a marketplace that allows you to showcase all the assets the data owner has, so they can request access. That's one feature we use extensively.  Axon also offers great visibility and intuitive searchability, allowing you to easily search data assets. You can check the lineage and see the work EDC does. EDC handles all the classification, cataloging, and lineage. It's integrated with Axon, and anyone can see that.

Though EDC has maximum coverage, a few things were not available to scan, but I think EDC is evolving to address this issue.

I have been working on Informatica EDC and Axon for nine months.

Axon is stable.

Scaling isn't a problem. It depends on how the implementation is done. Kafka is scalable If the implementation has an image, and it would definitely be scalable on the cloud. We run Axon on our private cloud instead of a Kubernetes cluster. If we wanted to implement it on Kubernetes, we could scale it easily. 

I rate Informatica support eight out of 10. 

We tried an open-source solution, but we stopped it midway through the project and adopted EDC and Axon. We also started using Atlas and Ranger.

Setting up Axon wasn't too complicated. One to three people were involved. It took about three months to implement the solution and onboard various data assets. It was a continuous process, which means we were onboarding new assets as soon as we got them. After deployment, we only need one person for maintenance. They handle this in addition to some other responsibilities.

I can't give an ROI measured in dollars, but we see qualitative benefits. You gain the confidence of our customers because they know their data is secure and only accessible to those with authorization. Data quality is improving. We are gaining our customers' confidence, and they rely on us for data classification.  

EDC comes with an Enterprise Licensing Agreement, whereas Axon is a yearly subscription. That is an expensive affair. I don't know the exact cost because the asset management team handles that. We only tell them how many licenses to get.  The administrator who manages the platform distributes the licenses, and we provide them to data owners who are making policy changes.

Axon is sold separately, and it's subscription-based. Usually, EDC is included in a big data package as an enterprise license. It would be nice if EDC and Axon could be bundled in one enterprise license.

Every tool is evolving. New technology platforms and applications are coming out all the time, like Databricks, Scala, IBM Db2, z/OS, etc. 

I rate Informatica Axon eight out of 10. It's a leading solution in the data governance segment. If you're looking for a quick and easy implementation, I recommend Informatica EDC and Axon.

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. 

We use the product to store data. We have established a structured system where we store all relevant information, including donor details, images, and series, ensuring easy accessibility for users.

The product's most valuable feature is the ability to select the data flow and lineage.

Informatica Axon's response times and certain aspects of the admin panel could be enhanced for better usability.

We have been using Informatica Axon for more than one year.

I rate the platform's stability as seven out of ten.

We have around 400 Informatica Axon users in our organization. I rate the scalability a nine out of ten.

The technical support services at the moment are impeccable. The support team has answers for everything. They have maintained this level of quality as we progress. There aren't many issues currently, although we're awaiting the migration to the cloud.

Positive

The implementation process could be simplified.

The platform has a premium cost. I rate the pricing as seven out of ten.

The product needs to be adequately supported in the current setup. I advise others to conduct a proof of concept (POC) and assess how it progresses. The learning curve can be steep, but with sufficient time investment, they can also impart knowledge to the users, which is crucial for effective change management.

I recommend it to others and rate it an eight out of ten.

So my use case was on migration.  I've been using these products for migration activities. And providing any QA solution for the integration to other platforms like Databricks.

There are newer technologies in the market that offer better solutions compared to traditional ETL operations. For example, if we use Spark on Databricks, it's more optimized and runs much faster due to its backend capabilities. Whereas Informatica Inc.'s Cloud Services provide cloud-based solutions. The ETL works on the Informatica engine, which is comparatively slow. But the compatibility of data and other integration and data warehouse works well for IICS.

The interface is really good. Another valuable feature is that it is user-friendly.

There are a few improvements which can be done. So those are on data governance and making an image of each object that is being created on top of Informatica, I mean, on top of applications. So those need areas to be improved.

The logging methods are really traditional. So logging, in order to track any operations happening on this interface, will catch a log file. That needs to be more precise.

In future releases as well, I would like to see additional features. So there is no platform where code conversion can happen easily. For example, if you want to move Informatica jobs in various areas, it's quite easy and straightforward. But still, you require some manual intervention for code changes that need to be done throughout the platform. So these things need to be improved. 

And other things are the compatibility of other services. For example, if you have a running Spark code and you want to run the Spark code into Informatica IICS, which is not compatible, so you need to rewrite the whole syntax to make it compatible. So those are the areas that really need improvement.

I have been using Informatica for three years. We currently use the version Informatica Cloud IICS.

Stability is good. I would rate it a seven out of ten. 

Scalability is good since from on-prem to cloud, there's a huge performance boost. So on a scale from one to ten, I would rate it eight.

The setup is complex. Because it's not about the data; it's about the complexity of the pipeline, the complexity of models which have been designed for data engineering. And it's not something straightforward, and the migration cost goes higher on this aspect for this reason.

We have multiple platforms with it. Some of them are running on-prem, and some of them are running on the cloud.

There is definitely an ROI because many companies are preferring to put data in the cloud, and they want to reduce the migration cost. So without any major efforts or challenges in the migration activities, if that's the case, then moving from Informatica on-prem to IICS is a better choice.

Comparatively, other services are providing a lower price, but since moving from Informatica on-prem to IICS, the pricing factor is much better. So when we compare two platforms of the same vendor, it's a good price.

On the evaluation, I have personally evaluated the migration work that I have done. So it is really easy for Informatica users who have been using the same on-prem product. For them, there won't be any challenges in learning any technical aspects of the cloud. So it is almost straightforward. And there are good services provided by Informatica, like integrated things and driver compatibility. So, everything looks much better when it is in the cloud.

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

Informatica Cloud Data Integration is being used to transform data. Primarily, it is for creating data pipelines.

Informatica Cloud Data Integration is being used to transform data. Primarily, it is for creating data pipelines.

Integration is a valuable feature. Currently, the integration makes our security more robust, especially when compared to IICS, where we would need to make arrangements through native or other ways to handle that, and here using sum up makes our lives easier.

With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues. So things are not very mature. They need to improve in the aforementioned areas. We are hoping that it will be sorted out in some time, and we will get to experience a hassle-free life.

My company does business with Informatica. We are using their product. I have been using Informatica Cloud Data Integration for four to five years. I am an end user of the solution. Also, I am using the solution's latest version.

I think they are working. Their engineers are still working on some transformations and some features. It is not as stable as they are thinking, but in the last two years, we have seen good progress. So, we are hoping for a similar thing in the future as well. So it is scalable. But, stability-wise, I think that a more stable version is going to come.

I think it is a scalable product. Around a hundred users are using the solution in my company.

The support is very good. On a scale of one to ten, I rate the technical support between eight and ten.

Positive

So we've got many solutions. Not before going to Informatica, but we were evaluating and working with other sets of tools as well. So, on AWS, it is EMR and Glue. We quite frequently use Glue for data pipelines. We also use SAP S/4HANA for delegation. I like IPC and IICS because I have experience in them for the last fifteen years, and I'm working using the same tools. So, I mean, it is my biased opinion. Otherwise, since I have not caught exposure to the other tools in the market that the people in my company are using in different teams, I don't have much exposure to them. Had I gone through those experiences, I would probably have recommended some other tools as well. Currently, I'm in this industry using this tool only, so I recommend it only for that reason. 

The initial setup was very easy. Currently, we are in a deployment process. We've not yet orchestrated that part, but we are in the process of creating the deployment pipelines.

I have deployed the solution on the cloud. Also, there is no maintenance required for the solution.

Cost-wise, I think it is on the higher side, and that is why we are looking for some better options. Licensing costs are huge compared to other players in the market and for my company.

It's a good tool to start with in the beginning.

The product is maturing and has not matured yet. If I look at the market, there are other tools that are providing this stable solution. I rate the overall solution between five to six out of ten.

I use the solution for enterprise-wide data discovery and traceability, providing business context to data and collaboration between different stakeholders of data.

My organization, being a service provider, uses the product to develop domain PoCs, customer PoCs, develop data management and governance use cases, etc. The major issue with enterprises are the ability to quickly develop an MVP and showcase it to business and other data users for greater buy-in. This is important as these are new technologies - and hence, users might not easily adopt.

Our organization is a service provider as compared to an end-user. We have helped multiple organizations onboard onto data management using these technologies. 

It has improved different areas for different enterprises, including the improvement in overall business outcome and business experience, imbibing a data-driven culture, having easy availability of the right and relevant data, allowing for better compliance to regulations, and providing greater data quality and privacy management.

It has also improved overall time to service data requests such as DSAR requests.

The metadata management of Informatica is great. When an organization uses developer for data integration, IDQ for Data Quality, EDC for Data Catalog, Axon for Business Glossary, DPM for data privacy management etc., Informatica tools integrate metadata from all these tools seamlessly. The advantage is getting a complete view of your enterprise data through business and data lineage - as it not only provides you with pure data lineage but also associates related data quality measures, data protection levels, etc.

Additional metadata harvesters from different major tools can be an added advantage. Informatica provides some smart connectors for harvesting metadata from some of the industry tools. That said, this can be improved a lot more.

Overall, the toolsets are really good.

Installation and configuration can be another area where Informatica can improvise a bit. It is not easy to set up and configure the tool. A proper step by step guide to ensure this process goes smooth can be a huge advantage for end customers.

I've used the solution for more than six years.

The stability is excellent.

The scalability is excellent.

Technical support is good.

Positive

Most of our customers were using excel and email-based communication for data access. These new-age solutions improve efficiency ten times or more.

The initial setup was not very straightforward. This is an area of improvement.

We, being a service provider, have implemented and configured the setup on our own.

ROI depends on the buy-in from businesses and overall adoption rates. There is a huge amount of change management and change strategy that needs to be in place to ensure users are adopting the new tools/technology.

Informatica has good pricing options and a good professional services team who can help with setup/configuration.

There are other competing good products such as Collibra, Azure Purview, Erwin, IBM CP4D, and more. All have their strengths and weaknesses.

If you are an Informatica shop, there is no need to think twice to opt for an Informatica-based Data Management product suit.