Informatica Intelligent Data Management Cloud (IDMC) Reviews

Informatica Enterprise Data Catalog was used by our company as proof of concept for projects related to comprehensive data governance. 

The solution has multiple valuable features for metadata collection from multiple data sources or technologies. The solution manages data and acts as a central hub for setting up data governance processes. 

The automated scanning of metadata from data sources is one of the most vital features of Informatica Enterprise Data Catalog. The solution comprises attribute features and AI capabilities for automatic relationship discovery between different datasets.

Another powerful feature of Informatica Enterprise Data Catalog is data lineage. The whole path of data transformation from one location to another using certain technologies is represented in Informatica Enterprise Data Catalog. The solution integrates seamlessly with other products from the vendor and allows the creation of comprehensive data governance processes.

The aforementioned integrations facilitate the coverage of semantic layers in addition to the technical data. There is another business glossary product from Informatica that easily integrates with Informatica Enterprise Data Catalog to consume data harvested by Data Catalog, which makes a powerful combination. 

The user interface of the product needs to be improved. Informatica Enterprise Data Catalog captures huge amounts of data and along with this data, the interface becomes comprehensible only for users with advanced technical knowledge. Even for advanced users, it becomes challenging to move around vast amounts of data collected by the solution. 

Some competitors of Informatica are trying to implement some brilliant ideas, but they lack the coverage provided by Informatica Enterprise Data Catalog. The data lineage feature can also be further improved.

While using the solution, the data is being transmitted outside the client's network to the Informatica cloud, which can be a security concern; the vendor can solve this by enabling the product as part of a public cloud like Azure, AWS, or Google. The aforementioned scenario can be a concern for institutions like banks where there are legal restrictions and data needs to be fully under control. 

I have been using Informatica Enterprise Data Catalog for a year. It was used in two different projects in our company, each of them concluded in six months. 

I would rate the stability of the product as seven out of ten. 

The customer support is satisfying, but the turnaround or response time is quite long as the vendor needs to support a huge number of customers daily. At our company, we have noticed that there are experts in the support team who can provide effective solutions. 

The tool's initial setup is complex. I had experience with the on-prem deployment of Informatica Enterprise Data Catalog, but I believe the cloud version is easier to set up. The solution's deployment takes around three to six months.

About four to five professionals are required, including technical administrators and data governance experts, for the on-prem deployment of the solution; for cloud deployment, three professionals might be enough. 

It's a very expensive solution. 

Informatica covers the widest area of technologies in comparison to other vendors and they also have a network of partners who develop add-ons for extending functionalities or data source technologies which could be integrated with Informatica Enterprise Data Catalog. The solution provider has a wide partner ecosystem to provide features on APIs and special custom formats that could be imported or integrated into varying processes. 

The solution's features can be extended and the vendor provides useful documentation and training on it. Informatica Enterprise Data Catalog is a reliable platform due to its extensibility and cooperation with other partners. I would overall rate the product an eight out of ten. I would definitely recommend others to use the solution, given that there isn't a requirement for in-depth analysis. 

The critical data lineage feature acts as a link between every aspect of data governance, including an explanation of the data journey and its history which reflects the business growth. The powerful AI capabilities of the solution allow you to automate the management of massive amounts of data, especially the aspect of associating technical metadata with business terms.

When dealing with millions of data attributes its not possible to manage data manually, therefore Informatica Enterprise Data Catalog is needed to automate 60 to 80 percent of data association between business terms and harvested technical terms.

If the Informatica Enterprise Data Catalog deployment is carried out efficiently, it can greatly impact your organization and enable business capabilities to further improve business processes. 

The main purpose of this tool is for file transfers related to our Python server.

The data integration and synchronization features in IICS improve the data handling processes.

I haven't had the chance to explore all the features in-depth since we've only been using them for a couple of months.  

I appreciate that it's a cloud-based solution. With a good internet connection, it works smoothly.

It also offers multiple features. 

There's definitely room for improvement in terms of user-friendliness.

One example is that you can't search for jobs directly by file name. You can only search by job name. So, if you want to find a job that works with a specific file, you have to go through each job individually to find the right one.

So, I'd like to see a faster search, one where I can search directly by file name.

Moreover, the support team could improve by adding things like file transfer status updates. Also, if someone modifies a job and then leaves the company, that shouldn't disrupt the job for active users. It would be better if the job continued to run smoothly regardless of who modified it.

I have been using it for seven to eight months. 

It is a pretty stable product. 

Scaling is easy. It's not overly complex. In our team, we have around 10 to 12 people using it. Additionally, there's a separate IT team dedicated to IICS with over 50 people. Other private projects likely use IICS as well.

