Informatica Intelligent Data Management Cloud (IDMC) Reviews

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 essentially use Informatica Axon to set up a data governance framework for a corporation, usually a medium-sized or large organization.

The dictionary, the search, and the ratings are without a doubt the most beneficial components of this solution. 

Socializing data governance is one of the examples, but I'm not sure what the others were. For instance, if you locate a specific data attribute, you can grade its accuracy by assigning it a star rating between 0 and 5. 

When someone else conducts a search, they might discover whether employees at the company believe the data to be of high quality.

In terms of additional features, I believe it is quite rich. As I previously stated, it is a fairly mature product.

The main issue probably has nothing to do with end users, but installation can definitely be simplified. Also, I believe that this is something that they are already working on it, but it needs to be provided as a service. 

The Microsoft version, Purview, is now available as a cloud service, it must be provided as a service rather than just installation. You do not need to go through the installation, you literally create an account in five minutes. That is something they need to do. I believe that it is already something they are on working on, but I don't believe it has yet been released.

Over the past year, I have definitely used Informatica Axon.

I have worked with Informatica Axon for two years.

We are always working with the latest version.

Informatica Axon is a stable product.

It's a fairly mature product. For many years, it has been the market leader.

Informatica Axon is a scalable solution.

The smallest organization would have 500 users.

Any of the multinational corporations could be the largest. It's quite pricey. 

It is commonly used by large multinational corporations.

It has two or three user interfaces, one for everyone in the organization, one for specific data analysts, and one for IT technical staff.

Like many organizations, technical support responds quickly at times. It can take some time. It's about average, in my opinion. I wouldn't say it's particularly good or bad. It's average.

I would rate the technical support a three and a half out of five.

Neutral

I am just really familiar with Azure DevOps as a deployment technology.

Some of the Azure services, such as Database and Purview, and Informatica tools, such as Axon, and Data Governance, are among the things I am familiar with.

Informatica Professional Services should absolutely perform the installation due to its complexity. Additionally, training is required for end-client configuration. It is not something you can pick up and configure immediately.

Although there is no cloud version of it yet, it can be deployed in the cloud as a virtual machine, or VM.

Axon itself, you normally allow anywhere between five and ten days to conduct the installation configuration together, and that's not elapsed time. It normally takes a week to two weeks to install and configure an initial setup. This is elapsed time, not necessarily man hours. You will always need additional configuration to be done. Although the actual installation and configuration might be completed in a few weeks, getting it ready for use by the organization might take six months.

We do not have a technical team. I was the person who deployed this solution.

It was a challenge, but I did it for the POC.

Informatica Professional Services was consulted when it came time for the client's actual installation.

Axon can typically be present; the technical installation only requires one person, and a second data specialist is typically required for configuration. Normally two. Additional technical setup and data configuration are required.

It is definitely high if used properly, but many organizations spend all of the money and then fail to use it to its full potential. It is unquestionably a good investment if used properly.

It depends on how the client uses it.

Pricing is determined by the number of licensed users as well as the number of Core CPUs. 

You can imagine how expensive it would be for a company with 10,000 users, but it all depends on how many analyst user licenses they require. 

I believe there is a flat fee for the end user. 

It is not expensive, but individual licenses are required for technical users, data analysts, data stewards, and the data governance team, which can add up if you have a large number of them.

Different clients may have different licensing costs, but it is based on a yearly paid license. It is renewed every year. There is an initial licensing fee as well as an annual renewal fee.

They are very expensive, and they charge a lot because they know they are number one. I would rate them a five out of five. Five being the most expensive.

I would definitely recommend it. If they can afford it. I strongly advise them to use it. But, before diving into Axon or any of the other governance tools, make sure they understand their data landscape thoroughly because the tool will not help them with that. They will fail if they do not have good data practices in place.

I'm a freelancer, but the consultancy I went through is also independent, but they do have a partner relationship with Informatica, as they do with many vendors.

I would rate Informatica Axon a nine out of ten.

Informatica MDM is used for customer affiliations and sites and hierarchy management.

Informatica MDM has helped our organization because we now work from a harmonized single record for customers and patients. We're able to have an aggregation or hierarchy view, which drives a whole variety of things, such as data quality and data reliability.

The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs.

Informatica MDM can improve the data catalog and data marketplace.

Informatica MDM is expanding in AI by making it much more efficient and automated stewardship-related work. I'd like to see that accelerated and made available for on-premise.

I have been using Informatica MDM for approximately four years.

The stability of Informatica MDM is good.

Informatica MDM is scalable.

We have approximately 100 people using this solution in my company and their roles vary. For example, we have stewards, data analysts, platform administrators, architects, developers, and support teams. The active users are primarily stewards and data analysts.

We rate Informatica MDM support on an annual basis and we have quarterly executive business reviews where we discuss support issues.

Positive

We previously used SAP for MDM. We switched because there were new use cases that SAP couldn't meet. 

The initial setup of Informatica MDM is more complex than it should be.

We used a third party for the implementation of Informatica MDM.

We have approximately 20 people that do the maintenance and support of the solution. This includes support admin teams and architect engineers. We have a BA for each of the domains, shared architecture, shared engineers, ETL, and MDM. Additionally, we rely heavily on third-party assistance.

We have seen an ROI in duplicate data management, visibility to market share, and reduction in risk.

I rate the licensing cost of Informatica MDM a five out of ten.

We did go through a solution selection and RFP process before we chose Informatica MDM.

My advice to others is for them to look at SaaS and cloud options first.

I rate Informatica MDM a seven out of ten.

