Informatica Intelligent Data Management Cloud (IDMC) Reviews

Our primary use case for this solution is managing different environments. We have some applications on our site and some applications on the cloud so we use Informatica to integrate everything.

When we use Informatica, we have a complete global vision of our clouds and the local application data and that is very important for us.

One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first. 

The program is very stable and more complex than other solutions.

When it comes to network tests, the solution is very scalable. 

The technical support is great and the team is very resourceful and helpful.

I found the initial setup rather complex and difficult. Our first project took about a month to deploy. The program is very powerful and it has many features. In order to understand everything and to know what each feature does, is rather complex. As system administrators, we used people from TCS, Tata Consultants, to help us with the deployment. We currently use two people for deployment, to create a standard blueprint, and two people for maintenance. 

We did look at another solution but it is very complex. Although it is a fast solution, it doesn't have the same level of power as Informatica.

My advice would be to maintain the program as it is very powerful. I rate this solution a seven out of ten. Not a ten because of the complexness.

We use the solution for Salesforce data integration, multi-cloud approaches and processing bottlenecks. We deploy the solution in a hybrid format.

The serverless capability and the packaging application of the solution are valuable, as all tools come with the solution and do not require additional license purchases.

Although the solution seems complete currently, it could be improved by including a buffer that saves data when there is a connectivity issue.

We have been using the solution for a year and a half and are currently using the latest version.

The solution is very stable.

The solution is scalable.

The initial setup is straightforward. It takes a couple of days, but for migration, if you have to move over the code from one tool to another, it takes a lot of time.

I rate the solution an eight out of ten. The solution is good but can be improved by a buffer that saves data when there is a connectivity issue. I recommend the solution because it has existed for a long time, and a lot of people already understand the tool. Additionally, the learning curve is effortless compared to the other tools.

Typical use cases for Informatica MDM include consent management (for a large telecom vendor in Australia), master-data consolidation and analytics for vendors, facilitating vendor onboarding, and syndicating and automating global data synchronization networks.

The configuration process is pretty lengthy and challenging and could be made easier to understand.

I've been using Informatica MDM for over ten years.

Informatica MDM is a very stable product.

Informatica MDM is highly scalable - we've set it up for a customer with over a hundred million customers, and the system worked quite well.

Informatica's technical support is great - I was amazed by the quality of their technical people and the support they provide, as well as their willingness to provide it.

Because it's on-prem, the initial setup is of medium complexity.

Informatica MDM stands out as a tool that can give you the flexibility needed for doing channel-specific data quality or business validation. I don't think any tools come near it in terms of its matching capability and the volume it can handle. Unless your budget is a constraint, it's definitely the way to go. I would give Informatica MDM a rating of nine out of ten.

Our primary use case is connecting to the AWS S3 buckets and AWS instances in the cloud, extracting data from on-premises, and pushing it to the cloud. I think that's a perfect use case for Informatica Cloud.

I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful. Very few tools outside of Informatica have the ability to do that.

I would like to see support for more data sources. At this point in time, I'm not sure if they are supporting Microsoft Azure or Google Cloud, but continually adding new data sources is one area that they can improve on.

The deployment could be somewhat simplified. One drawback is that you need a separate server for it. However, from an enterprise point of view, it is worth it because the product is good.

I have been using Information Cloud Data Integration for about one year.

I have had no trouble in terms of stability.

The scalability is quite good.

Informatica has a strong support team and they are very good.

The initial setup is complex. It isn't easy because it needs a separate server of its own.

My understanding is that Informatica is quite expensive compare to other tools that are available in the market.

I am a fan of Informatica and it is definitely a product that I recommend because of its inbuilt capabilities. At the same time, I would like to see more data sources added. Inclusion of support for Azure and Google Cloud would be a game-changer, wherein companies can move their analytics capabilities to the cloud instead of being on-premises.

If you have the money then you should implement it. Otherwise, there are many open-source tools in the market, although you will still have to invest quite a lot in terms of resources because the individual transformations still need to be built.

I would rate this solution an eight out of ten.

• Data Replication Tasks: Easy to configure, for the most part reliable, and also what my system deals with the most.
• REST API: Excellent for scripting control and reporting mechanisms

Ease of use, configurability, maintainability, and good aesthetics make for a more fluid functional process.

User/group administration could use improvement.

I have been using this solution for 15 months.

No stability issues as of yet.

The REST API could have the ability to generate tasks, and certain manual functions like updating/deleting data replication tasks could come with a bulk update option somehow.

I would give technical support a rating of 10/10. They are just incredible.

I inherited this solution in its infancy, but I don't have the details.

The setup was straightforward.

Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful.

I did not evaluate any alternative solutions.

Pose any and every question/doubt/concern to the team, especially with respect to licensing. They are excellent in their communication.

We use Data Quality for healthcare projects, and although it's not its prime purpose, we also use it to extract data. Compared to PowerCenter, it's a little easier to use — we designed the mapping ourselves. In short, we use Data Quality primarily for extraction purposes.

Within our organization, there are 10 employees using this solution.

Seeing the data in the mapping itself is really nice. We don't want to extract the data and just see the flat file. With Data Quality, we can see the data very easily.

When running a workload, we can only use the command mode. We were expecting Data Quality to offer the same type of workflow as PowerCenter.  

Although we are very satisfied with the design of the UI, executing tasks with it can be difficult.

We have been using Informatica Data Quality for three years. 

Overall, stability-wise, it's quite good; however, we think PowerCenter is more stable.

Compared to PowerCenter, Data Quality needs some improvement. When we are dealing with large amounts of data for extraction purposes, it doesn't always work out — often we experience some memory issues here and there. Scalability-wise it needs some improvement.

Although the technical support is responsive, they often take a very long time to solve our issues. They are quick to solve second and third-level requests, but when it comes to first-level requests, their solutions become very vague and general and often don't bear any fruit — otherwise, they're good.

Deployment was quite straightforward. 

We have a long-term license. I can't really speak about the licensing as I don't know much about it.

I would absolutely recommend this solution to others. If you can afford it, then go for it. If it's out of your price range, then I would recommend considering an open-source solution.

overall, on a scale from one to ten, I would give this solution a rating of eight.

We use Informatica Cloud Data Integration mainly for monthly mapping tasks. We work with it on cloud because we help customers to use the solution and to integrate it on their database and on their information systems.

The features I find most valuable is the synchronization, verification, functionalities and all the data integration features. I have been academically trained and earned the Cloud Academy badges 101 and 201. Currently, I am training to use this solution in real-time.

It's very easy to develop with the solution whenever we have an evolution for the data integration. Perhaps the web services need to improve because when you create a new data file and add some changes, we must edit it and create a web service transformation again. So, in my opinion, the functionality is bad and it needs to improve to make web service transformation better and easier.

I have developed a good relationship with the technical team and they usually assist me immediately whenever I have an issue.

On a scale from one to ten, I rate this solution an eight. I haven't seen the functionalities of this tool yet. The data quality is good but I still need to test the B2B gateway of the data quality. I would like to have profiling functionalities and quality transformations in the cloud so that I can directly integrate quality transformations inside the cloud. In the next version, I would like to have more tools for monitoring and perhaps also a system dashboard on our homepage.

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