Informatica Intelligent Data Management Cloud (IDMC) Reviews

• Integration - it provides a single code-base with all data management technologies, and handles all entity data types in all modes (for operational and analytical use)
• Model-Driven - it models an organization’s business definitions according to its own requirements and style. All metadata and business services are generated on the organization’s definitions. Informatica MDM Hub can be configured with history and lineage.
• Flexible - it implements all types of MDM styles registry. Reconciled trusted source of truth and styles can be combined within a single hub. Informatica MDM Hub also coexists with legacy hubs.
• Reporting – it has an integrated Data Stewardship User Interface Application which has been recently integrated with Jasper reports. One of the most powerful open source reporting engines which can provide on demand MIS (Management Information System) reporting

I've never been a client, but can suggest the usage across industry verticals.

• Regulatory compliance, such as financial reporting and data privacy requirements
• Avoid corporate embarrassments. For example, you can improve recall effectiveness and avoid mailing to deceased individuals.
• Cost savings by streamlining business processes, consolidating software licenses, and reducing the costs associated with data administration, application development, data cleansing, third-party data providers, and capital costs.
• Productivity improvements across the organization by reducing duplicate, inaccurate, and poor-quality data, helping to refocus resources on more strategic or higher-value activities.
• Increased revenue by improving visibility and access to accurate customer data, resulting in increased yields for marketing campaigns and better opportunities for cross-selling and up-selling to customers and prospects.
• Strategic goals, such as customer loyalty and retention, supply chain excellence, strategic sourcing and contracting, geographic expansion, and marketing effectiveness.

UI application performance was quite disappointing until v9.0.x, but with 9.5 and later versions, they have facelifted the UI. Still there are some performance improvement scopes.

I would like to see a custom service based integration of MDM Hub with the Informatica Data Director (presently JMS and SIF) and a seamless usage of Informatica 9.5+ versions with other databases such as SQL server which still has quite a few bugs.

I would like to see more ETL capabilities inside the MDM tool to be a self-sufficient in handling data extractions

I've used it for about five years, including 9.0.x (7/10), and 9.1.x (7.5/10).

No issues encountered.

Sometimes, but it depends largely on the design decisions.

Absolutely brilliant. Their on-demand support is really good speaking from a development team perspective.

Very straightforward. You just need to finalize the version based on business requirements, and I always suggest you get the latest version. And there is a Product Availability Matrix available which will guide you through the rest of the process.

The primary use case of this solution is to extract technical metadata, tag the data dictionary, and profiling. We also use it for lineage and relationship aspects.

I recommend Informatica to my clients based in the finance and banking sectors. It has been very helpful.

The most valuable feature is its ability to extract metadata from various sources- be it an old SaaS application or the latest cloud application. They have a custom resource that allows us to customize no matter which source system we have, and we can customize it to extract the technical metadata.

They are moving from on-premises to the cloud. I expect all the on-premises features in the cloud version as well.

I have been using the product since 2019.

It is a perfectly stable solution and a leader in data governance tools in the current market.

The scalability is tough. For example, if you want to increase the scalability in the middle of the project, it would be a challenging process, but it is doable. As consultants, we analyze the requirements from the client end and, based on that, suggest the infrastructure for scalability.

Customer service is a piece of cake if you are a premium member. You need to raise a ticket, and they will immediately respond. For example, they will let you know if it is a limitation; if it is a bug, they will provide you with emergency bug fixes.

Positive

The initial setup is easy. If we compare version 10.4 and version 10.5, they had a major architectural change in terms of infrastructure. The setup for version 10.5 became easier.

The deployment was straightforward, and it took 10-15 minutes to deploy the solution, including migrating technical metadata (importing and exporting).

I would recommend that rather than implementing it on a complete whole enterprise project, start with some small system or a small project first. And from there on, you can move on one step at a time.

I would rate the product an eight out of ten.

