Informatica Intelligent Data Management Cloud (IDMC) Reviews

We are customers of Informatica PIM and I'm a senior architect. 

Informatica comes with a predefined data model which is the way in which you enrich your products. It acts not only as master data but also as a product enrichment tool. The product provides flexibility; you can go for an undefined number of attributes that define a product. You can plug it in with any e-commerce website. That's its value to us and why we need it. 

Database access is highly restricted with PIM. If you're using the cloud version, you probably won't have database access or a view of it. If you're wanting a customized application, you can develop the out-of-the-box PIM solution with a little bit of customization here and there without even needing a database. That's a very big drawback. As a developer or as an architect, you need to have a data model. I know some people use it without database access and the issue is that they don't know what that data model is built on other than just seeing it through UI tabs. The one thing I'd really like to see is for the solution to be made scalable. 

The solution is stable, in terms of bugs they're very good. They keep evolving their toolset. I have encountered many bugs in Multidomain MDM, but to date not in P360.

Scalability depends on your use case. If you're using it as an integrator, then it is definitely scalable. That said, it would require an altogether separate MDM solution. If you don't have MDM, then there are likely to be some limitations. We're in the process of installing now but in my previous company, we created the core set of attributes through MDM. From there it went worldwide through an e-commerce website. We have 50 to 60 people internally using it as a tool. If you're exposing your data through an e-commerce website, then it's accessible to all, although just for reading and not for updates.

If you're working with Informatica, you need to interact with them on the out-of-the-box features. They are very efficient and quick in their response times. 

I've trained in Stibo which is a little bit better than PIM and I've used Oracle PDH and CDH. Those were basically a package MDM solution. If you're using SAP, I would suggest Oracle products. But there's been a very big evolution over the past decade when it comes to enterprise MDM tools. Most people working in companies are disbursed in different locations and using multiple toolsets, they can't be restricted to one technology. That's the reason that Informatica, Stibo, Riversand, and other technologies are very useful and very powerful. When comparing PDH to PIM or CDS to Multidomain, managing the Informatica toolset is easier in terms of effort required in comparison to managing Oracle MDM or Oracle CDH or PDH because they have their own set of limitations. The good thing is that they can be very easily coupled with an ERP solution. Here, you have to build real-time or multiple interfaces. 

The setup is relatively easy I would say. But if you need additional attributes, it gives you a repository manager feature where you can use XML, add your own attributes and then configure it. To my mind, the setup is simple to moderately complex.

Licensing costs are a little pricey. For my previous client, as a support contract partner, we were making less money than Informatica was charging them. 

Informatica 360 PIM was bought from Heiler and is a very good tool if you already have MDM in place and you simply want to use it as an enrichment tool. With Informatica, you perhaps need to go somewhere into the roots of Multidomain. P360, Multidomain, and C360 are all different things. Managing a thousand plus attributes into that data model is going to be very complex. If they could come up with a standard data model that Oracle offered customers like PCH or PDH, similar to what P360 has, that would be my preference. Also, my recommendation is to always utilize your team as an integrator rather than being a master data manager.

I rate the solution eight out of 10. 

I use the solution in my company and have worked with two tools from Informatica, both on on-premises and cloud models. I have experience with Informatica Axon, and I have used the cloud services under Informatica CDGC.

The use case of the tool is basically in the banking sector. It is used to optimize certain areas of a project. In Europe, we have a GDPR implementation. In the Middle East, there is the Central Bank of the UAE and UAE data protection law. Implementing data protection laws and ensuring that all the policies are enforced for financial security is my use case. I have to make sure the bank or financial institution meets the requirements of the Central Bank of the UAE. Data quality is another use case where my company handles corporate and retail customer data, and protecting their information is known as PII. The tool ensures that the system holds the PII data properly.

For data lineage, we look for things at a transformation level and how the data is transforming and managing the ETL mapping. Every tool gives this information about how the data goes, but our company is interested in knowing how the data is transforming and the transformation logic between the two data sources.

There are some tool limitations. Some connectors do not scan the metadata properly. If I want to scan the metadata from the data lineage or the Python code, such areas can get tedious in the tool. To manage such areas, one needs to have a lot of coding knowledge, and you need to know how to apply the code, and only then can you get it fixed. There is no user-friendly enterprise.

