Informatica Intelligent Data Management Cloud (IDMC) Reviews

In my company, we use Informatica Cloud Data Integration because I work in the insurance sector, where we use the tool for data migration from one environment to another. We also use Informatica Cloud Data Integration in scenarios where the clients switch from their legacy system to Informatica Cloud using Azure Synapse, because of which we have to migrate all the data to Azure Synapse.

The most valuable features of the solution are pushdown, optimization, and partitioning, which can be used for frequent data loading, especially when we have a huge data volume in our company.

While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag. I feel that Informatica is still in the process of improving its cloud. Sometimes, there are connectivity shoes in the product causing it to have multiple issues, because of which the solution hangs or lags. The product may have issues because they are new to the market and are trying to improve their services.

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

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

The solution can be easily scaled up since we just need to take the aid of some PIM processor and increase the data volume as per what we want.

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

The solution's technical support is good. I rate the technical support a seven out of ten.

Neutral

I have an experience of more than ten years with Informatica PowerCenter.

Informatica Cloud Data Integration's on-premises version is very good, considering the faster performance and efficiency it provides. Informatica Cloud Data Integration's cloud version is also getting enhanced since Informatica has been regularly doing some patching to increase the product's performance. Considering the current scenario, Informatica PowerCenter is a good product, especially its on-premises version.

The deployment doesn't take much time, and only a few minutes are needed to deploy the solution.

I rate the product's price a seven on a scale of one to ten, where one is the cheapest and ten is the most expensive. The product is a bit expensive.

In the cloud, Informatica has migrated to a different environment in a single platform named IDMC, on which one can have cloud data migration, cloud application integration, data quality, and data governance, making everything combined with a single platform. Earlier in our company, we had to rely on different software or platforms for each functionality, but now we can use a single URL and work on a single platform.

I would like to speak about Informatica Cloud Data Integration's performance, which is too slow but works overall as a tool. To those planning to use Informatica Cloud, I would say that it is the second-best product in the marketplace, and soon it will become the leading product.

On a daily basis, the product has been increasing their overall availability and performance .On a weekly basis, the product gives out some new updates while fixing its old defects. It will be a good product in the coming years. Improvements in the current product will continue for some time.

I rate the overall product a seven out of ten.

We were trying to publish a compendium of all our various assets using an Oracle-based data warehouse. We also had vendor-based solutions like Epic for electronic medical records on an SQL Server base. We had many research systems on various platforms because it's a cancer research institution. 

We wanted to pull together a comprehensive data catalog to show people all the different assets we had and where they could go to find things. If there were vendor-based definitions of things, we'd pull in the definitions and various attributes. It's a heterogeneous environment data-wise. We get a lot of value from a comprehensive enterprise catalog.

It's available on our intranet through a data governance portal. You could go there for a catalog, quality reports, etc. In a year, there may have been 500 unique visitors. It was my job to publicize it, but I didn't necessarily do a good job. I worked with research groups and clinicians to get their stuff on it, and they would tell other people about it. The nice thing about Informatica is that it was easy to link from our internal web portal to their catalog. I had excellent developers working for me. It didn't require much development, and it took less and less as time went on. 

I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar. 

The purpose of the Enterprise Data Catalog was to build an internally searchable catalog of stuff. You may not have permission to see this data but at least you could find out where it was and contact the person who owns it. 

Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms. 

It was a challenge to promote data visibility while also jumping through hoops to take some of the proprietary things and make them part of the calling, especially when the vendor doesn't necessarily support interoperability. You need to export things from a vendor program and import them again. 

We used Informatica for a lot of the data governance stuff I worked with when I joined the company, including things like cataloging and profiling data. The organization has really changed a lot in the last year and went with Informatica EDC. They're moving from the on-prem version to the cloud.

Informatica is a strong company, and EDC is a solid platform. 

The scalability is excellent. Informatica really knows what it's doing. They're smart people and great engineers. 

