We compared Informatica PowerCenter and Informatica PowerExchange based on our user's reviews in several parameters.
Informatica PowerCenter is praised for its excellent data integration capabilities, strong metadata management, and user-friendly interface, while the pricing and ROI are highlighted positively. In contrast, Informatica PowerExchange stands out for its seamless connectivity, robust performance, and flexibility, but users mention the need for improvements in UI, documentation, and error handling.
Features: Informatica PowerCenter stands out for its excellent data integration capabilities, efficient workflow design and strong metadata management. PowerExchange is highly valued for its seamless integration and connection of data sources, robust data transformation capabilities, and user-friendly interface.
Pricing and ROI: Informatica PowerCenter has a manageable setup cost and a straightforward licensing process, according to user feedback. On the other hand, Informatica PowerExchange offers reasonable pricing compared to other similar products. Its setup cost is straightforward and does not require extensive time or resources. In terms of licensing, it is customizable and adaptable to specific needs, allowing for flexible usage and scalability., Informatica PowerCenter has a highly positive ROI, resulting in improved data integration and management processes and increased efficiency. It offers comprehensive reporting capabilities for better decision-making. On the other hand, Informatica PowerExchange also provides a positive ROI by integrating with various systems and enhancing productivity. It ensures reliability and scalability for handling large data volumes. Both products optimize business processes and deliver value to users.
Room for Improvement: Informatica PowerCenter has room for improvement in its user interface, documentation, training resources, performance, and stability. On the other hand, Informatica PowerExchange needs enhancements in its user interface usability, reliability, documentation, error handling capabilities, and simplified functionality. Both products aim to improve user experience and streamline processes.
Deployment and customer support: Based on user feedback, the duration required to establish a new tech solution like Informatica PowerCenter can vary, with some users spending three months on deployment and others spending an extra week on setup. However, there are users who report a week for both deployment and setup, indicating these terms may refer to the same period. On the other hand, the user feedback for Informatica PowerExchange suggests that the implementation duration varies, with some users spending three months on deployment and others spending only a week on setup. There are also users who mention a week for both deployment and setup, suggesting these terms may refer to the same period and should not be assessed separately., Informatica PowerCenter and PowerExchange both excel in customer service. PowerCenter prioritizes users' needs, with prompt and efficient assistance. PowerExchange receives high praise for its excellent support team, reliable assistance, and valuable solutions to address issues.
The summary above is based on 36 interviews we conducted recently with Informatica PowerCenter and Informatica PowerExchange users. To access the review's full transcripts, download our report.
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It's very easy to use it to develop mappings and workflows."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"Has a good visual tool for data mapping."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"It has helped us monetize."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It is a scalable and versatile solution."
"Provides a significant amount of control over the landscape and overall implementation."
"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."
"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 data transformation is the solution's most valuable feature."
"Mainstream integration and real-time integration are the best features."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"This product is easy to install and it can be done in a few hours."
"The performance of Informatica PowerCenter could improve."
"We had stability issues, mostly with JVM size."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"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."
"The documentation could be improved."
"I would like to see it be able to import data from NoSQL."
"The reputation of Informatica is that it is expensive."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"Technical support can be improved with respect to delays in ticket response time."
"The solution needs better integration with other tools."
"The product's high costs can be an area of concern where improvements are required."
"I would like to have easier integration with cloud platforms."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The product is not suitable for application integration."
"Pushdown optimization could be improved."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Informatica PowerExchange is ranked 20th in Data Integration with 19 reviews. Informatica PowerCenter is rated 8.0, while Informatica PowerExchange is rated 7.8. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and IBM InfoSphere DataStage, whereas Informatica PowerExchange is most compared with Oracle GoldenGate, Informatica Cloud Data Integration, Qlik Replicate and Azure Data Factory. See our Informatica PowerCenter 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.