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