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.

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.

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.

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.

We have used it to elaborate on a project for Golden Record, for IDQ data quality, and create business cases for the control parties.

The product could be improved in the area of architecture and technology. All the parts are old.

I would like to migrate it to a new technology. It's better to have a new method for every IT system. Integrate with API, Kafka, and JMS, as API has in Jira code or Jira.

I have used Informatica MDM for ten years. I have used Version 8.6 and 9.1 of this solution.

I think that it's a good solution, but it's an old solution. It is stable because we have the experience to deploy this solution.

I think it's based on ODBC drivers, and they are not good for scalability.

We have not contacted customer service.

The initial setup was complex. It must have taken around eight or nine months to deploy all Informatica systems. The deployment processes for on-premise and cloud are different. For on-premise, we must deploy the data models, and then we must deploy the rules. We must also deploy a .Go file extension and an exposition of the vendor code, among other things.

It's different if we have an on-premise solution. The stability is for the on-premise infrastructure. It builds the IT of enterprises of clients because Informatica is at 'Legacy' level.

So, there are plans for licensing. There are subscription-based and usage-based licenses. Also, there are licenses for exceptional analytics, etc. In short, there are different models of licensing for every enterprise.

I think there is a new Jira-driven event, Jira-driven data, for the flows and extensions. So in this power center technology, I think that it's complex to navigate through the solution without new technology. Overall, I rate the solution a seven out of ten.

We use Axon for controlled and governed data sharing as well as for the policies and principles from a data governance perspective. Our use case was for an airport company and we used Axon in tandem with Datacat Log EDC. We customize data search and data sharing. We have a partnership with Informatica. 

The management of the policy is very useful. The ability to customize data search and data sharing is useful. The solution has all the necessary features. 

The GUI needs to be a little more user-friendly and appealing. Salesforce, for example, although in a different category, is very user-friendly and I think if they were to include some of the Salesforce principles, it would be helpful. Informatica needs to do a better job in terms of educating users. 

I've been using this solution for three years. 

The solution is stable and dependable as long as we keep an eye on the servers. 

The solution is scalable. 

The support process needs to be more agile. 

The initial setup took a few days. It wasn't very complex but there were some initial challenges because we were trying to setup the Informatica Data catalog, EDC, at the same time. The deployment was reasonable but not very smooth. We have around 300 users.

Licensing costs are generally on the higher side.

Collibra was a solution we evaluated but Informatica was the final choice.

I rate this solution seven out of 10.

We primarily use the solution for data integration as well as application integration.

Currently, we have a multiple-source system. With Oracle ERP, it's very hard to pull data from Oracle ERP, since it's API based. Therefore we have to make use of Informatica Application Integration to pull data from Oracle ERP.

We are pulling our supplier information, customer data, and data for projects related to information.

It's a beautiful tool. It eliminates the use of a third party or some other tool as it provides beautiful functionality.

In an earlier version, when we are working with an on-premise tool, it was hard since we had to concentrate on the configuration, et cetera. However, now, when we are working with the cloud, most of the time it's very easy to handle.

Data integration happens seamlessly and is pretty fast.

The application integration will give you more flexibility when dealing with APIs.

Every week, we seem to get notifications of new features and updates. They are always trying to improve the product. 

When we're dealing with huge amounts of data, we need to reach out to Informatica. There are some kinds of API records that we need to modify configurations for. 

Application integration, as compared to data, is a bit slow, and it can't handle millions of records.

There could be a lot more application integration. Like data integration, we find there are a lot of places where we can go ahead and improve performance. When it comes to application integration as a developer, we don't have that much flexibility. We have constraints. Our hands are tied, and we can't do anything. We need to speak with either the target system or the core system and say, "Okay, do this thing." 

I've been working with the solution for more than two years. 

It is a stable, reliable product. Sometimes there is a bug or a cache issue. We might get an error when connecting and when that happens, we reach out to support. We find it's a pretty common issue. It might be a glitch. 

It is very scalable. We have some challenges around application integration, and that requires speaking with support. We tell them we need to change a configuration to a specific size. They can assist us when that happens. That's only for application integration, not data integration. With the cloud, we can easily handle millions of records of data.

