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."I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"It is beneficial that the solution is written with Spark as the back end."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"Data Factory's most valuable feature is Copy Activity."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"The overall performance is quite good."
"The security of the agent that is installed on-premises is very good."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The product’s flexibility is valuable."
"Provides a significant amount of control over the landscape and overall implementation."
"This product is easy to install and it can be done in a few hours."
"The scalability is excellent."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"It is easy to integrate the solution with other tools."
"In the next release, it's important that some sort of scheduler for running tasks is added."
"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."
"It can improve from the perspective of active logging. It can provide active logging information."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"The product could provide more ways to import and export data."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"Real-time replication is required, and this is not a simple task."
"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."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"Pushdown optimization could be improved."
"The product is not suitable for application integration."
"Technical support can be improved with respect to delays in ticket response time."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"The connectivity with T24 core banking could be improved."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"I would like to have easier integration with cloud platforms."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews. Azure Data Factory is rated 8.0, while Informatica PowerExchange is rated 7.8. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, SSIS, Qlik Replicate and Informatica Cloud Data Integration. 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.