IT Central Station is now PeerSpot: Here's why

Informatica PowerExchange Valuable Features

Mohamed Elkady - PeerSpot reviewer
Data Management Consultant & Delivery Manager at IME

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.

View full review »
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a computer software company with 10,001+ employees

A valuable feature is the way it utilizes a push down optimization. This teradata is a fantastic combination of BDO and I think is one of the features which has really been very prominent and very effective. You're using the Hadoop ecosystem to do a significant amount of necessary processing and you're using the internal transformation engine of Informatica to do that. 

Another feature of the solution is coupling up and seamlessly driving the underlying stock jobs or scoop jobs which are essentially executable within the Hadoop ecosystem. This provides a significant amount of control over the landscape and overall implementation. 

A further element is the underlying metadata and the monitoring and auditing components which Informatica provides. If you're running a complex next gen, powerful analytics and modern BI analytics platform or an ecosystem, then I think these three things along with the integration with external sources and external components is seamless in terms of an SMS engine or an email or even offering integration with WhatsApp.

Along with that, Informatica has been trying to spread its tentacles across stuff like Data Life Cycle Management and a lot of things in MDM, etc. Overall it's a rich toolkit and covers a very wide aspect of data management.

View full review »
Software Test Automation Engineer at a insurance company with 1,001-5,000 employees

The target system is Legacy Systems.

View full review »
Buyer's Guide
Data Integration Tools
June 2022
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: June 2022.
610,812 professionals have used our research since 2012.