We sometimes face challenges when implementing new features. In those cases, we contacted support, and they've been very helpful.

wWe're happy with the support team.

It is a cloud service. We use AWS and Azure Cloud. I'm not fully sure about the installation details, but I know we use AWS and potentially other cloud features as well.

If you have experience with similar tools or a general understanding of IT concepts, it's easier to grasp. Learning the features takes time, but with an IT background, you should be able to figure out the basics. 

We all encounter challenges sometimes and need to learn new things. Overall, it's not overly difficult or overly simple. It's manageable if you have the right mindset.

It's definitely a good tool, especially if you're using cloud services and an S3 bucket. It has many features to simplify your work and make your life easy. It's not overly difficult to learn, but proper training is essential to understand and make the most of all the features.

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

It is used for our SharePoint data, and it is used for our financial data, so we prepare some kind of data lakes about data. And for a lot of financial things. For example, when somebody has to put the user, like, what we have in your organization. You have a user, and some joint venture partners are there. So, we use it for multiple financial master data. Basically, financial master data, we use it.

We are basically partners, IT partners because a lot of data is being used in multiple applications for Informatica. So, basically, we have partners. It's like Shell. So, it's an end user, but as well as a partner.

It's helpful in integration, and it can be moved around in SharePoint.  So, from the SharePoint View, data integration and reporting, it help a lot in that way.

The speed with which the data should be moved could be improved because of the firewall. It's becoming quite slow. And the integration with Teams or with Microsoft is not so smooth. So these are the areas of improvement. 

So, probably, they might even look for some upgrades or some changes over there. But these are the two key areas that we are facing issues with. One is the data moves a bit slow, and the integration within Microsoft products.

Maintenance is another issue that takes a lot of time and money. It can be a challenge in the long term.

I have been using this solution for six to seven years. 

It is stable, I would rate the stability a nine out of ten. 

I would rate the scalability a seven out of ten. Because of the maintenance issue, we want to scale it up, but we're not able to do so because of the maintenance issue and delayed response.

It breaks down quite often, and it takes time and money to get the issue fixed. These are challenges that need to be addressed from a global perspective, not just from my process.

The support from IBM might not be good, or the IBM people might have to contact Informatica for the solution. That could be a reason. But the resolution takes longer than expected.

There is room for improvement in the support. The response time could be faster. 

Neutral

It is easy to install because our laptops come pre-configured. There were no issues. However, it is not easy to maintain. 

We have a team that IBM handles for maintenance work. If there are issues, we raise a ticket, and they get sorted out, but it takes too long. It is not quick enough. The resolution takes more time than expected. 

We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics. This aligns with our company's initiative to implement a data lake strategy and drive digital transformation.

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

On one of my projects, we used Informatica Intelligent Cloud Services for ingestion purposes. Secondly, we used it as a regular ETL for performing heavy transformations.

In our current scenario, we are moving our on-premise artifacts, which are on PowerCenter, to the cloud. It was surprisingly quick to get everything working, which has been beneficial for our operations.

Informatica Intelligent Cloud Services offers a wide variety of services, including Cloud Data Integration, which is akin to a replica of PowerCenter on the cloud. I particularly like the mass ingestion service.

The cloud version of Informatica, although easier and more advanced than PowerCenter, still requires a deep dive to fix bugs. It could be improved by making the process as intuitive and easy to follow as PowerCenter.

I have delivered two projects using it, so from my experience, the tool is very good.

There are some bugs and glitches, which for a beginner, can take time to resolve. This may be because I have spent less time on the tool compared to others.

Scalability doesn't impact Informatica technically, but it does take a lot of money when we keep adding users.

Informatica technical support is excellent. I would rate it a nine. They are top-notch.

Positive

The initial setup is easy and not complex.

Pricing is a bit high, similar to a premium version or a high-end product, and requires a budget ready to manage it.

During POCs, we explored other ETLs like Firetran for ingestion purposes, but Informatica's capabilities are robust.

For a robust use case, especially for large enterprises, Informatica Intelligent Cloud Services is a good tool with good support. However, make sure to have a budget ready.

I would rate it an eight out of ten.

What I like best about Informatica MDM is its structured, table-based approach. Unlike Reltio, where data is only visible through the UI and cloud-based, the solution allows access to normalized tables. This means I can directly query and see data in each table. For instance, I can easily get all customer details from the customer table. However, for more complex queries, like seeing all customer interactions with the organization, some SQL knowledge is needed to join different tables and retrieve the details.