There are certain shortcomings even if we opt for subscription-based technical support.

I have been using Informatica Axon for four years. I work as a consultant.

It is a stable solution. Once it is implemented, we will handle everything for the business. Stability-wise, I rate the solution an eight out of ten.

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

The tool is meant for enterprise-sized businesses.

I rate the technical support a six out of ten.

Neutral

I have experience with Informatica Data Governance.

If one is difficult and ten is easy, I rate the product's initial setup phase an eight out of ten.

The solution is deployed on the cloud, specifically if you have cloud-based virtual machines. If there are compliance issues, and you need to hold the metadata only on-premises models, you can do that, too.

The solution can be deployed in a few days.

It is an expensive solution. I would say it is the most expensive solution in the market.

For the features of the software, the price is justifiable.

Speaking about how the tool enhances data governance tasks, I would say that we have three types of users, consisting of the consumer, who are normally a business user, then we have a developer and finally the admin. Our company onboards the user, and then the user can collaborate, comment, ask questions, give ratings to their assets, publish the data to the marketplace and go for downloads.

One needs to resolve the problem that stems from the fact that different people can have different understandings of the concepts associated with the tool. A database administrator may see an area as a table, but for a business, it may be a person. The tool gives you a common understanding of the business concept. The tool also provides lineage data and how the business data is performing. It provides an interface between organizational policies, the different processes governed by a certain policy, and the different systems governed by which policy. The tool gives you a 360-degree holistic view of the data.

The cloud version of Informatica Axon utilized the AI for the classification purposes, data domain and automatic data tagging. In my company, we use the tool's AI capabilities.

I will recommend the tool to others.

I rate the tool an eight out of ten.

Our use cases were related to the financial and banking sectors. We created data and transferred it to the enterprise level. 

The most valuable feature of Informatica Axon is features, interfaces, and data mapping. It represents clusters nicely. 

The solution should improve its integration. 

 I have been using the product for three years. 

Informatica Axon is stable. 

The product is scalable. 

The tool's support is fine. 

Informatica Axon's deployment is straightforward. 

I rate the product an eight out of ten. 

We use the solution for data modularization.

The solution has the best feature for parameterization. We can apply it at the mapping and task flow levels. It helps with auto-linking and dynamic linking options for flexible data integration.

The solution's capability to handle large volumes of data compared to its on-premise version needs improvement. Its features for partitioning and optimization could be better as well. There needs to be more options for partitioning, including database partitioning, pass-through partitioning, etc. Additionally, it doesn't support XML data types for SQL server databases. Also, it captures success and targets rows only within a system-defined area. It should be able to capture and track the number of rows processed by each pipeline.

Presently, users need to write code against the existing APIs to access information data. It is a complicated process due to the limited functionality of APIs. Instead, there could be an option to write queries against repository tables to fetch the data like its on-premise version.

We have been using the solution for two years.

The solution's technical support team could be responsive. We have to contact their global support team to raise new feature requests. Currently, we encounter issues with parameterizing email IDs at the task level to configure features for success, warning, and failure. We sent a request to them back in 2020, but they are yet to add those features.

I rate the solution a seven out of ten.

Test data management is a common use case. When conducting testing in lower environments, we want to avoid exposing sensitive information. To achieve this, we use Data Masking to modify the data. 

For example, we change personally identifiable information, phone numbers, and emails so that they cannot be viewed. The modified data retains the structure and format but doesn't reveal the actual information.

The tool is mainly valuable for testing teams, as it helps protect sensitive data during testing. It can also be used to mask production data for different users, ensuring that only authorized individuals can access sensitive information. These are the main reasons why we use this tool.

I think there's only one area that could be improved. Currently, when we apply the Data Masking rate, we don't have a way to view the masked data. It would be helpful if there was a feature to allow us to see the actual information.

Once the data is masked, it cannot be reversed. Having the ability to revert it back to the actual value would be beneficial, especially if we need to see the original information. Although our enrollment has decreased, it would still be helpful to have that feature.

