Informatica Intelligent Data Management Cloud (IDMC) Reviews

We use Informatica to extract data from production. It's mainly the configuration of the systems. We extract data from one site in the same system and mass customer data to the test system. It's a list of customers that is a subset of the data. 

In our CRM, we have data on our customers, and the data in that system is a copy of the production environment. We have all the configurations manually modified to work as a test, but we can extract only new clients, which is a problem. We need to have a CRM with only the configuration but not the customers. 

My plan is to make Informatica work with the CRM. If it works, I am sure that I can get the budget to make it work with other systems, but the first system that I need to work with is CRM. The other ones are less important and don't have the same impact of making it work with the CRM. We're at about 80 percent completion with this project. 

Informatica is user-friendly, stable, and scalable. These three aspects are the most valuable for us. If we can make it work well with the CRM, we can continue or try again this year to complete that part of the project. I am confident that this kind of solution is what we need because we have a third-party resource that works in the development. 

We need to have a lot of hardware infrastructure to make our test system work. We use a complete copy of the production environment for testing, which is a real problem for us. The problem is not with Informatica as a provider per se. It's more of an issue with our system providers, but we need support to complete the projects. That's our real situation. With the pandemic, we have undergone many changes that have slowed down these projects in the last few years.

We have the license to deploy Informatica on any system we want. Right now, we aren't using it as much as we thought we would. We understand the solution, but it isn't easy in some areas. One problem is we have systems in which we don't know all the relationships among the data, and we need support from our providers to get that information. That is one of our most complicated problems implementing it.

Informatica's support understands the solution, but they lack the experience we need for our use case. That was one thing that we prioritized when we started searching for this kind of solution. 

Informatica is working well, but we need access to the production databases to extract the data. The real problem is understanding the data in the system that we don't own or provide. Those are the most problematic to implement with this solution. We make it work with what our team has developed. Deployment took four to six months. Right now, we have one developer and two or three system administrators using Informatica, so it takes about three or four people to deploy and manage the solution. 

We worked with the team we used for all the installations. They made it work. I can say that wasn't as good as I expected when we purchased the solution. When we started the implementation, we understood that they didn't have the research that works in this project because we did a lot of work to understand the data from the implementation team. That wasn't what we wanted because we knew that Informatica would be the most complicated of all the systems we would implement in the extraction. After all, they are our clients, and almost all other systems depend on that system. 

We have a perpetual license for Informatica, and we only need to pay for support. However, because we're not actively using it at the moment, we don't have the budget to continue with the support.

We evaluated several solutions, including IBM InfoSphere Optim and Delphix. We purchased 15 licenses at the same time that totaled around $230,000.

I rate Informatica Persistent Data Masking eight out of 10. It's important to have a robust understanding of the knowledge you need in the system. That is one of the main problems that we have. You need firm control over the systems to do data masking. All of the data is a subset because we want to make the subset and the data masking, but you have to have good control over the systems. I think that is the key.

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.

At our company, we use Informatica MDM for data architecture and numerous other aspects of data warehouse, such as data designing or modeling. We recommend Informatica products to our customers based on their use cases, data volume, budget, and environment suitability.  

The product isn't mature enough to provide suitable connectors to various data engines. The performance of the solution in transporting data between data lakes and Big data infrastructure is not up to the mark. At our company, we use a similar solution called Spark, which is much better than Informatica MDM in terms of performance and speed. The data support capabilities of Informatica MDM can be improved. 

It's a stable product without any bugs or glitches. But overall Kafka is a better product than Informatica MDM. 

The product exhibits satisfying scalability. 

The tech support is satisfying from the vendor. The support team was able to respond and solve the issues in a very short time. I would rate the tech support an eight out of ten. 

Positive

Informatica MDM easily integrates with the Informatica environment as well as with third-party tools. But for some integrations, for instance, when Informatica MDM is integrated with SAP, the functionality slows down drastically; the task that would take five minutes with Spark takes five hours with Informatica MDM.