The tool could be improved in terms of ease of use, particularly for those without technical expertise. Understanding and extracting data from the table-based structure requires some SQL knowledge and technical skills. Additionally, while Informatica MDM has moved towards a cloud-based MDM with a UI similar to Reltio, I haven't used it, so I can't comment on its effectiveness.

I have been working with the product for six months. 

I haven't had any issues with the tool's stability. 

I'm not entirely sure about scalability, but I've heard that adding custom features can be complicated. We have to go through several steps. First, we need to determine if we're adding a column to an existing Informatica MDM table or creating a new one. Then, we have to contact Informatica with our customization request. They do the customization. After that, we have to check if it's working correctly.

In our organization, we use Informatica MDM in a specific way. It's primarily based on tables; users don't directly log into it. The process works like this: data flows into the MDM tables as an inbound process. Once the master data merge has been completed, the output data flows out as an outbound process.

The tool's support team is good. The product is quite technical, and so is the support team. When we have questions, we reach out to them, and they provide answers. Their response time is also good—we don't have to wait long for replies.

Positive

I rate the overall product a seven out of ten. If you don't have the budget for Reltio, then you can go for Informatica MDM. 

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.

The solution helps with cataloging and obtaining the data lineage. Informatica Enterprise Data Catalog also helps in identifying vital datasets, including the critical data elements and cataloging them. In our company, we have to manage the life cycle of the critical data elements and maintain the business glossary.

The definitions of the critical data elements, their linkage, lineage, as well as the relationships are managed using the solution. Informatica has been in the industry for decades, so they are one of the top SMB partners. 

At our company, along with the solution, we also use Informatica Intelligent Cloud Services REST API for app and system integrations in the packaging industry. Of our total portfolio, we integrated applications for about 20%, but we did not have any cloud presence; only a setup application was in the cloud. But for all the on-prem projects, the key components of the customer's product were integrated and governed by using Informatica. 

Data lineage is a valuable feature when, at our company, we design the physical elements and the logical components and need to identify the relation between them. 

The duplicate identification feature for two tickets, synonymous fields, or attributes is another vital aspect of Informatica Enterprise Data Catalog. The categorization of whether data is critical or not in the business glossary is another vital feature of the tool.  

The product is difficult for an untrained professional to operate. Specialized skills need to be acquired by learning the tool and executing it for data operations. Informatica Enterprise Data Catalog needs to be more user friendly, the UI is extremely complex.

For instance, if I have to view the tool, the first deterrent is that it gets highly technical. Thus, a limited number of professionals can understand the tool processes. Unless you are a data professional, it's very difficult to use Informatica Enterprise Data Catalog. The tool operates with Power BI sometimes.  

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

At our company, we haven't faced any downtime or business issues with the solution. The solution allows a limited number of users, so it's easier for the vendor to manage stability. 

I believe the solution is scalable and integrates satisfactorily. Our company was successful with scalability because, for the majority of our applications, where the key data was being hosted, we could integrate the apps quite easily with the cloud.

If Informatica Enterprise Data Catalog is being used, scaling the data up or down shouldn't be a problem. The solution's cloud integrations make scalability easier, unlike the on-prem version, which requires implementing complex security protocols. 

I would rate the customer support a nine out of ten. The product's support team has been highly responsive while solving the issues faced by our organization. 

Positive

At our company, during the product deployment, we had to asses our applications and APIs that would be connected, whether they were available out of the box or not. But the capabilities of customer connections are available with similar tools.

Informatica Enterprise Data Catalog offers custom connectivity. Therefore, the deployment process has been troublesome for our organization except for the mainframe. But as we kept using the tool we realized the integrations could be smoothly completed. At our company, we implement the product if customers are convinced to integrate the tool and make it their central, single source of data management for integrators and technicians. 

The deployment of the solution took more than a year in our organization, which included upgrades, contract renewals, and demonstrations similar to IDMC, provided by the same vendor. For deploying the on-prem version of Informatica Enterprise Data Catalog, a team of five engineers was needed in our company to manage the whole deployment and support process.

A couple of business analysts are needed to gather the users' requirements. Our organization has about ten members who provide on-call support on Informatica for its customers, comprising developers, business analysts, and testers. 

In our organization, we were able to derive about 70% of the critical data lineage. 

It's a costly solution. I would rate the pricing of Informatica Enterprise Data Catalog as six out of ten. 

The automated data lineage feature utilization depends upon the integration, which is why, in our organization, we had all our key applications integrated that derived automated lineages. But there were unknown applications as well, which, due to the lack of integrations, needed to be manually plugged in.

