Azure Data Factory vs Informatica PowerExchange comparison

Microsoft and Informatica are both solutions in the Data Integration category. Microsoft is ranked #1 with an average rating of 8.0, while Informatica is ranked #19 with an average rating of 7.9. Microsoft holds a 11.1% mindshare in DI, compared to Informatica’s 1.2% mindshare. Additionally, 92% of Microsoft users are willing to recommend the solution, compared to 89% of Informatica users who would recommend it.

Azure Data Factory

Read 86 Azure Data Factory reviews

23,087 Views
18,331 Comparison Views

92% willing to recommend

Informatica PowerExchange

Read 20 Informatica PowerExchange reviews

2,053 Views
1,527 Comparison Views

89% willing to recommend

Azure Data Factory

Informatica PowerExchange

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Azure Data Factory and Informatica PowerExchange based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Azure Data Factory vs. Informatica PowerExchange Report (Updated: October 2024).

Buyer's Guide

Azure Data Factory vs. Informatica PowerExchange

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

Azure Data Factory

Ranking in Data Integration

1st

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (3rd)

Informatica PowerExchange

Ranking in Data Integration

19th

Average Rating

7.8

Reviews Sentiment

7.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Azure Data Factory is 11.1%, down from 13.3% compared to the previous year. The mindshare of Informatica PowerExchange is 1.2%, down from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Thulani David Mngadi

Data architect at Old Mutual

Data flow feature is valuable for data transformation tasks

The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.

Read full review

Mohammad Faizan Ahmad

Sr. Technical Engineer at Investcorp Bank BSC

Helpful in handling areas like complex data sources and data processing but needs improved support services

The major challenge with the tool stems from the fact that if you are implementing it in the cloud, then it has to be within the framework. Another challenge is the large volume of data. Informatica PowerExchange is a product through which we enable connectivity, so it is not an application product or a stand-alone tool, but Informatica's core systems or IICS uses it to connect to multiple systems. The major challenge associated with the tool is on the infrastructure side. The tool's features could be something faster with more connectors. A number of connectors can help connect to a wide variety of applications. The tool should focus on reducing the resilient time, like, if any network disconnectivity happens, then auto-reconnection and the retry method should be more robust so that manual intervention is not required. We communicate with the tool's support team as we need to raise our issues with them. I have already worked with Informatica and have a total experience of around eight to nine years; the one problem with the tool is its support team since they take a lot of time to address a particular issue. If one time you schedule a call and explain the situation to them about the issue, the support team will raise tickets and take notes. They will ask you to share the logs or screenshots of the errors, and you will get no resolution. The support team will randomly give you some documents and expect you to go through them, and if you get back to them with questions, a new person will be allocated, and you will have to start explaining everything again. I would not say it is a pleasant experience.

Read full review

Quotes from Members

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

Pros

"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."

"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."

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

"Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."

"From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."

"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."

"The platform excels in data transformation with its user-friendly interface and robust monitoring capabilities, making ETL processes seamless."

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

More Azure Data Factory pros

"Mainstream integration and real-time integration are the best features."

"It is easy to integrate the solution with other tools."

"The data transformation is the solution's most valuable feature."

"Provides a significant amount of control over the landscape and overall implementation."

"The scalability is excellent."

"This product is easy to install and it can be done in a few hours."

"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."

"The most valuable feature is connectivity to data sources."

More Informatica PowerExchange pros

Cons

"Some known bugs and issues with Azure Data Factory could be rectified."

"We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."

"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."

"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."

"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."

"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."

"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."

"The deployment should be easier."

More Azure Data Factory cons

"I would like to have easier integration with cloud platforms."

"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."

"I would like the stability to improve."

"The solution needs better integration with other tools."

"Technical support can be improved with respect to delays in ticket response time."

"The product is not suitable for application integration."

"Should diversify more, maybe with a reporting and visualization utility,"

"Integration with the largest number of databases and other systems would be important."

More Informatica PowerExchange cons

Pricing and Cost Advice

"The price is fair."

"Our licensing fees are approximately 15,000 ($150 USD) per month."

"For our use case, it is not expensive. We take into the picture everything: resources, learning curve, and maintenance."

"The solution's pricing is competitive."

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

"It's not particularly expensive."

"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."

"The solution is cheap."

More Azure Data Factory pricing and cost advice

"The product is not very expensive."

"Many users don't prefer to use the product, considering the high costs attached to the licensing part of the solution."

"There is a need to pay towards the licensing cost of the product. It is an expensive product."

"It's expensive. In fact, nobody would buy any product of Informatica if the price was the only consideration. It costs money, and it doesn't come cheap, but it provides value for money in many ways."

"An annual package license fee is required."

"There are licensing and connector costs. Basically, Informatica is pay-as-you-use."

"The cost of PowerExchange is reasonable. It does not rely on complicated formulas or unrealistic equations. The pricing model is straightforward. There is one component, and real-time integration is included. Some other solutions require purchasing additional modules or third-party plugins for this capability."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

13%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Financial Services Firm

27%

Computer Software Company

13%

Insurance Company

11%

Government

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.

See all answers

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

See all answers

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

See all answers

What do you like most about Informatica PowerExchange?

The product’s flexibility is valuable.

See all answers

What is your experience regarding pricing and costs for Informatica PowerExchange?

There are licensing and connector costs. Basically, Informatica is pay-as-you-use. There is one product cost and then the additional number of connectors or applications to which you are connecting...

See all answers

What needs improvement with Informatica PowerExchange?

See all answers

Comparisons

Informatica PowerCenter vs Azure Data Factory

Compared 14% of the time

Snowflake vs Azure Data Factory

Compared 11% of the time

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

Compared 8% of the time

Alteryx Designer vs Azure Data Factory

Compared 7% of the time

IBM InfoSphere DataStage vs Azure Data Factory

Compared 4% of the time

More Azure Data Factory Competitors

Informatica PowerCenter vs Informatica PowerExchange

Compared 82% of the time

Oracle GoldenGate vs Informatica PowerExchange

Compared 10% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerExchange

Compared 5% of the time

AWS Database Migration Service vs Informatica PowerExchange

Compared 3% of the time

More Informatica PowerExchange Competitors

Product Reports

Buyer's Guide

Azure Data Factory

November 2024

Download Azure Data Factory product report

Buyer's Guide

Informatica PowerExchange

November 2024

Download Informatica PowerExchange product report

Also Known As

No data available

PowerExchange, Connectors

Learn More

Microsoft

Informatica

Overview

Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.

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

ACH Food, BNSF Railway Company, Illinois State University

Buyer's Guide

Azure Data Factory vs. Informatica PowerExchange

October 2024

Free Report: Azure Data Factory vs. Informatica PowerExchange

Find out what your peers are saying about Azure Data Factory vs. Informatica PowerExchange and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our Azure Data Factory vs. Informatica PowerExchange report.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.