Try our new research platform with insights from 80,000+ expert users
PrashantTripathi - PeerSpot reviewer
Data Engineer at a pharma/biotech company with 10,001+ employees
Real User
Top 10
Useful query handling, quick support, but user interface could improve
Pros and Cons
  • "The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."
  • "Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."

What is our primary use case?

We are using Informatica Cloud Data Integration in a large organization, and we have customers all across the world. 

Informatica Cloud Data Integration is for migrating data from a source to a target. The major advantage of working with this solution is that it can handle large amounts of data. The drawback is the performance is a bit slow but it can handle a large amount of data compared to other tools.

What is most valuable?

The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server.

What needs improvement?

Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them.

In a future release, the UI should be more developed to allow more features.

For how long have I used the solution?

I have been using Informatica Cloud Data Integration for approximately four months.

Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
February 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
841,004 professionals have used our research since 2012.

What do I think about the stability of the solution?

Informatica Cloud Data Integration is stable. 

I rate the stability of Informatica Cloud Data Integration a four out of five.

What do I think about the scalability of the solution?

There are some performance issues sometimes.

We have more than 50 developers using the solution in my company.

I rate the scalability of Informatica Cloud Data Integration a three out of five.

How are customer service and support?

The support from Informatica Cloud Data Integration is great. They respond quickly and if there is an issue it can be resolved fast.

I rate the support from Informatica Cloud Data Integration a four out of five.

How would you rate customer service and support?

Positive

What's my experience with pricing, setup cost, and licensing?

Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality.

There can be extra changes, such as using the cloud.

I rate the price of Informatica Cloud Data Integration a two out of five.

What other advice do I have?

This is a good tool and others should use it. This solution is known for its ability to handle large amounts of data and in the market, there are not that many tools available. However, there are competitors in the market, such as Oracle and IBM.

If an organization's data is very limited and they are not using large amounts of data, then I would suggest going for a smaller targeting solution, such as Dell Boomi. When it comes to large and secure data, I would recommend others to use this solution or SAP BODS or IBM.

Informatica Cloud Data Integration has a nice GDP rating and a good European market.

I rate Informatica Cloud Data Integration a seven out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Product Owner - Data Management at Maersk
Real User
Excellent at standardizing mass data and capable of integrating with multiple solutions
Pros and Cons
  • "The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data."
  • "When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."

How has it helped my organization?

The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data. 

What is most valuable?

The solution's ability to integrate with different solutions is a big selling point for us. It's also quite powerful and customizable. I really enjoy its match and merge capabilities.

What needs improvement?

When it comes to UI look and feel and user experience, Informatica is not as good as other solutions.

There are some MDM solutions that come with an integrated view, which includes your transactional and master and all other data together and helps you get a 360 view of the object. That's where I think Informatica is not as powerful or as agile in the way other solutions are out of the box. 

For how long have I used the solution?

I've been using the solution for 20 years.

What do I think about the scalability of the solution?

It's quite simple to scale the solution. We have about 30,000 users, but I don't see a limitation on the solution that would stop you from having more.

How are customer service and technical support?

Technical support is pretty good. It does take time. Some solutions are not fixed, but they have releases and updates that deal with the issues, so, I don't see a lag in support in that sense.

Which solution did I use previously and why did I switch?

In 2010, there were only maybe three solutions: SAP, IBM, and Informatica. Before that, we didn't really have a centralized mass data contract, so it was more of an application grievance. With Informatica, we gained centralization of mass data, and also had governance and quality as part of a data management practice, and I think, at the time, the full package was available with Informatica as compared to other options.

How was the initial setup?

I was not the installer, so I'm unsure of how complex the initial setup was.

What other advice do I have?

We use the on-premises version of the solution.

I would recommend the product, but it depends on your business and other solutions you might already be using. If you're only using SAP, I don't think you'll need Informatica. If you're using Oracle products, you don't even need SAP.

However, if you're looking for an essential repository with very good integration capabilities, want to have a longterm sustainable solution, and you have multiple ESPs, as well as a wider organization setup, then I think Informatica is the best.