Informatica's customer service and support were decent. They listen to their customers. If something is missing or wasn't working, they will put it on their roadmap. They were listening to customers for roadmap stuff. 

We wound up building a staging database to pull stuff out of the EDC, stage it, and then access that. It was open, so we would often have an intermediary layer at Oracle. If we wanted to show, for example, data quality over time, we would have a weekly quality process that would run. We staged that in an Oracle database, and the portal could access that.

We had to build Informatica pipelines and do some Azure work to feed data to them. With data warehousing, you typically have static data that is timestamped daily or weekly and sometimes monthly or annually.  We were trying to get real-time data, like blood pressure monitoring and stuff like that. That was a lot of work. I didn't do it. The integration team. 

When I joined the company, it was an Oracle-based solution. Then Epic took over, which was SQL Server-based. After that, they went to Azure. Now, all the analytics are supposed to be on this platform, and it's not particularly open. 

Setting up Informatica EDC is usually pretty straightforward. The challenge is working with vendors like Oracle and Microsoft, which have APIs for integrating things. You can query what they have. They want it to play well with other vendors because they know customers don't only have one brand of product. In some cases, you get vendors in there that are, "No, we're not going to do that because we're so special." It was a challenge. The platform of choice for data initiatives at the cancer research institution is Palantir. 

We didn't look for an alternative, but Azure has its own catalog.

I rate Informatica Enterprise Data Catalog nine out of 10. It's a great solution, and I was happy with it. It did everything I wanted, and Informatica dramatically increased the integration points over time. When we started, it was like Oracle and SQL Server, but now they're adding NoSQL databases and others.

Informatica has user groups and listens to user input. One of the people that worked for me hosts an annual Informatica user group in Houston. You can try to build your own Oracle-based or SQL-based solution. They listened to the market, and they're working on improving the interoperability. Maybe it works better with Palantir since I left, but they work across all platforms. They're making it Cloud-based. I didn't know anything about them before I got here. I was dropped into a department where Informatica had been for at least five or six years, and it was a good choice.

We 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.

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. 

We use Informatica MDM to enable the master data for getting the customer's product 360.

Informatica MDM has data quality, mastering the data's capability.

Inserting the GenAI into the master data management will reduce the overall effort of operational activities.

I have been using Informatica MDM for five to six years.

Informatica MDM is quite a stable solution. I rate Informatica MDM a nine out of ten for stability.

Informatica MDM is quite a scalable solution. Most of our clients for Informatica MDM are enterprise businesses.

Usually, it takes six to eight months to deploy Informatica MDM.

Master Data Management is always only 20% implementation; the remaining 80% defines all other components. So, if users have the right process, the tool will do its job. The tool will do whatever we give input for.

Informatica MDM is quite a good product in terms of mastering all the data and ensuring that we will be able to get a 360 degree of the master data.

Overall, I rate Informatica MDM a nine out of ten.

We use Informatica Cloud Data Integration because we have multiple sources for data integration, and we transform that data and load it into the database or QuickBooks.

There are fewer than 10 people using this solution in my organization.

I'm an integrator. I'm working with the latest version. 

It's deployed on cloud.

Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier.

We would like to have accessibility to the repository. We had that feature in Informatica PowerCenter, and we were able to have access to the repository query, which helped us build some tools, audit tools, and review tools. In Informatica Cloud, accessing the repository query is a challenge.

I have used this solution for about six years.

It's very stable.

It's scalable. 

We reach out to technical support frequently. We've had good experiences with them.

We previously used PowerCenter, DataStage, and Oracle Data Integrator.

I prefer Informatica Cloud Data Integration because of the ease of connecting to various connectors and various enterprise applications. The UI is also a valuable feature.

Initial setup isn't straightforward or complex. It's about medium difficulty. 

Deployment took about one week. It's not difficult to maintain.

Deployment was done in-house.

From the usage perspective, there is minimum ROI.

The pricing is high compared to other tools on the market.