Informatica Axon is based on the needs of business people. A business analyst or salesperson would be able to make the most of its features. It is important to have three tools for a successful data governance project. These are Informatica Axon, a data catalog, and data quality. They need to be integrated, whether it is an on-premise or cloud project. The purpose of Informatica Axon is to help us manage our technical metadata and business metadata. Technical metadata is information about our source systems, such as what type of system they are, for example, Oracle, SQL, Snowflake, Cloud; and what data is being extracted from them such as table columns or source systems. Business metadata is information about our data, such as its meaning or purpose. When it comes to business metadata, we can mention that starting from the roles, responsibilities, policies, processes, and whatever the complete organization follows. We can bring all these business metadata, and we can map or tag each technical metadata and business metadata using glossaries. Informatica Axon could be a one-stop shop where we can understand the data. If we want to understand the data, we need to know where it comes from, whether this data can be trusted, whether the data quality is good, and whether this data has access to everyone or whether we are restricting the user privileges. These are the things we'll be considering when using Informatica Axon.

The best thing about Informatica Axon is that it integrates with the Electronic Data Capture and the Axon system. We have policies and processes in place to ensure that everything runs smoothly. However, it's important to work closely with the business person to ensure that all their needs are met. We need to coordinate with the business team as well because the inputs have to be communicated from both the end IT and the business team as well.

The AC integration between EDC and Informatica Axon has room for improvement for the on-premises version, but that has been taken care of with the cloud.

The stability and the integration of the solution have room for improvement.

I have been using the solution for three years.

The solution is not stable.

We can only achieve scalability on the cloud. However, if we want scalability on-premises, this can be a tricky process that takes time because we need to increase the number of code, and CPU.

The tech support team is very good. They have a brilliant team knowledgeable on whatever solution we need help with. The technical support team always tries to find a solution or workaround themselves before asking for help from others. If the solution is on the cloud, the support is quicker, but on-premises, it may get delayed because the technical support team needs to apply the emergency bug fix.

The initial setup on-premises is straightforward. Setup for EDC is a little difficult when compared to versions 10.4 and 10.5. The major architecture change in the enterprise data catalog made it easy to set up.

We only have to run the installer and follow the instructions. There is no deployment process. Whether we will have the solution in dev, UAT, and SAP. There will be only two types, non-prod, and prod. There is no manual setup. We need to do whatever we are doing in non-prod and prod as well. There is no migration with the EDC tool or data quality.

I give the solution an eight out of ten.

There are three types of users, super admin, admin, and web users. The number of total users depends upon the license. Informatica Axon provides a license based on the number of users we have.

The best data governance tool on the market is Informatica Axon. Axon EDC, Axon Data Catalog, and the data quality are the very best combination for cloud for data governance.

The primary use case of Informatica Cloud Data Management is to process data. In Informatica Cloud Data Management, you are in a portal where you can pick up the functionality you need to leverage and work with your data.

One of the most valuable features is that I don't need to buy a subscription for any functionality. With Informatica Cloud Data Management, I have all the functionality and features available. If I need to make an integration, I can go to that integration service. If I need to mask, provide, or clean some information, I can easily just pick up that feature and use it. It's very simple, and I have all the functions and capabilities I need to work with data. 

For example, you have data integration, data profiling, data quality, data governance, MGM, etc. You have an enterprise data catalog where you can build a central repository of all the audio, knowledge of technical data sets, or technical data assets from your company, as well as do semantic searches. 

One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them. 

There are some features from on-premises versions of this solution that are not yet available in the cloud version. I think this is part of the roadmap that Informatica is executing for this portfolio, so not all the functionalities are ready for the cloud version of this solution. I'm sure it's just a matter of time because I know that they will be available next year. 

This solution offers the stability and uptime you need, which you can't get in on-premises installation. Informatica has a subscription-based service that can take care of maintenance, so it's easy to maintain. 

Because this is a cloud solution, it offers elasticity and scalability. 

Informatica's technical support is great, probably one of the best. Informatica has a service where you can request maintenance through their support portal. You can create tickets for any incidents or questions. Response time depends on SLA, service level argument, and can range from one hour to four hours to three days. There are different levels of support.

This is a cloud solution, so there is no setup. You pay as you go. If we need to get some information from an on-premises environment, we implement a Secure Agent. We install the agent in a virtual machine, set up the connectors to the on-premises source, and you can work with your data on the cloud. The setup process of this company is so easy because it has four steps, and then the component is up and running. It's not complicated to implement, it's very easy. 