The same scenario occurs when Kafka is integrated with Informatica MDM. For popular database integrations such as Oracle and SQL, Informatica MDM functions well enough. 

The initial setup of the solution is straightforward. Our company professionals suggest that Informatica MDM should be on a Linux server instead of Windows. 

The product is very expensive compared to other competitor tools. Informatica MDM is not meant for small businesses but rather used by large enterprises like banks or government organizations. Informatica MDM can be purchased as a stand-alone product and doesn't come in an Informatica bundle. The support for Informatica MDM is not included in the standard licensing fees and must be purchased separately.  

I recommend that others test Informatica MDM with different integration tools before making a purchase decision. I also advise others to evaluate the use cases before choosing a product. Other popular competitor tools in the market include Collibra and SAP MDG. 

Informatica MDM fits our organization's use cases perfectly. When a customer of our company has a plethora of business products, VOCs need to be implemented, even if it's a different MDM solution than Informatica MDM.

Some customers depend on a single technology ERP, while others work with Oracle ERP or SAP, and sometimes they are using ERP and Informatica MDM in combination or migrating from one ERP to another. These use cases will impact the setup that already exists on the customer's site, and thus, the solution needs to be configured accordingly. I would rate Informatica MDM as eight out of ten. 

We use the tool to collect, integrate, and process the data from different sources. Later, we direct the processed data to the required solution for analysis purposes.

It is a cloud service integration platform providing flexible and scalable data management architecture. It enables seamless integration with large data ecosystems, including Hadoop and NoSQL databases. It supports real-time data streaming platforms as well.

They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently.

We have been using Informatica Data Integration Hub for the past six months.

I rate the platform’s stability a seven out of ten. The complexity depends on the types of data. It has a robust software architecture.

The product offers two types of scaling mechanisms. We can add more nodes, integrate the service grid, and distribute workloads across multiple processing units. Also, we can add more resources, including CPU memory. It enhances the capability to handle large data volumes.

We can even utilize the load-balancing feature while handling high volumes of data. I rate the scalability an eight out of ten for efficient adaptability, pricing, and performance.

The technical support services are good.

The complexity of the initial setup depends on several factors, including types and volumes of data. It also depends on the data integration and configuration.

Working with a healthcare client with diverse locations, we faced the challenge of analyzing data in isolation, making it difficult to generalize findings across different areas. With the help of Informatica Data Integration Hub, we can collect data from various locations and enhance business insights.

We are familiar with centralized publishing and subscription models. It ensures the enforcement of data governance policies across all data sources and consumers, promoting data consistency and quality.

The automated artificial data synchronization facilitated by the data integration hub has proven invaluable in supporting our daily operations. It ensures the continuous updating of data, preventing delays and inaccuracies that may arise from using outdated information in analyses. This capability became particularly crucial during the sudden changes brought about by the COVID-19 pandemic, allowing us to adapt swiftly to the evolving business landscape. However, they could provide us with real-time data to increase the efficiency of manufacturing processes.

I advise others to understand the different data resources available in the organization before making the purchase decision. I rate it an eight out of ten.

We use the solution for party data management. The tool ensures that the information is the same in every business system so that all the systems have the same view of what parties are involved in an agreement.

It is easy to create REST-based interfaces of the master data objects. It can be used for reading, creating, and modifying the master data objects of the parties, their addresses, and contact information. The creation and modification features always consider the data quality rules, and it is a very powerful way to provide a data interface to master data objects. It is missing in many other tools.

The solution meets the performance needs of my organization. There isn't much that Informatica doesn't do. The maintenance of the data quality rules has been improved. It’s a lot better than it was when we started. Replacing the old SOAP APIs with the new REST APIs is a great improvement. It’s still a work in progress. Some interfaces still use the old SOAP APIs.

The management of different properties is sometimes divided between different user interfaces. The tool should provide a unified user interface to manage the data objects.