The mainframe integration with Informatica Enterprise Data Catalog is highly complex. At our organization, due to the aforementioned complexity, we had to import all the data of the mainframe into Informatica. If you are able to integrate the tool with your core applications and systems, then the data lineage duration is pretty simple and this structure is the same for competitor tools as well. 

In our company, we might explore in the near future how Informatica Enterprise Data Catalog can assist with AI capabilities. I would overall rate the solution as eight out of ten. To anyone looking to use Informatica Enterprise Data Catalog, I would say if they are willing to understand the company data, then the professional should gather sufficient technical knowledge about the product or take assistance from an Informatica expert because it's not a straightforward tool. 

We use the tool to implement customer, product, and entity masters. We also use TDM to generate synthetic data, but not in real-time scenarios.

It's a multi-domain master data management system. The solution is easier to use compared to the other solutions. The security is good. The governance model is good. All the elements that I expect are available in the product.

The user interface can be a bit more functionality-aligned.

I have been using the solution for the last 15 years.

I rate the stability a nine out of ten.

The product is scalable.

The support team does not provide much support.

Negative

The initial setup was okay. I rate the ease of setup a five out of ten. The tool can be deployed in a minimum of eight to ten months. The implementation requires at least a team of five members. Maintenance depends on the customer's requirements. If the customer's requirements keep changing, we need a team to maintain the tool. Otherwise, one or two Informatica developers are sufficient to maintain the product.

The price is comparable.

All the tools have similar capabilities. There is nothing superior in Informatica. I'm a software integrator. I work for an IT company. I'm not the consumer. I will recommend the product to others, but it depends on the customers’ needs.

If an organization needs a good customer master, product master, or partner master, Informatica MDM will be a good choice. The solution has been in the industry for quite a long time. It has all the elements I look for in a master data management system except for customer support. All other things are fine.

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

We had proof of concepts where certain test cases were given to improve the functionality of the vendor regarding the supply chain.

So, it was a proof of concept. It was not applied in production.

It was just illustrating the capabilities of the platform, and we were comparing it with other platforms.

If we use it comprehensively, we can improve the data quality metrics or KPIs. 

So use as much data as you process, and have a solid strategy in place. If you don't have a comprehensive approach, then you don't draw any benefits or value from such a complicated platform. So, you have to have the objectives very well set up and be part of your daily activities in order to benefit from such a platform.

I like the connectivity and richness of features for the technical team, the maturity of the product, and that it had a cloud version. There is Informatica Cloud, and it is part of the Informatica Cloud platform.

It also has integration with other data governance tools from Infromatic, which is also good. 

It offers integration with some of the latest data platforms, streaming platforms like Kafka, for example. And the setup of the platform is very challenging.

Regarding the cloud, it is deployed in the private cloud of the vendor, so it poses challenges regarding the security of the data and the confidentiality of the data. There was no offering of a cloud version deployable in the client's tenant where all the data would reside.

I used it for a couple of months because it was only demoed for the client.

It is a stable product. 

The customer servive and support could be faster. There is a slow turnaround. 

Neutral

We just compared the data profiling features or data quality features between the tools. There was a rich functionality available in the system, but we did not draw any conclusions regarding how it improved or may have improved.

It was set up by the vendor for the demo. To deploy the Informatica Enterprise Data Catalog, you need at least two admins and architects. 

It enables business processes by providing trusted data that can be integrated into many processes around data.

It's very expensive. It's subscription-based. There are several levels of subscription.

The price is high, but the competitors are even higher and more experienced, like Collibra.

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

I would recommend it due to the consistency of vision and very good integration between different products of Informatica. It offers wide coverage, the widest coverage of technologies from the major players.

We use the product to store data. We have established a structured system where we store all relevant information, including donor details, images, and series, ensuring easy accessibility for users.

The product's most valuable feature is the ability to select the data flow and lineage.

Informatica Axon's response times and certain aspects of the admin panel could be enhanced for better usability.

We have been using Informatica Axon for more than one year.

I rate the platform's stability as seven out of ten.

We have around 400 Informatica Axon users in our organization. I rate the scalability a nine out of ten.

The technical support services at the moment are impeccable. The support team has answers for everything. They have maintained this level of quality as we progress. There aren't many issues currently, although we're awaiting the migration to the cloud.

Positive

The implementation process could be simplified.

The platform has a premium cost. I rate the pricing as seven out of ten.

The product needs to be adequately supported in the current setup. I advise others to conduct a proof of concept (POC) and assess how it progresses. The learning curve can be steep, but with sufficient time investment, they can also impart knowledge to the users, which is crucial for effective change management.

I recommend it to others and rate it an eight out of ten.