I would rate the solution at eight or nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
February 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
841,004 professionals have used our research since 2012.
Assistant Director at Kaxju
Real User
Top 5Leaderboard
Provides data cataloging and lineage with metadata management but lacks integration
Pros and Cons
  • "The valuable feature is metadata management. If you want to trace sensitive data, you can auto-classify them. You can search for sensitive information through EDC. Using Discovery, you can identify if there is any type of data set."
  • "The integration with other data management tools can be enhanced. For instance, there is no integration with tools like Collibra or Hubview."

What is our primary use case?

We use the solution for data cataloging and lineage.

What is most valuable?

The valuable feature is metadata management. If you want to trace sensitive data, you can auto-classify them. You can search for sensitive information through EDC. Using Discovery, you can identify if there is any type of data set.

What needs improvement?

EDC is only used for cataloging and meetings. Currently, not many different databases are integrated with it. The ETL logic should be visible within the tool. If EDC is integrated with Axon, you will see the data lineage and catalog because of EDC. If EDC is removed, you cannot see any lineage or catalog.

We need EDC on the application level. Currently, it is only at a system level. It can be shown as an application layer between policies or regulations. This kind of feature can be enabled.

The integration with other data management tools can be enhanced. For instance, there is no integration with tools like Collibra or Hubview.

For how long have I used the solution?

I have been using Informatica Enterprise Data Catalog for seven years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

EDC needs many ports to run. Therefore, to improve performance, you need to increase the number of cores.

How was the initial setup?

The initial setup is easy and takes two weeks to complete. One person is enough to deploy it.

What was our ROI?

EDC gives you a better understanding of architecture and the system used. You cannot use EDC completely unless you have access.

What's my experience with pricing, setup cost, and licensing?

The product is expensive.

What other advice do I have?

EDC is a standalone application, so it doesn’t really make much sense. It doesn’t give you a lot of features that way; it’s primarily for cataloging and classification. Nobody would buy EDC as a standalone application. When people are buying EDC, it’s always with Axon.

I recommend buying the solution altogether with Axon.

Overall, I rate the solution as seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: MSP
Flag as inappropriate
PeerSpot user
NidhiSinha - PeerSpot reviewer
Solutions Architect at Tech Mahindra Limited
Real User
Top 5
Provides good data quality and valuable features like match-merge engine and CLAIRE AI engine
Pros and Cons
  • "The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation."
  • "Compared to other tools in the market, Informatica MDM is costly."

What is our primary use case?

Informatica MDM is used for our customers' master data management journey. The solution meets our client's requirements for their customer-supplier or any other entities.

What is most valuable?

The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation.

What needs improvement?

Compared to other tools in the market, Informatica MDM is costly.

For how long have I used the solution?

I have been using Informatica MDM for 13 years.

What do I think about the stability of the solution?

Informatica MDM is highly stable compared to any other tool in the market.

What do I think about the scalability of the solution?

Informatica MDM is a highly scalable solution. Our clients for Informatica MDM are mostly medium and enterprise businesses.

I rate the solution eight and a half out of ten for scalability.

How are customer service and support?

Technical support refuses to support us if we customize the tool. We customize the product based on the customer's needs, and we expect Informatica to provide support during that time as well.

How would you rate customer service and support?

Positive

How was the initial setup?

On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup an eight out of ten for on-premises and nine out of ten for the cloud version. Setting up the tool in the cloud via IDMC doesn't take much time.

What about the implementation team?

The solution can be deployed within a few hours.

What was our ROI?

Our customers have seen a return on investment with the solution.

What's my experience with pricing, setup cost, and licensing?

Informatica MDM is an expensive solution. On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing nine and a half out of ten.

What other advice do I have?

I would recommend the solution to other users because of its reliability and stability. Compared to other product vendors, Informatica MDM always has additional features. Informatica MDM has a CLAIRE AI engine, which helps with AI automation.

Overall, I rate the solution eight and a half out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
PeerSpot user
Pavan Burramukkala - PeerSpot reviewer
Technical Manager at a tech services company with 51-200 employees
Real User
Top 10
Offers favorable data warehousing features but needs to improve UI
Pros and Cons
  • "It is a scalable solution. Scalability-wise, I rate the solution a nine out of ten."
  • "Certain shortcomings in the product's UI make it an area where improvements are required."

