Informatica Intelligent Data Management Cloud (IDMC) Reviews

We are using Informatica Cloud Data Integration in a large organization, and we have customers all across the world. 

Informatica Cloud Data Integration is for migrating data from a source to a target. The major advantage of working with this solution is that it can handle large amounts of data. The drawback is the performance is a bit slow but it can handle a large amount of data compared to other tools.

The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server.

Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them.

In a future release, the UI should be more developed to allow more features.

I have been using Informatica Cloud Data Integration for approximately four months.

Informatica Cloud Data Integration is stable. 

I rate the stability of Informatica Cloud Data Integration a four out of five.

There are some performance issues sometimes.

We have more than 50 developers using the solution in my company.

I rate the scalability of Informatica Cloud Data Integration a three out of five.

The support from Informatica Cloud Data Integration is great. They respond quickly and if there is an issue it can be resolved fast.

I rate the support from Informatica Cloud Data Integration a four out of five.

Positive

Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality.

There can be extra changes, such as using the cloud.

I rate the price of Informatica Cloud Data Integration a two out of five.

This is a good tool and others should use it. This solution is known for its ability to handle large amounts of data and in the market, there are not that many tools available. However, there are competitors in the market, such as Oracle and IBM.

If an organization's data is very limited and they are not using large amounts of data, then I would suggest going for a smaller targeting solution, such as Dell Boomi. When it comes to large and secure data, I would recommend others to use this solution or SAP BODS or IBM.

Informatica Cloud Data Integration has a nice GDP rating and a good European market.

I rate Informatica Cloud Data Integration a seven out of ten.

The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data. 

The solution's ability to integrate with different solutions is a big selling point for us. It's also quite powerful and customizable. I really enjoy its match and merge capabilities.

When it comes to UI look and feel and user experience, Informatica is not as good as other solutions.

There are some MDM solutions that come with an integrated view, which includes your transactional and master and all other data together and helps you get a 360 view of the object. That's where I think Informatica is not as powerful or as agile in the way other solutions are out of the box. 

It's quite simple to scale the solution. We have about 30,000 users, but I don't see a limitation on the solution that would stop you from having more.

Technical support is pretty good. It does take time. Some solutions are not fixed, but they have releases and updates that deal with the issues, so, I don't see a lag in support in that sense.

In 2010, there were only maybe three solutions: SAP, IBM, and Informatica. Before that, we didn't really have a centralized mass data contract, so it was more of an application grievance. With Informatica, we gained centralization of mass data, and also had governance and quality as part of a data management practice, and I think, at the time, the full package was available with Informatica as compared to other options.

I was not the installer, so I'm unsure of how complex the initial setup was.

We use the on-premises version of the solution.

I would recommend the product, but it depends on your business and other solutions you might already be using. If you're only using SAP, I don't think you'll need Informatica. If you're using Oracle products, you don't even need SAP.

However, if you're looking for an essential repository with very good integration capabilities, want to have a longterm sustainable solution, and you have multiple ESPs, as well as a wider organization setup, then I think Informatica is the best.

I would rate the solution at eight or nine out of ten.

We use the solution for data cataloging and lineage.

The valuable feature is metadata management. If you want to trace sensitive data, you can auto-classify them. You can search for sensitive information through EDC. Using Discovery, you can identify if there is any type of data set.

EDC is only used for cataloging and meetings. Currently, not many different databases are integrated with it. The ETL logic should be visible within the tool. If EDC is integrated with Axon, you will see the data lineage and catalog because of EDC. If EDC is removed, you cannot see any lineage or catalog.

We need EDC on the application level. Currently, it is only at a system level. It can be shown as an application layer between policies or regulations. This kind of feature can be enabled.

The integration with other data management tools can be enhanced. For instance, there is no integration with tools like Collibra or Hubview.

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

The solution is stable.

EDC needs many ports to run. Therefore, to improve performance, you need to increase the number of cores.

The initial setup is easy and takes two weeks to complete. One person is enough to deploy it.

EDC gives you a better understanding of architecture and the system used. You cannot use EDC completely unless you have access.

The product is expensive.

EDC is a standalone application, so it doesn’t really make much sense. It doesn’t give you a lot of features that way; it’s primarily for cataloging and classification. Nobody would buy EDC as a standalone application. When people are buying EDC, it’s always with Axon.

I recommend buying the solution altogether with Axon.

Overall, I rate the solution as seven out of ten.

Informatica MDM is used for our customers' master data management journey. The solution meets our client's requirements for their customer-supplier or any other entities.

The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation.

Compared to other tools in the market, Informatica MDM is costly.

I have been using Informatica MDM for 13 years.

Informatica MDM is highly stable compared to any other tool in the market.

