Informatica Intelligent Data Management Cloud (IDMC) Reviews

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. 

We used the solution for data storage, and data cleaning to improve data quality. The solution also served as a data lake for reporting purposes.

The solution has made it easier for us to retrieve and maintain the data as well as saves us time.

The ability to clean out data and improve the data quality is the best feature.

The solution is user-friendly and easy to navigate.

The cost of Informatica MDM is expensive and has room for improvement. Although the solution is good, it is not worth the high cost.

I have been using the solution for five months.

I give the stability a ten out of ten.

I give the scalability a ten out of ten.

We had ten people using the solution in our organization.

We previously used EXAScaler and switched because we were moving to the cloud.

I give the initial setup a nine out of ten. The deployment took us one month. We prepared the environment and the deployment was completed by the Informatica engineer.

The implementation was completed by an Informatica engineer.

The solution is very expensive. I give the cost a three out of ten.

I give the solution an eight out of ten.

The solution is good and I recommend it as long as the pricing fits the organization's budget.

We use the solution for ETL.

It's a powerful tool to create data warehouse solutions for our clients. We take unstructured data and use Informatica Cloud to structure it in various ways, making it usable on a reporting front end. This enables clients to make informed business decisions based on the data.

It's the accessibility and the range of features that stand out. Before using Informatica Cloud, we were working with Informatica PowerCenter. The transition from PowerCenter to Cloud wasn't entirely effortless, but it was seamless enough for our developers to adapt and continue their work smoothly.

Our main issue is transitioning from on-premise to cloud data storage. As many clients move their data to cloud platforms like Azure, Snowflake, and AWS, we're encountering problems with Informatica. Errors that were straightforward and clear with on-premise databases now appear ambiguous in cloud environments. Our developers spend significant time reducing these generic errors, often simple issues like a column not accepting null values. This lack of clarity is causing unnecessary delays as they have to sift through logs or contact support to diagnose problems that would have been more easily identified in an on-premise setup.

I have been using Informatica Cloud Data Integration as a financial partner for over five years.

We have about seven developers. It is a scalable solution.

When errors arise, contacting support can be frustrating. Sometimes, the technician can't solve the issue and transfers us to someone else. This makes us less confident that the person helping us is truly equipped to resolve the problem.

Neutral

The initial setup is simple and depends on the task. However, it usually takes a couple of hours if development is complete and we're moving from the development environment to production.

ROI is strong because we have a structured portal that ensures development is done correctly. It is shareable, scalable, and equipped with enough monitoring tools to quickly address any issues. Ultimately, the client doesn't care what tools we use. They just want problems resolved quickly. Informatica provides the necessary tools and features to help us do that effectively.

It has premium pricing. Depending on what we're working on and which features we're using within Informatica, there can be additional costs. It's mostly data integration, but you might need to upgrade your license to include other aspects of Informatica. Certain connectors require a license upgrade to access.

Overall, I rate the solution an eight 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 export APIs, and anyone can seek those APIs to have the data for target use cases. We hit the APIs that are exposed by external systems, and we get the data from them and process it.

We're using the latest version. It's deployed on cloud.

There are about five people who are using this solution in my organization.

We chose Cloud API Integration to connect to Salesforce.

The OAuth feature is the most valuable for authentication.

Recently, we're trying to connect to the Amazon API. There's no direct way to connect to Amazon APIs from Informatica Cloud. From Postman, there's a signature site called AWS Signature, which would actually generate the signatures for us with AWS APIs. In Informatica Cloud, we have to build the logic, and then we can generate the signature and hit the AWS APIs. Instead of generating that signature, it would be better if we could have the same connector in Informatica Cloud.

Sometimes when I open the processes or any service connectors, the labels are not properly displayed. The backend names are displayed rather than the front end label. I usually log out and log back in, and sometimes it disappears, and sometimes it doesn't.

I have used this solution for six years.

It's pretty stable. We don't have any concerns.

It's scalable.

I would rate technical support as six out of ten.

Setup is straightforward. It takes a week to do the installation and configuration.

It's not difficult to maintain.

I would rate this solution as eight out of ten. 

I would recommend this tool to other users.

We use Informatica as our one-stop cloud integration solution. We are connecting two different data systems like SAP or Salesforce, integrating on-site financial data with some applications that process financial information like an ERP to plan budgets and forecast revenue. I'm creating a data warehouse and using that with tools like Power BI to create reports and dashboards.

Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API.  The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables. 

There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another. 

I have worked with Informatica products for about seven or eight years.

I rate Cloud Data Integration seven out of 10 for stability. Even though Informatica is based in the cloud, it still depends on a secure agent deployed on-prem. The performance of the individual machine where you install the gateway can affect the stability. 

I rate Cloud Data Integration eight out of 10 for scalability. 

I rate Informatica support eight out of 10. They have a dedicated customer success portal where you can search a lot of knowledge base articles that tell you how to use Informatica in various scenarios. You can also use the portal to raise a support ticket describing your scenario, what you hope to achieve, and where you're having problems. The technical support responsiveness and dedicated customer support are decent enough. 

Positive

I have some experience with Azure Data Factory, and I worked with another Informatica product called PowerCenter. I switched to Informatica Cloud Data Integration because my customers' needs changed. More companies began prioritizing clouds. As developers, we also needed to scale up our services.

I'm not aware of the exact licensing cost because the senior management handles that, but I know that products like Azure Data Factory are less expensive than Informatica. At the same time, Informatica gives you more options and connectors. Everything is possible, whether you want to do API-based integration, traditional data integration, etc. 

Azure Data Factory is more useful for connecting with the Azure cloud. You can also play around with the native data integration tools that other cloud providers offer, like GCP or AWS.

I rate Informatica Cloud Data Integration eight out of 10. I recommend Informatica as an integration tool for large and medium-sized enterprises migrating to the cloud. Cost is something to keep in mind because Informatica might be too pricey for smaller companies. Large and medium-sized companies can easily afford it if they plan to use it as a one-stop solution for all their cloud integration and management needs.

If you need a middle layer to build your pipeline, that can be achieved using Azure Data Factory or any other data integration tool. Still, Informatica has some advantages in terms of connectors and help desk resources. When you contact the Informatica help desk, you can speak with engineers who helped develop the Informatica platform, so they have rich experience with integration technologies. The product itself is highly reliable and suitable for your integration needs. 

Azure Data Factory has almost 80 percent of the same features, and it might work for you if you have a Microsoft ecosystem. Using Data Factory is cheaper. However, if you're a large or medium-sized organization or a reseller and your data is more valuable, it might make more sense to use Informatica at that scale. You'll be interacting with many more types of applications and might need to integrate the applications in various ways.

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. 

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.