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