We chose Informatica Cloud because we have Salesforce. If you're using Data Integration, App Integration, and many other features like operational insights, then the price is worth it. If you're only using the solution for data integration, then the price definitely isn't worth it.

We use MDM to get more data quality. We are partners with Informatica and I'm a senior technical lead and practice architect.

The fuzzy matching capability is a great feature as is the network hierarchy which is the new concept code. 

I think the UI could be improved. We're also currently facing issues with real-time integration and if Informatica had their own it would be helpful. They need to look into the user mechanism and the security access mechanism in the data governance process. One of the major features is access control and access data management and they need to work on that because I have observed some data glitches.

I've been using this solution for six years. 

The solution is stable.  

The solution is scalable. There is room for improvement in terms of scalability with the MDM SaaS. With limited data it's fine, but with a large volume the scalability is questionable, the threshold of data transaction is different. We are a service-based company, so there are limited users within the company. From the customer side, there are multiple users. 

We sometimes have technical issues and the customer support responds in a timely manner and is quite good.

The initial setup is easy. Deployment takes around 15 minutes and we have 22 internal users in our company. 

We pay an annual license. Mobile players are unable to afford the product. Different MDMs have different pricing approaches but there needs to be room for mobile players.

We went with Informatica because we have functional and non-functional requirements with respect to the market data management of our customers and Informatica is a suitable product for their needs.

This is a good solution although it's expensive and even though we are integrated with Oracle DB2, we're unable to integrate with multiple things. The market is changing and there are many more options so we have to think about the integrations of multiple databases. 

There are some additions or improvements that could be made so I rate this solution eight out of 10. 

I use the solution for enterprise-wide data discovery and traceability, providing business context to data and collaboration between different stakeholders of data.

My organization, being a service provider, uses the product to develop domain PoCs, customer PoCs, develop data management and governance use cases, etc. The major issue with enterprises are the ability to quickly develop an MVP and showcase it to business and other data users for greater buy-in. This is important as these are new technologies - and hence, users might not easily adopt.

Our organization is a service provider as compared to an end-user. We have helped multiple organizations onboard onto data management using these technologies. 

It has improved different areas for different enterprises, including the improvement in overall business outcome and business experience, imbibing a data-driven culture, having easy availability of the right and relevant data, allowing for better compliance to regulations, and providing greater data quality and privacy management.

It has also improved overall time to service data requests such as DSAR requests.

The metadata management of Informatica is great. When an organization uses developer for data integration, IDQ for Data Quality, EDC for Data Catalog, Axon for Business Glossary, DPM for data privacy management etc., Informatica tools integrate metadata from all these tools seamlessly. The advantage is getting a complete view of your enterprise data through business and data lineage - as it not only provides you with pure data lineage but also associates related data quality measures, data protection levels, etc.

Additional metadata harvesters from different major tools can be an added advantage. Informatica provides some smart connectors for harvesting metadata from some of the industry tools. That said, this can be improved a lot more.

Overall, the toolsets are really good.

Installation and configuration can be another area where Informatica can improvise a bit. It is not easy to set up and configure the tool. A proper step by step guide to ensure this process goes smooth can be a huge advantage for end customers.

I've used the solution for more than six years.

The stability is excellent.

The scalability is excellent.

Technical support is good.

Positive

Most of our customers were using excel and email-based communication for data access. These new-age solutions improve efficiency ten times or more.

The initial setup was not very straightforward. This is an area of improvement.

We, being a service provider, have implemented and configured the setup on our own.

ROI depends on the buy-in from businesses and overall adoption rates. There is a huge amount of change management and change strategy that needs to be in place to ensure users are adopting the new tools/technology.

Informatica has good pricing options and a good professional services team who can help with setup/configuration.

There are other competing good products such as Collibra, Azure Purview, Erwin, IBM CP4D, and more. All have their strengths and weaknesses.

If you are an Informatica shop, there is no need to think twice to opt for an Informatica-based Data Management product suit.