Informatica Intelligent Data Management Cloud (IDMC) Reviews

I'm a senior architect and we are partners with Informatica. 

The solution offers good data governance.

I've found that whatever functionalities are available on-prem, can become a bit of a challenge sometimes in the cloud. There are no simple rules for customization so they need to be applied which is a challenge on the cloud side.

I've been using this solution for four years. 

Informatica stability is great. Even now, Purview has evolved a lot, but we haven't used it to the same extent. 

The solution is scalable. 

We are partnered with Informatica, so we don't have an issue with technical support. 

Our preference is Purview when we're asked for a cloud solution because it's a cloud native and the same applies when taking cost into account. Deployment is easier with Purview. If an organization is going for a hybrid solution and there's a lot of governance and complex rules involved, my first choice is Informatica. If that's not the case then I go for Purview.

Without experience, it may be somewhat difficult but I don't find it particularly complex because there's a lot of training and documentation available. We've already had a lot of experience so it's a piece of cake for us. 

Licensing costs are not fixed and I know that Informatica offers discounted prices to certain customers. Microsoft is cheaper.

The solution is suitable for enterprise or mid-size organizations. But if there are customer-related or different domain issues and it has some kind of regulatory impact and a lot of external agencies come into the picture, then it's always good to go with the Informatica Axon.

I rate this solution eight out of 10. 

We don't use profiling as much, however, we do use it, in certain cases, for profiling. We use the Analyst tool to do out-of-box, high-level profiling of data to see high-level quality of completeness, and uniqueness, et cetera. Mainly, we use the Developer tool to connect to the sources and to write data quality rules.

It has improved our organization. 

We started from just pretty much having flat files, and then doing some basic transformations, then writing back to Excel or QFD files. 

We gradually moved to more analytical tasks. You don't just do statistical data quality you also do analytical. You do lots of joins with other sources and do the consistency checks, and to do more complex logic, and build metrics. 

We use Tableau on the back of it to present the data and data quality, and then monitor it. We use it more like a batch process to build pipelines, and then, using Tableau, monitor the results of it and those metrics. Now, we work more with live updates and do that more than the batch.

It's probably one of the leading lights in ETL. They have really good built-in functionalities, or algorithms, that you can use to transform or process data and validate and standardize.

The solution is stable.

It's not too had to set up the cloud version. 

Support is helpful and responsive. 

We are in this transition mode, where we haven't yet got IDMC, the cloud version, so we don't actually have hands-on experience and have not actually seen the features. All we rely on, at the moment, is just the available documentation. What I don't like on the IDQ side is just the fact that in the on-premises version, you have all these applications, with separate configurations. In the cloud solution, it is fixed so that you have everything on one platform.

The performance isn't as good on-premises. For example, when you install clients, it's slow compared to the cloud. Still, we need to see. We haven't experienced it ourselves. 

The upgrades are a downside. On-premises you manage all the changes in the software. You have to do that yourself, and if there's some problem with compatibility, it makes things that much harder. With the cloud, everything is managed by Informatica on the servers.

Managing the licenses with the on-premises version was difficult. However, with the cloud, it will be much simpler. 

I've been using the solution for the last six or seven years. 

Once you set everything up, it is pretty stable. It's reliable. There are no bugs or glitches and it doesn't crash or freeze. It is way more stable than Hadoop and other applications. 

In terms of scaling, we used the clusters, and the processing was on Hadoop side. If we needed any extra space or any service, it was just managed there, so it was outside of Informatica.

Originally, we had 20 people using the solution, and then it was reduced to less than ten.

We do use it as much as we can for its purposes. In the past, we used that for the whole ETL process with data loads, and then we moved to Hadoop storage. At the moment, we are only going to be using Cloud Data Quality and others for cleansing, standardization, and deduplication, and then using some other Azure capabilities.

I've dealt with support in the past. There were issues, and we had to deal directly with Informatica for some hotfixes. They were good. They just got straight to the point and were helpful overall.

Positive

It is way more complex to install on-premises than in the cloud.

