2021-09-29T12:42:00Z

How does Azure Data Factory compare with Informatica PowerCenter?

NC
  • 1
  • 140
PeerSpot user
1

1 Answer

Janet Staver - PeerSpot reviewer
Real User
Top 5
2021-10-28T12:16:46Z
Oct 28, 2021

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 maintain. Overall, I am impressed with its architecture.


However, I am not so thrilled with the service and technical support I have received so far. One huge disappointment for me with Azure Data Factory is that it lacks seamless connectivity, especially related to SAP. (If you are using Oracle it's not as much of an issue).


Besides for that it has been efficient, fast and easy to use. Of all its features, Azure’s data factory feature is the most valuable to me. It also stands out as a solid product for data transformation and data loading. I also like the interface and it has proven to have good performance so far.


With Informatica PowerCenter, I feel like there is a learning curve - but once you learn how to use it, it's easy. One advantage is that it requires fewer required resources in the case that the systems get migrated or updated.


For me, the fact that Informatica has multiple interfaces seems to add more confusion than necessary and makes for a complicated user experience. It is also problematic for me that I cannot use it to import data from NoSQL. In addition, I feel like the documentation has room for improvement. I also find it bothersome that with Informatica you need another tool for monitoring and it would be better if this feature was available.


Conclusion:


Personally, I would recommend Azure Data Factory instead of Informatica PowerCenter because I think overall it is a much better product choice. It is easy to implement whereas other tools often require specialized skills, partners, or IT teams to come and implement them for you. I also like that Azure is an affordable option.




Find out what your peers are saying about Azure Data Factory vs. Informatica PowerCenter and other solutions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Product comparison that may be of interest to you
Azure Data Factory vs. Informatica PowerCenter comparison
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...
Download Azure Data Factory vs. Informatica PowerCenter comparison ReportRead more

Related Q&As