IT Central Station is now PeerSpot: Here's why

Azure Data Factory vs Informatica PowerCenter comparison

Cancel
You must select at least 2 products to compare!
Executive Summary
Updated on March 14, 2022

We performed a comparison between Azure Data Factory and Informatica Powercenter based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.

  • Ease of Deployment: Users of Azure Data Factory say that the initial setup is straightforward, easy, and fast. While most Informatica Powercenter reviewers said it was simple to deploy, some mentioned that if you will be implementing configuration and domain creation with multiple nodes, it can be time-consuming.
  • Features: Valuable features of Azure Data Factory include scalability, drag-and-drop interface, pipeline orchestration, built-in connectors, data transformations, and data copy templates. Informatica Powercenter’s most valuable features include its metadata repository, the data warehouse application console, its reliability, automated scheduling, easy integration with multiple platforms, monitoring tools, and reporting manager.
  • Pricing: While some Azure users claim that it is very expensive, most users of Azure Data Factory feel that the product is actually affordable and reasonable. Users of Informatica Powercenter consider the pricing to be on the more expensive side.

  • Service and Support: Users of Azure Data Factory have varying opinions of the service and support; Some have had really good experiences while others feel they are lacking in terms of responsiveness. In regards to Informatica Powercenter, some reviewers feel that their response time could be faster, while others consider the technical support to be just average.

Comparison Results: Based on the parameters we compared, Azure Data Factory and Informatica Powercenter are very comparable to one another. Overall, PeerSpot users found that both solutions have helpful features. However, users found Informatica Powercenter to be more expensive than Azure Data Factory.

To learn more, read our detailed Azure Data Factory vs. Informatica PowerCenter report (Updated: May 2022).
Buyer's Guide
Azure Data Factory vs. Informatica PowerCenter
May 2022
Find out what your peers are saying about Azure Data Factory vs. Informatica PowerCenter and other solutions. Updated: May 2022.
607,332 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most valuable features are data transformations.""Data Factory's most valuable feature is Copy Activity.""The most valuable feature of this solution would be ease of use.""It is easy to integrate.""The most important feature is that it can help you do the multi-threading concepts.""One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect.""It's extremely consistent.""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."

More Azure Data Factory Pros →

"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth.""We have found the PowerCenter and B2B data transformation most valuable.""The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.""Can manage a huge quantity of data and provide reliability.""If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.""The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.""The solution is stable.""It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."

More Informatica PowerCenter Pros →

Cons
"My only problem is the seamless connectivity with various other databases, for example, SAP.""There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base.""The one element of the solution that we have used and could be improved is the user interface.""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.""The support and the documentation can be improved.""The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.""It does not appear to be as rich as other ETL tools. It has very limited capabilities.""Data Factory's cost is too high."

More Azure Data Factory Cons →

"The performance of Informatica PowerCenter could improve.""Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help.""I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases.""The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through.""PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one.""I would like to see it be able to import data from NoSQL.""In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard.""Support could be better."

More Informatica PowerCenter Cons →

Pricing and Cost Advice
  • "The price you pay is determined by how much you use it."
  • "Understanding the pricing model for Data Factory is quite complex."
  • "I would not say that this product is overly expensive."
  • "The licensing is a pay-as-you-go model, where you pay for what you consume."
  • "Our licensing fees are approximately 15,000 ($150 USD) per month."
  • "The licensing cost is included in the Synapse."
  • "It's not particularly expensive."
  • "Product is priced at the market standard."
  • More Azure Data Factory Pricing and Cost Advice →

  • "It's much more expensive, almost three times more expensive than most other solutions."
  • "We are satisfied with the pricing."
  • "I consider this to be an expensive product."
  • "It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
  • "The price of this solution is high."
  • "Our client has purchased the license, and we are using it."
  • "The solution is in the middle price range compared to other solutions."
  • "Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
  • More Informatica PowerCenter Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    607,332 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer: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 and… more »
    Top Answer: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… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer: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… more »
    Ranking
    2nd
    Views
    30,003
    Comparisons
    24,652
    Reviews
    27
    Average Words per Review
    480
    Rating
    7.8
    1st
    Views
    32,823
    Comparisons
    28,438
    Reviews
    28
    Average Words per Review
    455
    Rating
    8.3
    Comparisons
    Also Known As
    PowerCenter
    Learn More
    Overview

    Create, schedule, and manage your data integration at scale with Azure Data Factory - a hybrid data integration (ETL) service. Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

    Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

    Offer
    Learn more about Azure Data Factory
    Learn more about Informatica PowerCenter
    Sample Customers
    Milliman, Pier 1 Imports, Rockwell Automation, Ziosk, Real Madrid
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    Top Industries
    REVIEWERS
    Computer Software Company30%
    Manufacturing Company9%
    Financial Services Firm9%
    Insurance Company9%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider13%
    Financial Services Firm8%
    Energy/Utilities Company7%
    REVIEWERS
    Computer Software Company29%
    Financial Services Firm16%
    Retailer11%
    Healthcare Company5%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider11%
    Financial Services Firm10%
    Insurance Company7%
    Company Size
    REVIEWERS
    Small Business24%
    Midsize Enterprise22%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    REVIEWERS
    Small Business19%
    Midsize Enterprise12%
    Large Enterprise69%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise12%
    Large Enterprise74%
    Buyer's Guide
    Azure Data Factory vs. Informatica PowerCenter
    May 2022
    Find out what your peers are saying about Azure Data Factory vs. Informatica PowerCenter and other solutions. Updated: May 2022.
    607,332 professionals have used our research since 2012.

    Azure Data Factory is ranked 2nd in Data Integration Tools with 31 reviews while Informatica PowerCenter is ranked 1st in Data Integration Tools with 30 reviews. Azure Data Factory is rated 7.8, while Informatica PowerCenter is rated 8.2. The top reviewer of Azure Data Factory writes "Easy to bring in outside capabilities, flexible, and works well". On the other hand, the top reviewer of Informatica PowerCenter writes "A stable, scalable, and mature solution for complex transformations and data integration". Azure Data Factory is most compared with Informatica Cloud Data Integration, Talend Open Studio, Alteryx Designer, Palantir Foundry and SAP Data Services, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, SSIS, AWS Glue, Informatica PowerExchange and Oracle Data Integrator (ODI). See our Azure Data Factory vs. Informatica PowerCenter report.

    See our list of best Data Integration Tools vendors.

    We monitor all Data Integration Tools 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.