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.

The solution is typically a bridge between business and IT. You use Axion as a tool for governance within the organization. The business people could use this tool to understand what information is being entered by IT. For example, if I'm an IT guy and if I'm using something called a column name or a table name which could be pretty technical out there, I just say, for example, BT_DT. I understand what BT_DT is, which, in this case, is birth date. That's the table name. However, the business side wouldn't really understand this. Therefore, I could actually tag BT_DT as birth date in Axon and I could relate it to this particular column and then the business side can use it from there. 

Apart from that, you could define your data governance policies, your workflows, who's going to approve the data, who's going to use the data, and who should be consuming it. It can assure that data shouldn't get out of certain boundaries. 

What I like about Axon is that typically, with all tools, you will find that there are certain limitations when it comes to the user level. However, with Axon, the limitations are not there. You could have certain people getting into Axon and things like reading, writing, or editing the policies. However, apart from those people, everyone else in the organization can still view it, so it's not restricted. There are certain people who could just edit the tool or administer the tool. That said, everyone in the organization can view what is actually happening and what they could benefit from it. That's how collaborative data governance comes into the picture with Axon. 

It has got nice integrated quality dashboards as well. 

It has the BPMN enabled or BPMN compliant workflows embedded inside it, which is great.

The solution is stable.

It doesn't need too much memory. It's being used by the business as well as the IT guys in tandem. There is something called a Marketplace that is also available. Now, when you publish something, it's is available for all the consumers out there to use within the organization. 

If I wanted to improve something, it would be the way we import or the way we design the policies. Right now, although they offer some templates, I would want more templates available to be imported.

I've been using the solution for two years or so.

The solution is very stable. there are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

When you talk about scalability, this is not a very, very heavy tool. It is a tool that is typically going to fetch all the data and everything from the governance perspective. It's not actually a memory-hogging application as such.

In my previous company, there were about 100 uses on the solution.

With Informatica technical support has never been a problem. They are fantastic. If you reach out to them and raise a case, they get onto it very quickly.

We previously used an in-house solution. We did not use a different third-party solution.

The installation is okay if you follow the steps that they have provided in the guide. If a new user does that, that should be fine, however, you need a dedicated person to do that. You cannot just click through. There are various components to it. You need a specialist to do that. That said, the guides are pretty comprehensive. If you follow those, that should be fine.

In our environment, the setup was done within a day's time or a few hours - maybe four to five hours.

You need knowledge of the underlying components, such as Linux, or your big data environment, et cetera. That's where specialists can be brought in. It's recommended you take advantage of them if you can.

The license is a yearly one that can be renewed for a consecutive year. You can actually go with a three-year license as well, which will give you a better discount.

While our deployment is on-premise, you can deploy it on any cloud of your choice.

I'd rate the solution at an eight out of ten.

I would recommend the solution to other users and organizations.

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.