I have used Data Masking as part of my work.

Stability is good. It's definitely reliable.

Scalability is good. It's definitely scalable to handle higher volumes across different platforms as well. It performs well in terms of scalability. 

Additionally, when it comes to implementing more source systems, there haven't been any issues.

Our experience with customer service from Informatica has been excellent. They are always available and responsive.

Positive

The initial setup is generally straightforward. However, there can be some challenges during the on-prem installation process, even though we have the steps and prerequisites. Dealing with installation issues is quite common, but overall, it's not excessively complex to set up.

The need for maintenance depends on the team. Sometimes, the solution you configure in the tool determines the level of maintenance required. However, overall, maintenance hasn't been a significant issue.

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

I'm a freelance consultant, so I work for a few different clients on different projects. Sometimes I do system integrations, and sometimes it's more of the deployment of the tool itself. 

Informatica Axon is mainly used for master data management because it's quite a powerful tool. Lots of clients are struggling because Collibra is not an MDM tool. Azure has some possibilities in the data factory for MDM, but in the end, it doesn't have the engine that Informatica has. I see quite a few clients bring Informatica into the architecture for ETL processes. They use it to extract, transfer, and load data, in addition to MDM, since they're a bit restricted with other tools.

I think definitely what my clients find strong about the solution is all of the processes that it can do. You can extract and transfer your data as you wish it to be consumed later. I definitely hear that this adds value to the tool. 

Another thing I hear clients say is that you can use the MDM modeling functionality as a kind of engine to do data cleansing before you consume the data.

Also, for example, Collibra works closely together with Azure, which works closely together with Informatica and Google because the clients have needs that can't be fulfilled all by one platform. Solutions needs to fit into that architecture, and Informatica can fit in there, and that's appreciated in the market.

There is always room for improvement in making the look and feel more user-friendly. There are also some technical issues sometimes with integrations because clients have a lot of different types of data sources.

One thing I miss with Informatica is the sandbox environment. I do freelance consulting, meaning I give trainings, and sometimes clients ask me to give a training in my own environment, my sandbox environment. 

I have an environment that Collibra provides me with for certifications of training, so I can use a kind of sandbox to actually show a few things to clients.  I have the same thing with Microsoft. With Informatica, it's a bit more difficult. They're not that willing to provide the sandbox to an individual consultant, so I'm just on my own. That's a bit of a pity because sometimes if a client has something that is not configured, I can quickly configure it in my own environment and then show it in a demo. I don't have that opportunity with Informatica. I have to work on the client's system, which then sometimes causes security problems.

I don't have complaints about the stability, and I don't see it as a big issue coming up with my clients. The app sometimes had issues for some clients but it was not business critical or actually impacting them.

I think it is scalable, but that is not really the focus of my work. There are a lot of reasons I can give that the scalability might be affected, but they are actually not really related to the tool itself, but just how you build it in.

If I have a problem with the client and I'm a bit stuck, the support is really good. I can fall back on the people from support and they're quite willing to help. 

It can also help the client because I do a project for six or twelve months, and then I'm gone. If the client has a question after that, they can talk to the support and it's really good. 

From what I have experienced, I would give the technical support an eight out of ten. 

Positive

I think the setup is quite easy if you are data-minded. If you don't have any clue about data management or don't have that background, you're not going to be able to do it. You need to have a bit of technical understanding to do it in the correct way. If you're completely new and you don't have that background of experience, then it's a bit harder, and you'll need to follow a step-by-step plan.

I see clients starting to set it up from scratch and it takes three years. If a client says they want to deploy it within their whole organization, then, in general, you need to count about three years because it's not only the tool. You also need to set up your governance and your organization on it. All of your processes need to be aligned with the tool, so it's a three-year program in general.

Both for the business end users and for the technical people, the maintenance is more on the technical side. For example, for the API connections, the batch processes, and the real-time processes, it's not always easy. One of the things that I always say to my clients is that they need to document everything, and that helps. I tell them to build into their project a documentation pillar where they document everything that they do, like their MDM and rules. It's easier if they have good documentation, but it's still a challenge. Without documentation, it's hard.