With the cloud, the installation will be way easier since you only install these secure agents. They have many different connectors, so it is definitely less hustle to install all these machines, and all these applications. On-premises, it was more user-based. Now, it's service-based, and you just pay for what you use and the licenses as well. 

We had myself, an architect, and a developer as well as help from Informatica while handling the setup.

We have about two or three people that can deploy and maintain the solution. They also cover other applications, not just Informatica.

We had Informatica support, and we had an internal group of people with Informatica knowledge who handled the solution. For some parts, we were involved as well, and we handled them ourselves. 

We're still in the early stages of moving toward the cloud. We have not seen an ROI yet.

When you are using the on-premises version, managing the licenses is quite difficult. However, on the cloud, you just pay for what you use, and it's a lot easier. With the cloud, if you want MDM, you pay for it, and if you want PowerCenter, you pay for it; however, if you don't want it or don't use it, you don't pay. We'll just pay for Data Quality, as it has all of the features we need inside it. 

I'm not involved in the conversations around licensing and agreements. That said, my understanding is that Informatica is pretty expensive. I'd likely rate it two to two and a half out of five in terms of affordability.

We definitely considered others and had StreamSets used for some other purposes. The company that I moved out of was going to be switching off Informatica at some point due to licensing, et cetera, and they just chose to go to StreamSets with Snowflake for storage. 

I haven't researched enough about other products in relation to Informatica.

We are moving to the cloud version. On-premises, we were on version 10.4.2, and that moved to 10.5. Soon, we will be on the cloud.

We're using IDMC, which is not just Data Quality. It has governance, Axon, and other applications in it.

We're just a customer.

I'd advise people to research use cases before beginning. Companies need to understand what they are trying to achieve, figure out their requirements, and then appraise the solution. 

While Informatica is good in terms of Data Quality and is probably the leading option, you need to be clear about budget, et cetera.

I would rate the solution seven out of ten.

It comes with lot of features and is a one-stop-shop solution for integration, data modeling, and data governance. Everything can be built under one particular umbrella. If any issues come up, then there won't be any blame game saying that it could be an integration issue or an MDM hub issue because it's wholly owned by Informatica. That's the biggest advantage of Informatica MDM over that of any other tools that are available on the market.

It has given us a lot of flexibility in terms of solutions.

This is a costly solution. We have several customers who evaluate it but then look for other solutions because of the cost.

At present, Informatica MDM comes as an on-premises or cloud-based solution. I would like to see them offer a SaaS-based MDM model. I think they are working on it.

I've worked with Informatica MDM for close to a year.

We have not had any performance issues.

It is a scalable solution.

The technical support is good depending on the SLA. Sometimes, they do have a busy schedule. When I contacted them for issues, someone joined the call if he/she was ready. Otherwise, we have had to wait for a day or two.

Informatica MDM is a costly solution because it comes as a bundle. They are also globally positioning themselves and are definitely working on very upgraded technologies. If someone wanted to do it on the cloud, they have a lot of flexibility because they upgrade themselves according to the current needs. It definitely comes with a lot of features and that's the reason why it's costly.

The licensing cost should be approximately one million dollars. It's about four to five times that of other vendors.

Take a look at your budget first and then proceed with this solution.

On a scale from one to ten, I give Informatica MDM a nine.

A lot of times, we use it for basic profiling. That's its most common use case. Currently, we are also in the process of establishing a set of ongoing processes around Data Quality that would feed into and augment our current metadata. So, from that standpoint, our usage is primarily around some of the basic dimensions of data quality, such as completeness, conformity, consistency, timeliness, accuracy, etc. We measure each of those or at least create quality rules that measure each of those aspects. We're in the process of doing this for all of the data that's currently feeding into our analytics engine. These are some use cases that we're currently doing on a daily basis.

There are a couple of valuable features. One is that it is very quick on the profiling. So, you get a very fast snapshot of the type of data that you're looking at from the profiling perspective. It can highlight anomalies in the data.

