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

Azure Data Factory vs Informatica Enterprise Data Lake comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Azure Data Factory
Ranking in Data Integration
1st
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Cloud Data Warehouse (3rd)
Informatica Enterprise Data...
Ranking in Data Integration
40th
Average Rating
7.0
Reviews Sentiment
5.9
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2025, in the Data Integration category, the mindshare of Azure Data Factory is 10.0%, down from 12.9% compared to the previous year. The mindshare of Informatica Enterprise Data Lake is 0.2%, up from 0.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Joy Maitra - PeerSpot reviewer
Facilitates seamless data pipeline creation with good analytics and and thorough monitoring
Azure Data Factory is a low code, no code platform, which is helpful. It provides many prebuilt functionalities that assist in building data pipelines. Also, it facilitates easy transformation with all required functionalities for analytics. Furthermore, it connects to different sources out-of-the-box, making integration much easier. The monitoring is very thorough, though a more readable version would be appreciable.
reviewer2330691 - PeerSpot reviewer
A scalable tool that needs a lot of maintenance due to its unstable nature
Governance, data dictionary, and data cataloging are not available in Informatica Enterprise Data Lake. A lot of businesses are facing issues related to understanding the area revolving around insights of data. At Informatica Enterprise Data Lake's level, in our company, we have a lot of redundant data in a lot of our core systems. The basic thing that our company wants is for the product to develop a reporting layer and access data from the document layer so that we can avoid duplication in projects, databases, and data. There is a lot of maintenance to be done owing to the instability users may face every time because of the huge processing capacity as the company has around more than 50 nodes, which causes a lot of maintenance issues because of which a lot of people don't benefit from the platform as it functions in a slow manner. Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems. Every time, we have to find different tools we can use in our company with the solution since it doesn't support many real-time systems. Even if our company invests in some tools, Informatica Enterprise Data Lake creates too many small files with some issues, which we cannot read because we invested in HBase and Kudu, but performance-wise, the process is slow.

Quotes from Members

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

Pros

"The trigger scheduling options are decently robust."
"Data Factory's most valuable feature is Copy Activity."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"I can do everything I want with SSIS and Azure Data Factory."
"The solution handles large volumes of data very well. One of its best features is its ability to integrate data end-to-end, from pulling data from the source to accessing Databricks. This makes it quite useful for our needs."
"The solution has a good interface and the integration with GitHub is very useful."
"Allows more data between on-premises and cloud solutions"
"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"The process of using the tool's scalability option is well documented."
 

Cons

"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."
"The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."
"Some known bugs and issues with Azure Data Factory could be rectified."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"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."
"It would be better if it had machine learning capabilities."
"Real-time replication is required, and this is not a simple task."
"The initial setup is not very straightforward."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
 

Pricing and Cost Advice

"My company is on a monthly subscription for Azure Data Factory, but it's more of a pay-as-you-go model where your monthly invoice depends on how many resources you use. On a scale of one to five, pricing for Azure Data Factory is a four. It's just the usage fees my company pays monthly."
"ADF is cheaper compared to AWS."
"This is a cost-effective solution."
"There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling."
"I rate the product price as six on a scale of one to ten, where one is low price and ten is high price."
"The pricing is a bit on the higher end."
"I would rate Data Factory's pricing nine out of ten."
"The solution's pricing is competitive."
"The licenses attached to the solution are highly priced."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
842,466 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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...
What do you like most about Informatica Enterprise Data Lake?
The process of using the tool's scalability option is well documented.
What is your experience regarding pricing and costs for Informatica Enterprise Data Lake?
The licenses attached to the solution are highly priced. Informatica has licensing models for every product and for every feature, like the web service feature, which is something my company doesn'...
What needs improvement with Informatica Enterprise Data Lake?
Governance, data dictionary, and data cataloging are not available in Informatica Enterprise Data Lake. A lot of businesses are facing issues related to understanding the area revolving around insi...
 

Also Known As

No data available
Informatica Intelligent Data Lake, Intelligent Data Lake
 

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
Information Not Available
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: February 2025.
842,466 professionals have used our research since 2012.