What needs improvement?

You have to deal with a minimum of five, even if you want to go and check only a particular logic, making it an area with issues where improvements are required.

Certain shortcomings in the product's UI make it an area where improvements are required. The tool should provide ease of use and flexibility.

For how long have I used the solution?

I have been using Informatica Cloud Data Integration for four years.

What do I think about the stability of the solution?

Stability-wise, I rate the solution a five out of ten.

I see that my company faces frequent challenges in the tool when it comes to the area of UI and related to the area of characters. In my company, we have experienced some issues that occur when upgrading the tool.

What do I think about the scalability of the solution?

It is a scalable solution. Scalability-wise, I rate the solution a nine out of ten.

Enterprise-sized customers can choose Informatica Cloud Data Integration.

How are customer service and support?

The technical support for the solution is helpful, but it takes them time to figure out the issue. The time taken to close the ticket depends on the support that Informatica gets from their backend technical team. It takes a long time to close a ticket. I rate the technical support a seven out of ten.

How would you rate customer service and support?

Neutral

How was the initial setup?

The product's initial setup phase was not difficult.

The product's deployment phase can be carried out by linking a .exe file provided by the solution with your server.

The solution is deployed on the cloud.

Which other solutions did I evaluate?

Against Informatica Cloud Data Integration, I recommend SnapLogic, which is a cheaply priced product. People know about SnapLogic, as it comes with very good features and ease of use.

What other advice do I have?

The feature of the product that I find the most beneficial for data warehousing tasks is the use of the tool for extracting and loading purposes, which depends upon the connector's availability. Many connectors in Informatica are not free or out of the box, and you have to purchase them. The tool has quality connectors.

I haven't used the tool for real-time data analytics, but I have used it in my company for batch-oriented purposes. Data integration will not be supported in real-time in Informatica Cloud Data Integration. For real-time data integration, you have to go with either the application integration or other products like Informatica PowerExchange.

In Informatica Cloud Data Integration, the transformation feature was almost the same as that of Informatica PowerCenter. In Informatica Cloud Data Integration, the transformation features may offer a couple of more functionalities.

In terms of the ease of learning that the product provides, I would say that those who have experience with Informatica PowerCenter can easily adopt Informatica Cloud Data Integration. A person who has worked on Informatica Cloud Data Integration may not be comfortable with Informatica PowerCenter. In terms of ease of use, I consider Informatica PowerCenter to be easier than Informatica Cloud Data Integration.

I rate the ease of use experience attached to the tool a six out of ten.

Only after considering the use cases of people can I recommend the product to them. If a person only wants a product for extraction and loading purposes, then I feel that there are many cheap products in the market that can satisfy their needs. Suppose someone is looking at a tool that offers widespread features, like application integration and real-time functionalities. In that case, all of it comes under Informatica, which can be a good option.

The tool is the most expensive one compared to any of the other products in the market, especially in terms of ETL functionalities or integration features.

My company has integrated SAP, many databases, and APIs into Informatica Cloud Data Integration.

I can see that the performance of the product keeps improving with every new release, especially in the area of job executions, even though the hardware may be the same.

I rate the tool a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Independent Consultant at Telenet BVBA
Consultant
Top 10
Helps in consolidating all our master data across the entire organization
Pros and Cons
  • "The profiling feature in Informatica Data Quality is incredibly effective for data governance."
  • "There is room for improvement in the Data Marketplace aspect."

What is our primary use case?

I use Informatica Data Quality to consolidate master data across our organization, ensuring consistent and high-quality data. Combining MDM and data quality features, we address issues like customer data inaccuracies. Additionally, we document business terms in our data catalog for a unified view across the company.

What is most valuable?

The profiling feature in Informatica Data Quality is incredibly effective for data governance. It helps identify data types and potential duplicates, streamlining the detection process. It also suggests matches with predefined fields in our catalog.

What needs improvement?

There is room for improvement in the Data Marketplace aspect. Specifically, we found some basic functionalities lacking, like transparent integration of quality indicators. Customizability and additional features in the Data Marketplace would be welcomed in future updates. 

For how long have I used the solution?

I have been working with Informatica Data Quality for three years.