The other valuable feature of the Data Quality tool is the flexibility of using their Analyst tool to create a mapping specification, which allows you to join multiple sources of information. You can then create rules within that data set. You can apply aggregations and all other types of functions, and then you can feed that into the profiling tool. From the profiling tool, you can then create your scorecards. It can be two-step where you're using that mapping engine to integrate multiple sources. If you don't have a need for that, you can do a lot more sophisticated mappings inside their Developer tool, and then maybe do an analyst type of mapping engine. So, you can do straightforward data quality within the Analyst tool, or you can do more sophisticated data quality within the Developer tool, at least as far as the rules are concerned.

Their UI needs improvement. Their scorecards and reporting also need improvement. Their data quality reporting, especially their dashboards and scorecards, is lackluster at best. Its reporting capabilities are limited. If you want to do anything beyond its limited reporting capabilities, then you're going to have to use an external reporting tool such as Power BI or something like that.

It has a few glitches that they haven't fixed. For example, while creating a new scorecard, when you get up to a point, you have to stop and save what you've done. You have to exit and then go back into the tool to finish up your work. From the development aspect, using their scorecard tool has a couple of glitches in it. This might be a tool that they're going to eventually phase out. So, they're just not doing a lot of work on it. I've been living with it for a few years now. I've learned that I got to save my work, and then I got to get back into it to finish up what I was doing.

I have been using this solution for at least five years.

It is pretty stable.

As far as I know, it scales pretty well. The part of the problem that we have is with the way it saves the results. When it saves the result, it creates a physical copy of some of the data results and stores it. So, when we're processing, for example, 500 million rows of data, depending on the type of rules that we have and how we're doing it, it can quickly use up a lot of space. We've had some issues with some of the space and storage. It scales, but you still have to be careful how you configure it so that you don't use up all your resources. We've added a lot of disk space, and we still occasionally have problems.

Currently, we have maybe half a dozen heavy users, but we're probably going to scale that up to 20 to 25.

It is straightforward.

I would rate it a six out of ten.

We are using it to understand the assets that we have from their technical metadata perspective, but we're also using it to align our business glossaries with the actual physical data location where the data is stored. Using their Claire or AI engine helps facilitate that. We've been doing that for a while.

The other thing we're trying to do is extend that metadata capability to include extended lineage and provenance attributes. We're trying to incorporate those into the existing EDC environment, and hopefully, when we get Axon, we'll try to figure out how we would expose that to the customer. We will figure out whether we're going to expose that directly or whether we're going to have to augment Axon with an additional UI layer.

From my standpoint, Informatica offers a pretty robust set of scanning tools that can scan a variety of sources of information. It offers a central repository that you can go to for interrogating and finding data. You can find the data that you're looking for based on enhanced metadata.

The other thing that we're working on is extending the existing Informatica data quality capabilities within the EDC so that we have a more robust understanding of not only what the data is and where it is located but also the quality of that data. We are doing this so that when people are looking for data, they see not only where they can find the data, but they also feel confident that the data is going to meet their needs.

The capability of the tool to scan and capture the metadata from a variety of sources is one of the capabilities that I find most useful. The central repository into which it is going to put that captured metadata is the best.

The model is somewhat flexible. There are certain aspects of the model that are not as flexible as we would like. It doesn't do certain things to a great level of depth. So, in situations where we want to drill in to do something specific, we have to essentially copy that data into our own structures in order to add that additional layer of flexibility.

Robust process management or workflow management, like Bonita, should be incorporated into the Informatica tool stack because it offers very simplistic workflow capabilities. If we had more dynamic and robust workflow capabilities, we could make use of that a lot more. Currently, we have to do a lot of pre-work outside of the Informatica tools before we can get the data loaded and start using it because they're UIs. I haven't dealt with Axon. So, I don't know exactly how that's going to change things, but with the EDC tool, I can't say the user interface is useless, but people don't use it because they find it cumbersome.

Its UI, without considering Axon, is probably their least desirable part. It has some interesting capabilities, but it is not what I would call cutting edge or super. It is not as intuitive as I would've expected. Its UI is probably prior to Axon. It is a little dated, and even Axon has been out there for a while now, but it is a little dated. That's probably why they went out and bought the company that originally made Axon.

I have been using this solution for five or six years.

It is very stable.