I have been working with the tool for ten years.

The tool can scale according to our needs.

The initial setup was not difficult. We had very good support from Informatica’s professional services.

The team was a mix of in-house, vendor and other consultants.

The product has a high price point. However, it does not lack features. TIBCO EBX and Profisee are much cheaper. However, they lack features that Informatica MDM provides out of the box. Though the list price of Informatica MDM is high, it is negotiable.

I do not have experience with the new workflow engine. It is much more extensible because it is a full business process engine. Overall, I rate the product a nine out of ten.

I mainly use it for data management.

It's for tool management, maintaining the golden record of customer status.

Data integration should be improved. Another area of improvement is customer applications, along with business 365 application case integration between applications.

I have been using this solution for three years now. I work with the latest update.

I would rate the stability a six out of ten. There is room for improvement in the stability.

I would rate the scalability of the solution an eight out of ten. There are currently nine end users in my team. There might be more people in the company. 

Recently, Informatica MDM upgraded, it transitioned from its traditional on-premise MDM offerings to a cloud-based platform called Informatica Intelligent Cloud Services (IICS). So, we are not planning to expand its further usage.

The customer support and service are helpful. 

Neutral

I would rate my experience with the initial setup an eight out of ten, where one is difficult, and ten is easy. 

It is very easy to set up. However, the deployment time depends on the configuration. It can take 10 to 15 minutes.

The pricing is reasonable.

The users should have more training on Informatica MDM, especially practical training. The vendor should provide some practical training.

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

My company works with our different customers to implement and install the solution.

The workflow in Informatica Axon is intelligent and good. Informatica Axon provides good data collection and good search criteria. In Informatica Axon, workflow and business glossary are good.

There are some limitations with Informatica Axon when one tries to connect or integrate it with Jira. For example, I can't delete any workflows after the integration process. There are issues with the integration capabilities of the tool with third-party solutions, specifically Jira.

I have experience with Informatica Axon for two to three years.

It is a very stable solution.

It is a scalable solution.

I recommend the solution to big companies because its functions are suitable for high-end companies.

The P1 support offered by the solution's technical support is very fast. If it is not P1 support, the support a user might get will be slow as it takes time. I rate the technical support a seven out of ten.

Neutral

For data governance, I work with Informatica Axon only. I prefer Informatica Axon for enterprise metadata management at an enterprise level, data quality, and integration. I only recommend Informatica Axon, mainly for data governance.

The product's initial setup phase is very easy.

For each of our company's customers, with an installation scope in place, it doesn't take much time. The product's implementation scope differs from the installation scope. I usually help our company's customers implement the tool.

The solution is deployed on an on-premises model.

Informatica Axon is a very good product with an easy implementation phase and a lot of information about the tool available online on the internet.

I rate the overall tool an eight out of ten.

I use Informatica MDM to align data in my company.

The ability to aggregate and put together data from around fifty sources into one environment allows us to have a preview of everything in a single place, which is something we did not have previously in our company.

The most valuable feature I see in Informatica MDM stems from everything that touches the area of data governance.

I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required.

I have been using Informatica MDM for five years. I use the solution's latest version. I am a user of the solution.

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

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

Around 250 users of the solution exist in my company.

There is a need to use the solution in my company at least three times a week.

I rate the technical support an eight out of ten.

Positive

I have experience with other solutions. I switched to Informatica MDM from other solutions since it offers better scalability options and interoperability.

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

My company has deployed Informatica MDM with the services offered by our cloud partner.

Informatica MDM's deployment phase takes around a year to be completed.

Two people, who are data engineers specialized in Informatica MDM, are required for the deployment phase of the product.

Informatica MDM's deployment phase was carried out with the help of my company's in-house team and Informatica's partner.

I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price.

Ideally, only one person is required to take care of the maintenance part of the product, but with the number of terminals where the solution is deployed, there may be a need for three or four people.

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

I rate the overall solution an eight out of ten.