What do I think about the stability of the solution?

I would rate the stability of the solution as an eight out of ten.

What do I think about the scalability of the solution?

Scalability with Informatica had some initial challenges, especially when ingesting metadata into the data catalog due to the large volume of source systems and data. While it eventually worked, it took considerable time. Overall, I would rate it a six out of ten for scalability at the moment.

Initially, a few hundred users were using Informatica, but now it is a few thousand. 

How are customer service and support?

The technical support is good. I would rate them at a seven out of ten.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?



How was the initial setup?

Maintenance and troubleshooting are handled solely by the vendor.

What's my experience with pricing, setup cost, and licensing?

Informatica's licensing cost is among the highest in the market. I would rate it as a five out of ten in terms of costliness. With Informatica, we have a single bundled agreement covering the entire solution based on total capacity rather than specific modules. 

Which other solutions did I evaluate?

Before choosing Informatica, we evaluated various vendors, including IBM and Microsoft. Initially, we considered a best-of-breed approach, but Informatica emerged as the preferred choice for three out of four key areas: MDM, data quality, and data marketplace. While there were some limitations in certain tools like the data marketplace and data catalog, we opted for Informatica's complete suite to avoid additional integration efforts and to capitalize on its strengths in critical areas.

What other advice do I have?

The rule-based strategies feature in Informatica Data Quality has greatly benefited our data quality initiatives. With predefined rules in place, it provides a solid framework for assessing data quality. While data quality ultimately depends on source system updates, these rules give valuable insights and are heavily used alongside automatic profiling for effective data management.

Informatica Data Quality works within our IT setup for analyzing and reporting on data quality. It doesn't directly integrate with other tools, but it gives us clear insights. Data flows from sources to Informatica for analysis, and then to data stewards for updates, but there is no integration back to the original applications yet.

Navigating between modules within Informatica isn't always seamless. For instance, actions in the catalog might not be visible in the data marketplace.

Overall, I would rate Informatica Data Quality as an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2284407 - PeerSpot reviewer
Data Quality Team Lead at a pharma/biotech company with 10,001+ employees
Real User
Top 5
Improves data quality and has a good interface, but the integration process is not easy
Pros and Cons
  • "The product improves data quality."
  • "The integration process is not easy."

What is our primary use case?

I use the solution for preparing the data according to the data quality rules.

What is most valuable?

The mapping and mapplet features are valuable. The product improves data quality. The processes are running smoothly. The interface is good. Data integration is easy.

What needs improvement?

I use the solution to integrate on-premise and cloud products. There are issues with connectors to cloud applications. The integration process is not easy. The customer experience must be improved. When we implemented it, we did it with the help of Informatica professionals. I would not recommend them as an implementer. They didn't have any experience. It was very hard. The customer experience was not good. It's hard to understand the new features of the HR list. The tool must have more options for connectors. It is hard to connect to some of the applications. The remediation process is not straightforward.

For how long have I used the solution?

I have been using the solution for one and a half years.

What do I think about the stability of the solution?

I rate the tool’s stability an eight out of ten.

What do I think about the scalability of the solution?

I rate the tool’s scalability a six out of ten. It is a bit complex to scale. We have 20 users.

How are customer service and support?

The technical support is not good. The support team must improve the quality of support.

How was the initial setup?

The product is cloud-based.

What's my experience with pricing, setup cost, and licensing?

We got a 50% discount.

What other advice do I have?

We couldn’t deliver the full project. I will not recommend the product to others. Overall, I rate the solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solution Architect at Nihilent Technologies Ltd.
Real User
Top 20
A stable and scalable solution that needs some improvement with connectivity and automation
Pros and Cons
  • "The valuable feature is that we can automate the integration part...It is a stable solution."
  • "Informatica MDM has limitations with connectivity."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have been using Informatica MDM for more than ten years.

What do I think about the stability of the solution?

It is a stable solution.

What do I think about the scalability of the solution?

It is a scalable solution for sending any new setup or data. Approximately six hundred users are using the solution.

How are customer service and support?

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.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

The initial setup is straightforward. The deployment took ten to fifteen minutes, and almost fifteen administrators were needed for the deployment.

What was our ROI?


What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 2025
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.