We're using it for our enterprise. We are not the largest enterprise in the world, but we're a pretty good size. We have 20,000 people working here and petabytes of data flowing through various systems. It is less about the people using it directly as opposed to the systems using it. It is really a matter of the system interfaces that are automating. We're trying to automate the metadata as much as possible so that when people are looking at their data, they can also see the associated metadata. Sometimes, we have to pull the metadata out of EDC and feed it into other systems so that as they're using these other systems, they can see the metadata flows with it.

I haven't dealt much with them directly, but I've had colleagues create tickets all the time. Generally, they're pretty good. 

I'm more from the end-user perspective. From a system standpoint, there is a different team that sets things up on the server and establishes various types of configurations. I do work with them, but I'm not actually doing that work. 

They have three people that are actively managing the system, and they are system administrators. There are also various people who might be testing things at any one point in time, and then there are various analysts who might be creating data to feed into the system, such as definitions of business terms. The same people may review the results once it gets into the engine. When it starts to process that data and makes the associations between the terms and the actual metadata where it is linking the two up, somebody has to go in and validate that, especially the exceptions or the ones that don't have a high enough matching score. So, there are probably three or four system admin folks, and those are more technical folks, and then you have maybe 20 people who might be putting in data, validating the data, and so on. Those are still primarily an IT function. They have subject matter expertise, but they're still reporting up through the IT group, and then, we'll eventually get to the point where we have a more robust set of business users who are reviewing and vetting that information.

I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint. 

I would rate it an eight out of ten.

We use Informatica MDM for various clients for integration, removing duplicates, and centralizing data in one place.

It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable.

The match and merge function is good.

New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market.

Artificial intelligence is something which they should add to the solution.

They need to do MDM on real-time data as well.

The price is a big factor. We try to convince our clients to go for Informatica, but the cost is too high, and they choose another product.

I've been using this solution for 15 years.

It's a reliable and perfectly stable solution.

It is scalable but to a certain limit.

I'm satisfied with the technical support.

Previously, I used IBM MDM, Orchestra Networks MDM, SAP MDM, and Oracle MDM. I have used a lot of MDM tools, and I've found that Informatica is the best solution out of all of them in terms of the architecture and user-friendliness. Also, the graphical user interface is very simple to use.

The initial setup is not very straightforward but not very complex either. It's somewhere in the middle.

Deployment can take six to seven months to a year or two years. It depends on the number of domains and the number of data sets you need to implement.

A team of eight to nine people can usually handle the deployment.

We mostly deploy on-premises and sometimes on the cloud. Informatica is very weak on cloud-based computing though.

We implement the solution for our clients.

Based on my clients' feedback, they have seen a return on investment in the long-term. After five or six years, they can definitely see that the value of their data is growing.

Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well.

If you are choosing Informatica, then you need to employ the right kind of service provider. If you don't have good implementers, you'll not be able to leverage the product. So, choose your consultant and service provider wisely; then, you will not have any issues when implementing Informatica.

I would rate Informatic MDM at eight on a scale from one to ten.

Informatica MDM's most valuable feature is the interconnection between multiple Master Data domains.

Informatica MDM could be improved by adding drag and drop options, business data insights, and visualization reporting.

I've been using Informatica MDM for six months.

Informatica MDM is scalable.

Informatica's technical support is good, except for response delays because of time zone differences.

Neutral

The initial setup is simple.

Informatica MDM's price could be lower.

We evaluated TIBCO, IBM, and Microsoft.

I would rate Informatica MDM eight out of ten.

The most valuable features of Informatica MDM are it is cloud-enabled and has all the elements that are supposed to have in terms of MDM as a solution. All the features that are there. It is very well-integrated with any of the SAP and non-SAP applications. It is quite user-friendly. The user experience that you receive in Informatica MDM is quite good.

From multiple masters that are there in Informatica MDM, we can improve the financials.

I have been using Informatica MDM for approximately four years.

The stability of Informatica MDM is good.

Informatica MDM has very good scalability. When we say scalability it refers to the ability to add custom fields as per the requirement and then upgrade the overall data model the way you want for the client. 

The scalability is one of the most important features because the clients do not want to use a common data model. They want to have scalability so that they can upgrade the data model the way they want.

