Try our new research platform with insights from 80,000+ expert users

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC) comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Azure Data Factory
Ranking in Data Integration
1st
Average Rating
8.0
Number of Reviews
85
Ranking in other categories
Cloud Data Warehouse (3rd)
Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
7.8
Number of Reviews
180
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (5th), Business-to-Business Middleware (3rd), API Management (8th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Featured Reviews

Anirban Bhattacharya - PeerSpot reviewer
Aug 19, 2022
Beneficial guides, scales well, and helpful support
Azure Data Factory can be deployed on the cloud and hybrid cloud. There have been very few deployments on private clouds The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain. Across the whole field of use, from…
Artur-Kowalczyk - PeerSpot reviewer
Mar 29, 2024
Offers cloud version, good connectivity and data profiling features
We had proof of concepts where certain test cases were given to improve the functionality of the vendor regarding the supply chain. So, it was a proof of concept. It was not applied in production. It was just illustrating the capabilities of the platform, and we were comparing it with other…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
"The data copy template is a valuable feature."
"Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft."
"The solution has a good interface and the integration with GitHub is very useful."
"The scalability of the product is impressive."
"The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy."
"We use the solution to move data from on-premises to the cloud."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"I am impressed by the solution's interface."
"The features for data quality, data cataloging, and UI are excellent."
"MDM is very stable - it can handle millions of hits daily and still run 24/7."
"The tool's most valuable feature is bulk upload. We upload files in CSV or Excel format."
"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."
"REST API: Excellent for scripting control and reporting mechanisms"
"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."
"The solution scales well."
 

Cons

"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"The product's technical support has certain shortcomings, making it an area where improvements are required."
"Azure Data Factory could benefit from improvements in its monitoring capabilities to provide a more robust feature set. Enhancing the ease of deployment to higher environments within Azure DevOps would be beneficial, as the current process often requires extensive scripting and pipeline development. It is also known for the flexibility of the data flow feature, particularly in supporting more dynamic data-driven architectures. These enhancements would contribute to a more seamless and efficient workflow within GitLab."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"Data Factory has so many features that it can be a little difficult or confusing to find some settings and configurations. I'm sure there's a way to make it a little easier to navigate."
"The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"Informatica MDM could be improved by adding drag and drop options, business data insights, and visualization reporting."
"The configuration process is pretty lengthy and challenging and could be made easier to understand."
"I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."
"Connectivity could be improved, it can be a little slow."
"We cannot sell the product directly with an additional layer."
"A general improvement in icons and the virtual interface would be good."
"I would rate my experience with the initial setup a two out of ten, with one being difficult and ten being easy."
 

Pricing and Cost Advice

"The solution is cheap."
"I would not say that this product is overly expensive."
"The cost is based on the amount of data sets that we are ingesting."
"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."
"I don't see a cost; it appears to be included in general support."
"For our use case, it is not expensive. We take into the picture everything: resources, learning curve, and maintenance."
"Product is priced at the market standard."
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"I rate the product's pricing a nine on a scale of one to ten, where one is low price, and ten is high price."
"The price of Informatica Cloud Data Integration could be reduced."
"The solution is very expensive."
"I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price."
"We switched to Informatica PIM because it was cheaper than the Oracle solution. It is cheaper initially, but they will bundle it later. This is what happens in the industry."
"It's an expensive solution."
"The price is comparable."
"It's pretty high for us. It's more on the higher side, like low to middle high."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
801,394 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
13%
Financial Services Firm
13%
Manufacturing Company
9%
Healthcare Company
7%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
Is the support provided by Informatica Cloud Data Integration helpful?
The support that Informatica Cloud Data Integration offers is very helpful. We had some issues with the setup of the product, as our team was not experienced with cloud data integration tools. We ...
 

Also Known As

No data available
ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
 

Overview

 

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa
The Travel Company, Carbonite
Find out what your peers are saying about Azure Data Factory vs. Informatica Intelligent Data Management Cloud (IDMC) and other solutions. Updated: September 2024.
801,394 professionals have used our research since 2012.