Informatica MDM is a highly scalable solution. Our clients for Informatica MDM are mostly medium and enterprise businesses.

I rate the solution eight and a half out of ten for scalability.

Technical support refuses to support us if we customize the tool. We customize the product based on the customer's needs, and we expect Informatica to provide support during that time as well.

Positive

On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup an eight out of ten for on-premises and nine out of ten for the cloud version. Setting up the tool in the cloud via IDMC doesn't take much time.

The solution can be deployed within a few hours.

Our customers have seen a return on investment with the solution.

Informatica MDM is an expensive solution. On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing nine and a half out of ten.

I would recommend the solution to other users because of its reliability and stability. Compared to other product vendors, Informatica MDM always has additional features. Informatica MDM has a CLAIRE AI engine, which helps with AI automation.

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

You have to deal with a minimum of five, even if you want to go and check only a particular logic, making it an area with issues where improvements are required.

Certain shortcomings in the product's UI make it an area where improvements are required. The tool should provide ease of use and flexibility.

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

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

I see that my company faces frequent challenges in the tool when it comes to the area of UI and related to the area of characters. In my company, we have experienced some issues that occur when upgrading the tool.

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

Enterprise-sized customers can choose Informatica Cloud Data Integration.

The technical support for the solution is helpful, but it takes them time to figure out the issue. The time taken to close the ticket depends on the support that Informatica gets from their backend technical team. It takes a long time to close a ticket. I rate the technical support a seven out of ten.

Neutral

The product's initial setup phase was not difficult.

The product's deployment phase can be carried out by linking a .exe file provided by the solution with your server.

The solution is deployed on the cloud.

Against Informatica Cloud Data Integration, I recommend SnapLogic, which is a cheaply priced product. People know about SnapLogic, as it comes with very good features and ease of use.

The feature of the product that I find the most beneficial for data warehousing tasks is the use of the tool for extracting and loading purposes, which depends upon the connector's availability. Many connectors in Informatica are not free or out of the box, and you have to purchase them. The tool has quality connectors.

I haven't used the tool for real-time data analytics, but I have used it in my company for batch-oriented purposes. Data integration will not be supported in real-time in Informatica Cloud Data Integration. For real-time data integration, you have to go with either the application integration or other products like Informatica PowerExchange.

In Informatica Cloud Data Integration, the transformation feature was almost the same as that of Informatica PowerCenter. In Informatica Cloud Data Integration, the transformation features may offer a couple of more functionalities.

In terms of the ease of learning that the product provides, I would say that those who have experience with Informatica PowerCenter can easily adopt Informatica Cloud Data Integration. A person who has worked on Informatica Cloud Data Integration may not be comfortable with Informatica PowerCenter. In terms of ease of use, I consider Informatica PowerCenter to be easier than Informatica Cloud Data Integration.

I rate the ease of use experience attached to the tool a six out of ten.

Only after considering the use cases of people can I recommend the product to them. If a person only wants a product for extraction and loading purposes, then I feel that there are many cheap products in the market that can satisfy their needs. Suppose someone is looking at a tool that offers widespread features, like application integration and real-time functionalities. In that case, all of it comes under Informatica, which can be a good option.

The tool is the most expensive one compared to any of the other products in the market, especially in terms of ETL functionalities or integration features.

My company has integrated SAP, many databases, and APIs into Informatica Cloud Data Integration.

I can see that the performance of the product keeps improving with every new release, especially in the area of job executions, even though the hardware may be the same.

I rate the tool a seven out of ten.

I use Informatica Data Quality to consolidate master data across our organization, ensuring consistent and high-quality data. Combining MDM and data quality features, we address issues like customer data inaccuracies. Additionally, we document business terms in our data catalog for a unified view across the company.

The profiling feature in Informatica Data Quality is incredibly effective for data governance. It helps identify data types and potential duplicates, streamlining the detection process. It also suggests matches with predefined fields in our catalog.

There is room for improvement in the Data Marketplace aspect. Specifically, we found some basic functionalities lacking, like transparent integration of quality indicators. Customizability and additional features in the Data Marketplace would be welcomed in future updates. 

I have been working with Informatica Data Quality for three years.

I would rate the stability of the solution as an eight out of ten.

Scalability with Informatica had some initial challenges, especially when ingesting metadata into the data catalog due to the large volume of source systems and data. While it eventually worked, it took considerable time. Overall, I would rate it a six out of ten for scalability at the moment.

Initially, a few hundred users were using Informatica, but now it is a few thousand. 

The technical support is good. I would rate them at a seven out of ten.

Neutral

Maintenance and troubleshooting are handled solely by the vendor.