We have approximately 25 people using this solution in my organization. The users of the solution include data stewards, business data owners, data sponsors, technical architects, and testers. All kinds of people are using the solution.

There are certain challenges with the support from Informatica MDM, however, I did not directly contact them. It was somebody in my team who did.

I rate the support from Informatica MDM a three out of five.

I did not use another solution previously.

The initial setup of Informatica MDM is complex but is okay if you have experience. The full deployment took approximately five to six months.

Where one is the easiest and five is the most complex, I rate the complexity of the initial setup of Informatica MDM a two out of five.

The deployment of Informatica MDM was done by a whole team, approximately eight to ten people involved, and they had multiple roles. Each person looked after a different section, such as data, validation, and testing.

My advice to others is they need to first ensure that the functions of the solution are stable and the people who are supposed to implement it should have a good functional understanding. It is important that the team that is working on, in terms of standardization and data quality check, that it is a robust team, a strong team to take care of the solution. If we upload data in the system and then the data is not correct, then it becomes a very difficult job to clean afterward.

I rate Informatica MDM an eight 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.

It is generally used for the data integration between multiple ERPs. We have ERPs, and then we have third-party exchanges that sell products. The third parties are partnered up with some of the customers, so they create deeds, and we pull in orders and quote requests.

We're trying to get to the latest version. We're two revisions behind right now. It is a local install. 

It is on-prem, and we're trying to get to all-cloud. We do use the cloud for configuration, but we deploy it to the agents locally. We're using the cloud instance of Informatica to deploy to, and we're currently on Azure.

In the latest version, I like the outlay of the business roles creation. I like seeing that visualization as you're building it, as opposed to going through metatables or XML mappings. We liked that piece, and it makes it more intuitive for the business. 

Its GUI interface definitely helps visualize what we're trying to accomplish. There is always a disconnect between IT and the business, and it helps in creating the feeds that follow the business process flows with some of the types involved with the business.

It is so broad in what it can do. Their services have expanded beyond what they originally built it out to be. The best thing I like about it is that each time they add a new service to the platform, it easily integrates with the core, which is really nice.

The biggest pain point for us is the documentation. Typically, you have to go through knowledge forums and knowledge groups to find out about the syntax issues for interfacing with new products. Typically, you've got to deal with someone who has been through the pain before. Their documents are not really up to date with current innovations happening in the industry. As big as they are, you can't really expect it, but that's our pain point.

We've been using this solution for about four years.

We love it. It is very stable. It is probably the best thing we've seen in a while.

It can out scale our ERP. So, scalability is not an issue for us. However, it can overload our system, but that is not related to the scalability of MDM. It is related to the scalability of the system it feeds.

We have five business roles that are using it, and there are two admins who are supporting it. Basically, it is supporting an environment of about 5 billion in revenue. That's a lot for that amount of revenue. It is a lot of people.

We're trying to extend or expand more modules. We have MDM, and we're going into Supplier 360 and Product 360. We found that it is the most robust platform to integrate with our e-commerce platform. Basically, we have four different e-commerce realms, and we're going to consolidate them. So, Informatica helps with the supplier stuff coming in, harmonizing the data, propagating it out to the sites. In the future, the four sites are going to be combined and consolidated into one site, and then we'll be dealing with four different ERPs, and Informatica will be very key in that as well.

Their technical support is excellent. Whenever we had issues, they were pretty quick to respond. There was never an issue in finding them. The longest we had to wait for getting a resolution was a couple of hours.

I walked into this, so I don't know what they had before.

I wasn't involved with its setup.

It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there.

I would advise making sure that you have a very well-defined design before you decide you need an MDM. In our case, after MDM was in place and we turned it on, we realized that there are other processes that we needed to refactor for the purpose of MDM, which extended the rollout. This was not an MDM issue. It was a process issue in the business. That's why you need to make sure that the design is well defined. It helps to have their partners involved as well. We're dealing with Informatica consulting today to help design a Supplier 360 portal. 

It is hard to find people who are well versed in Informatica. It is hard to pluck one out of the place. You've got to go and poach for them. They're not out there open and looking for jobs.

I would rate Informatica MDM an eight out of 10.