I implemented through an in-house team. 

You pay for this solution based on IPUs, Informatica Processing Units. This depends on how much data you process and how much memory you consume from the cloud provider, and you pay as you go. 

I rate this solution a nine out of ten. If you are considering implementing Informatica, make sure you have a clearly planned approach to the cloud solution you want. Compared to on-premises solutions, there are some different capabilities you need to leverage when working in the cloud because it's a different world. You are capable of much more. You have access to all the data center servers, so you don't have to worry about memory, processing, or storage. You don't have to worry about using all your resources as efficiently because there will always have a server you can use. 

We are using it for extraction purposes for some of our projects. We extract and test the data. 

It is very useful for testing purposes and designing mappings for small projects. If you go for IDQ in the mapping itself, you can see the data. You can then correct it, and test it so easily. 

It is working fine. It is also stable, scalable, and easy to deploy.

It can be improved in terms of performance and execution. I'm expecting better performance. It currently has some restrictions in terms of execution. For example, if we want to run it in the command mode and execute it, there are some restrictions, and we are facing some issues with a huge volume of data. These restrictions are not there in Informatica PowerCenter because we are able to execute a huge volume of data, and there are more ways to execute it. 

We have been using this solution for the past three or four years.

It is stable.

It is scalable. We have ten engineers who use it. 

We are getting better support with PowerCenter. Informatica Data Quality was developed later, and its support is not up to that level, but it is fine.

We didn't use any other solution.

Its initial setup is straightforward. We just need to create data integration services. The deployment generally takes up to three hours, but it can take longer depending on the nodes.

I did it myself.

I would recommend this solution. We have a long term license, and we plan to keep using it.

I would rate Informatica Data Quality a seven out of ten.

We use the solution for cloud-to-cloud migration so our clients have all applications and data on their Oracle solutions, and we move it from there to AWS cloud and then to Salesforce. We're an implementation partner with Informatica and I'm the senior technical architect in the company. 

The connectivity and their whole suite are valuable features. Whether we need data cleansing or data mastering, we get it all in one platform. There's no need to test different cloud vendors and then integrate with one solution. Informatica is a one-stop shop.

The one thing that I think could be improved is connectivity with the Salesforce because if you're loading a huge amount of data, whatever optimization is carried out, takes some time and it could be a little faster. 

I've been using this solution for a year. 

We had some very minor issues initially, but the product is stable. We haven't experienced any down time. 

We've just completed the first part of the implementation. In the upcoming months we plan to carry out multiple implementations and then we might see some challenges in the scalability. I think it will be fine. I have about 35 users in my team - around 40% are developers, 30% are testers and QAs and then a few are designers, data modelers, and architects.

The way we carried out our transformation was throwing some junk value as an output and that meant we had to reach out to Informatica to see what kind of configuration changes might be required. They were pretty quick to respond and knowledgeable about the issue, and dealt with it very well. 

The initial setup was very simple and took a couple of days. AWS provided everything for us. 

We initially wanted to build the programming language in Python but the client's needs made us realize that Informatica was the way to go. Our initial design was something different and it was the cost that put us off going with Informatica as a first choice. If we had worked with something like Python, it could possibly have been more scalable and the cost reduced.

If cost is not a issue then I would recommend Informatica as the tool of choice. 

I would rate this product an eight out of 10. 

To create and launch new products/services on telecom security.

It has good processes and governance.

• NPI
• Security
• Governance
• Risk management.

• By improving customer service
• Integration solutions development
• Implementation style.

We use it to take data from one source to another.

It's a subscription service. It's in Informatica's cloud, and because we have the cloud version, we are up to date in terms of its version.

We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors.

Its pricing model can be improved. The response time from technical support can also be improved.

I have been using this solution for a little over three years.

It is very stable.

It is easily scalable.

It is not great, but it is good. Sometimes, they take a lot of time to respond.

It was really easy to set up the product.

Its pricing model can be improved.

I would recommend this product. From a technical point of view, it's a great product. It's very user-friendly. It's really easy to create integrations, and it's very stable.

I would rate it a nine out of ten.