A variety of people use the solution in our company. There are 50 to 500 users, approximately. 

Technical support seems to take their time in responding. We'd like a faster reaction time. Sometimes it takes one to two days to get a response.

Positive

We did not previously use a different solution. Currently, we're working with data and application integration with Informatica only.

We've mostly dealt with on-premises deployments. As a developer, most of the time, we face a lot of challenges, which are overcome when it comes to Informatica Cloud. Informatica Cloud is much more convenient, as well as fast, and gives good performance as well. With the cloud, we don't have to install software and there aren't any dependencies. It's much more convenient and easy with Informatica Cloud.

The deployment hardly takes more than a few minutes. 

When it comes to the cloud, there is no maintenance necessary. Informatica takes care of any support tasks. They do the updating, et cetera, as well. 

We handled the initial setup in-house. There were no third parties involved in the deployment process. 

We have not looked at ROI.

The solution is subscription-based. Users are charged based on how many resources are used.

The pricing is pretty good. I'd rate it 8.5 to nine out of ten. 

We did not evaluate any other solutions previously. Our client already had this as a pre-existing tool and did not want to switch. 

I'm working with the latest version of the solution. 

Informatica is a stable, easy tool. New users should go and explore it. There is improvement required in Informatica Application Integration; not the cloud.

I'd rate the solution eight out of ten. We're quite happy with the product. 

The client has integrated all their internal systems and external systems using Informatica Cloud Data Integration, including all transactional information for different systems, such as SAP ECC or SAP HANA as a business intelligence suite. The solution is used to exchange data between the invoices in Italy and USA, and to exchange information about materials using all sectors around the world. We use the solution to establish a connection between different systems. For example, to generate payments for different companies such as human services, data warehouses, and external companies.

The solution is straightforward. We can build on a process the first time and implement it. In one single view, it's possible to understand, make the connections, define the strategies, monitor the process, and verify performance.

The solution is a unique platform that makes high-velocity development possible, independently from the connection. The connection is fantastic because the solution has connectors for all types of external systems, SAP, Salesforce, and different databases working on the cloud or on-premises.

We can implement Data Integration with Data Quality in the same platform, using just one license to implement. It's not necessary to install different types of platforms or features and the solution is user-friendly.

The solution has great integration with metadata management.

The main issue preventing Brazilian companies from migrating to Informatica Cloud Data Integration from on-prem is the price. The license is now based on subscriptions, which is a change from the past. This has caused Brazilian customers to hesitate, wondering if they should migrate or not. The technology is fantastic, but the price is terrible for the customers. They are forced to migrate because the platform is a must in terms of technology. However, the price is too high causing a big problem here in Brazil.

I have been using the solution since 2019.

I give the stability a ten out of ten.

It is very easy to scale the Informatica platform. I have never seen another platform that is so easy to implement. For example, my organization in Brazil uses the Informatica platform to integrate some systems with its data warehouse. In parallel, IBM developed their own solution, which we developed in parallel with their technology and implementation velocity. IBM is confusing to configure and slow to implement. With Informatica, it is easy to configure and fast to implement. There is no wasted time with the particularities involved for each solution. 

I give the solution a ten out of ten for scalability.

The technical support is very good. Not only in terms of the support team, because all Informatica documentation is very simple to understand. The components, the problems, and the directives to implement are all easy to understand. The support team as well as the documentation are great. The level of support is unbelievable.

Positive

The initial setup is straightforward and I give it a ten out of ten for ease.

The price is very high and has become a big concern for our customers who require the solution in order for their business to function smoothly. The cost to migrate to Informatica Cloud Data Integration from on-prem is too high for a lot of our customers that have already put a significant amount of equity into the on-prem version.

I give the solution a ten out of ten.

As a partner, I'm very comfortable with the level of implementation and the technology involved independently of the price but for our customers whose primary concern is cost, the price of the solution is very high.

The comfort and simplicity of the products are unbelievable. The ability to implement, operate, and develop is very easy. We reduce the time and know-how required for developers to implement Informatica Cloud Data Integration because of the easy deployment.