Informatica Intelligent Data Management Cloud (IDMC) Reviews

Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors.

The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions.

I have been using this solution for roughly three or four years, but overall, I have around 12 or 13 years of experience in data integration. It is a cloud solution, and it is managed by Informatica. We are always on its latest version.

It has been stable for us. I haven't seen any issues. They provide the upgrades and patches in a timely manner. We don't even realize that the patch has been applied. 

This is not a traditional cloud like AWS and Azure, which offer virtual machines, data storage, and compute power. With Informatica cloud, this is not the offering. You need to understand the offering. They are offering a data integration service. The scalability context here would be from the services aspect. If you want to have more data integration, you can do it instantly the way you want. You will be charged if it is beyond your subscription. They also have data quality and all the data management tools.

Its initial setup is pretty straightforward and not at all time-consuming. They just offer one simple software that communicates on your local system. You have to enter the org IDs, etc. It also doesn't require a lot of hardware.

I would definitely recommend this solution. It is definitely worth a try, and you will definitely benefit from it and see the value of implementing it in your organization. They are a leader in the Gartner Quadrants. The offerings that these guys are giving with the new licensing model, such as IPUs consumption, are excellent. You don't need to worry about what do you want to purchase. You just need to worry about the number of IPUs that you need to purchase. You can shuffle around all types of services under the same umbrella.

I would rate Informatica Cloud Data Integration an eight out of ten. It loses two points because of the region limitations.

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.

The features that I have found most valuable are, first of all, that it comes as part of this whole bundle of Informatica tools. So if you've been implementing Informatica MDM across a business, you'd often find it comes with it. It's been thrown in as a sweetener. The adoption of it is often the challenge because as part of your MDM project, governance is seen as something beyond the MDM and is often restrictive. So this tool actually, for the first time, when you talk to data governance teams, gives a holistic view of what a data governance team can do with this tool.

Collecting a knowledge repository, creating a business glossary and visualizing the data lineage are quite fundamental as part of your data governance team's work. Once they see it in Axon, it becomes relatively easy for them to visualize what they have to do. Otherwise, it is often a challenge for them to grasp what their role is and what are they supposed to do. Informatica Axon provides that visualization which helps a lot.

In terms of what could be improved, they need to create a rules repository. Business rules for the attributes that you have, keeping them in that central repository, and governance of them is something which Axon is lacking a bit. The Informatica Data Quality tool actually caters to that, so that's probably why they have not built that up in the Axon, but it is definitely something that can be built in to this product, as well.

I have been using Informatica Axon for about four years.

Informatica Axon is stable.

Informatica Axon is scalable.

I have had experience with their technical support. It is definitely there, as in it's quite robust and is a mature tool. You do get enough technical support from Infomatica while implementing it.

The initial setup is purely straightforward.

In terms of price, Informatica products are all a bit pricier than the rest of the market. But if you want to go for products from that stable, I think you'll have to pay a price.

If you have an Informatica installation already, be it IDQ or Informatica MDM, then Axon is the right choice. It's a no-brainer to have Axon.

On a scale of one to ten, I would give Informatica Axon an eight.

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.

We use the product for building static and automatic data lineages.

It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen. Additionally, they should add AI features and the capability to provide data streaming insights.

We have been using Informatica Enterprise Data Catalog for two and a half years.

The product seems stable enough.

We have 30 Informatica Enterprise Data Catalog users in our organization.

The product requires maintenance.

I advise others to understand their business use cases. I rate Informatica Enterprise Data Catalog a three 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.

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