Informatica MDM has a lot coming ahead from a solution standpoint, which is a benefit for them. However, there's a lot of configuration involved to keep the solution going and this is why I would encourage a SaaS solution for anyone coming in.

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.

We use the solution to validate emails, telephone numbers, and postal codes. It can also create some data quality rules using the Cloud app's data quality function.

It offers enhanced usability with the ability to create rules quickly using its AI engine. This feature simplifies rule creation by allowing users to specify their needs, and the system generates the necessary scripts, acting as a significant accelerator. 

Another advantage is its seamless integration with other Informatica capabilities, making data quality a deeply embedded part of the solution. Informatica has a strong history in data quality with its on-premise product. All those powerful capabilities are now available in the cloud, making this product even more robust.

Accessing data as a service is essential, especially for validations requiring external data services. This goes beyond basic syntactic checks, like ensuring an email address contains the @ symbol or .com domain. Instead, it's about advanced validation, such as verifying if an email address exists or if a phone number is valid. 

These services are in high demand, especially for regions like China, Argentina, and other parts of Latin America. While such capabilities were initially more common in the United States, they are now increasingly required globally.

Five to six people are using this solution.

Informatica Support is one of the best services available in the market now.

Positive

Many clients acquired this product because of the ROI.

Informatica is one of the most expensive solutions available in the market.

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

In the past, people used Informatica MDM because it was one of the leading tools at that point in time to work on an on-premises model. It was the leading tool in the market, offering vast customization options and matching and merging options that were better compared to other solutions. The way the data lineage or the customization options it gave, the tool was good. Now, the tool has a changed dynamic, and it is currently available on the cloud. Apart from Informatica MDM, there are other tools, as well as the market, that are completely on the cloud.

The feature of the product that has been most helpful in improving data quality revolves around Informatica DQ or IDQ, which is one of the tools Informatica offers. IDQ helps cater to the scoring of the data, clean up the data, and integrate it.

In terms of the room for improvement required in the product, I would say that the product is still in the maturing phase, specifically on the cloud. The product is not too user-friendly to do the configurations. There are a couple of areas in the product where I feel improvements can be made, but if I consider the algorithms used in the match process, the tool is very robust.

I have been using Informatica MDM for nine to ten years. My company is a partner of Informatica, and we also implement the tool.

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

In terms of scalability, I would say that the product is currently more available in the cloud. Scalability-wise, I rate the solution a five out of ten. The scalability on the cloud is good. On the cloud, by default, the tool becomes quite scalable.

Informatica provides premium products. The product is mainly meant for enterprise-level customers because the tool is available at the premium cost.

I have not used the technical support provided by the product. If you asked me about the support offered for the tool's on-premises model, I would say they were really good. We really liked Informatica's support. With the cloud, I'm not aware of the support.

If one is a difficult setup and ten is easy, I rate the product's initial setup phase as a five.

If you are talking about the product on the cloud, the initial configuration must be done. There is quite a lot of refresh which takes place every time we have to publish something, and then we have to wait for some time. It is not that you make a change, but you can see it immediately in the tool. The wait period is quite long. If you are a first timer, it takes time for that person to figure out the product. Once you get the hang of it, then it becomes easy.

An end-to-end implementation would take nine to ten months, or maybe a little more than that, depending upon the customer's desired features.

The tool does give a good ROI.

The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives.

On a scale of one to ten, if one is a cheap solution and ten is an expensive one, I rate the tool's price as seven.

Informatica MDM is able to handle complex data integration scenarios with the help of IDCM, which offers the power of an ETL tool.

Speaking about the AI part, I feel the product is still in the maturing phase.

My first preference would be for Welkio, and only after that would I prefer Informatica MDM, so I would say that it won't be my first choice.

I rate the tool a seven out of ten.

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.

A wide range of solutions exist because data is primary, and my company looks over many overall data management solutions, from which Informatica Data Quality becomes one of our biggest priorities.

I cannot just go into details of the product's features randomly because if you look at a very wide range of overall requirements, be it Informatica or Talend or more data lake solutions like Snowflake. My company goes through an entire range of areas, making it difficult for me to just speak about the features.

Accuracy is one of the key areas a client looks at before using a solution. Considering internal data from legacy systems, it is quite difficult to know if Informatica Data Quality meets that high level of accuracy criteria. The aforementioned area can be considered for improvement in the solution.

I have been a consultant for Informatica Data Quality for two years in my company. I don't directly use the solution.

From a stability point of view, I haven't heard of any complaints about the solution from any of my company's clients who use it.

I don't go into the technical side of Informatica Data Quality much since I mostly work on the procurement side and market knowledge area related to the product. Scalability remains one of the requirements of the clients who buy the product, especially for future growth. My company caters to a mixture of clients, consisting of small, medium, and enterprise-sized businesses.

I do not go into the complete deployment areas of Informatica Data Quality.

The solution is deployed on a hybrid cloud.

Informatica Data Quality is a product that is worth the money.

I rate the product's pricing a seven on a scale of one to ten, where one is the lowest price and ten is the highest price.

I do look at a number of data quality tools, but Informatica, Talend, and Ataccama are a few of the top solutions I have come across.

My company deals with Informatica Data Quality since Informatica is a big vendor in the overall data management area.

I won't be able to speak on how I can recommend the solution to others since my suggestions will have to be based on the product's features and technical details. I wouldn't be able to point out anything about the product in detail, especially since I am not much of an end user.

Based on the feedback that I have received about the product from my company's customers, I rate the overall product a seven or eight out of ten.