Informatica's licensing cost is among the highest in the market. I would rate it as a five out of ten in terms of costliness. With Informatica, we have a single bundled agreement covering the entire solution based on total capacity rather than specific modules. 

Before choosing Informatica, we evaluated various vendors, including IBM and Microsoft. Initially, we considered a best-of-breed approach, but Informatica emerged as the preferred choice for three out of four key areas: MDM, data quality, and data marketplace. While there were some limitations in certain tools like the data marketplace and data catalog, we opted for Informatica's complete suite to avoid additional integration efforts and to capitalize on its strengths in critical areas.

The rule-based strategies feature in Informatica Data Quality has greatly benefited our data quality initiatives. With predefined rules in place, it provides a solid framework for assessing data quality. While data quality ultimately depends on source system updates, these rules give valuable insights and are heavily used alongside automatic profiling for effective data management.

Informatica Data Quality works within our IT setup for analyzing and reporting on data quality. It doesn't directly integrate with other tools, but it gives us clear insights. Data flows from sources to Informatica for analysis, and then to data stewards for updates, but there is no integration back to the original applications yet.

Navigating between modules within Informatica isn't always seamless. For instance, actions in the catalog might not be visible in the data marketplace.

Overall, I would rate Informatica Data Quality as an eight out of ten.

I use the solution for preparing the data according to the data quality rules.

The mapping and mapplet features are valuable. The product improves data quality. The processes are running smoothly. The interface is good. Data integration is easy.

I use the solution to integrate on-premise and cloud products. There are issues with connectors to cloud applications. The integration process is not easy. The customer experience must be improved. When we implemented it, we did it with the help of Informatica professionals. I would not recommend them as an implementer. They didn't have any experience. It was very hard. The customer experience was not good. It's hard to understand the new features of the HR list. The tool must have more options for connectors. It is hard to connect to some of the applications. The remediation process is not straightforward.

I have been using the solution for one and a half years.

I rate the tool’s stability an eight out of ten.

I rate the tool’s scalability a six out of ten. It is a bit complex to scale. We have 20 users.

The technical support is not good. The support team must improve the quality of support.

The product is cloud-based.

We got a 50% discount.

We couldn’t deliver the full project. I will not recommend the product to others. Overall, I rate the solution a seven out of ten.

The solution is mostly used to automate MDM, send keyword dimension sites to the engineering team, or address historical records for the training-based employee.

The valuable feature is that we can automate the integration part. Also, it's suitable for data quality. The solution also helps create the data that has been helpful in data governance. We performed some effective or administrative charges in real-time and, most recently, in a real-time solution. So, it allows enrollment to capture and transform the data anytime.

Most of the demand is about how MDM can be automated so the changes occur automatically.

The whole server will change the storage engine, like any tool key, so everything can be automated.

Informatica MDM has limitations with connectivity. This is evident when we connect with our console, especially sometimes the process gets filled. With the tools we are locally running from our end, there should be some specific instance to register that is helpful and can support Informatica in running its modeling.

More automation is much required nowadays, as mainly the work will convert into a complete normal manual process.

There should be some specific integration tools, the managed services, involving the application, and then the code they use. That should be sufficient, meaning there should be leverage to openly adopt any new integration environment like PySpark that we will use. Some resiliency with the particular application, the code, and the type of files only can we address.

I have been using Informatica MDM for more than ten years.

It is a stable solution.

It is a scalable solution for sending any new setup or data. Approximately six hundred users are using the solution.

The technical support team is good. The administration has access to both servers. They can only provide access to run the tool, allow authentication, and how data can be secured. I rate the service and support as ten out of ten.

Positive

Previously, I have used Microsoft SSIS and AWS Glue, but Informatica is capable of doing multiple things for integration purposes, but also for data evaluation.

The initial setup is straightforward. The deployment took ten to fifteen minutes, and almost fifteen administrators were needed for the deployment.

I would say that based on the current scenario, the market trends show that it is not required for the price to be increased. But, functionality-wise, and considering that now as the trend of microservices is going on in the market if Informatica MDM can be replaced in a similar way with particular tools or components to meet the client's demands, we can use only those particular things for the DDoS service covering, for the backup, for the security, and data encryption. So that can be helpful. Part-wise, if somebody needs only the pipelines to be created, someone needs to get a complete data flow task, or someone requires only the MDMs to get in place and not complete information that they need to make. We have licenses, and we are provided with certain particular services in the solution.

I urge those planning to use the solution to understand how they are modeling data encryption and data governance activities. Suppose you are implementing without knowing your data quality and data governance. In that case, the installation of those sources through MDM is not affected. So better to better understand the basics.

Then it will be helpful to use something specific.

I rate the overall solution a seven out of ten.