I think definitely starting it up gradually, meaning don't buy the tool and then start trying to put everything in from the beginning. First, think about: What do I want to bring into the tool? Which sources do I want to go integrate with the tool? Which data, which business areas do I want to cover with that? You need to do a modeling exercise. You need to do some preparation work first and take it slow. Start small, take a specific business unit or data domain, and then show the value for your business. Then the budget will come, and you can do more with the tool. 

I rate this solution as an eight out of ten.

Data Quality involves quality checks and data profiling. It scans through the data, providing metrics like the number of nulls and unique values. Informatica Data Quality profiles the data.

In my experience, I've specifically worked with a feature called ARS Doctor, which is part of IDQ (Informatica Data Quality). So, in my earlier project, the core functionality of ARS Doctor revolved around address information sourced from the USPS postal service. It does validate the data. This is crucial because customer addresses often contain diverse writing errors. Given the presence of multiple applications, addresses can be inputted or tagged across various systems or enter their address data differently, yet it needs to conform to a standardized format. 

Therefore, each address, even if inputted from distinct systems, undergoes validation to match a single, customizable format. We also have customized settings for these validations.

There's certainly room for improvement. One crucial area is generating detailed reports on file statuses. Presently, this is represented visually, often as graphs or charts. Such reporting could offer comprehensive insights into the areas that demand attention and further scrutiny.

I possess extensive hands-on experience and expertise in Informatica.

I do find Informatica Data Quality is stable. It generally maintains a high level of reliability and stability, making it an asset compliance in various scenarios.

In terms of scalability, you see, it is on the cloud environment, which itself gives the scalable, and flexibility in terms of accommodation of the data. So if we want to scan across the data for the quality and checks, like, not on any sample data. We really want to do this profiling on the checks on a lot of data. So it is very much visible in the cloud environment, which is cloud storage, which is provided by AWS or Azure, or GCP.

Based on my experience and involvement in reported discussions throughout my career, I would definitely give their customer service a high rating. We receive excellent support from Informatica's team, especially during activities like upgrades and other related tasks. 

Positive

When it comes to the initial setup, particularly in a cloud environment, it's primarily license-based. There are various features available, each catering to different needs. The platform can establish connections with various systems based on the connectors it offers. These connectors facilitate integration with different environments. 

When it comes to data quality, it is a license-based model. So, if you procure the necessary licenses, you gain access to the relevant options. It's all about tailoring the solution to the specific requirements of the project.

If the goal is to perform quality checks separately, there's the option to employ dedicated products for that purpose. Alternatively, data quality checks can be integrated into the data integration process. Naturally, data integration involves elements of reconciliation, verification, and quality assessment. The chosen approach hinges on factors such as data volume and the complexity of requirements. If these factors increase, the option to select different products designed for specific tasks becomes viable and can be explored further.

Overall, I would rate the solution a seven out of ten. 

The solution gives us the visual features on how the quality is because back in few years or back some time ago. So it was, like, always a kind of hidden thing because, as a part of the data governance, we do have a lot of data dumped in the data warehouse. But relaying we have been just relying on the data warehouse. So we didn't know, like, it is really giving us the powerful insight, or it is really giving our quality data because it could be junk or anything. So, in that case, at least this solution definitely gives us the strength with the visualization part, which gives us, "Okay, these are the different types of data it exists and data. These are the different qualities where it can improve the quality." 

The solution is robust. We can connect with quality analysis tools for summarizing the data as well. It has all the essential features.

The solution's cloud-based version has a few limitations compared to its on-premise version.

I have been using the solution for eight years.

The solution is highly stable. We never had any issues with the cloud version. I rate its scalability a ten out of ten.

The solution is highly scalable. I rate its pricing an eight or nine out of ten.

The solution's technical support team is well-skilled.

Positive

The solution's initial setup is straightforward. I rate the process a ten out of ten. It takes a little time to deploy and requires minimal staff.

Our vendor manages the solution's implementation.

Our clients evaluated Profisee and Precisely before. Comparatively, Informatica provides better integration with quality analysis, data governance, and data integration tools.

I advise others to know their company's requirements before implementing the solution. I rate it an eight out of ten.