Informatica PowerExchange Review

Good connectivity to legacy data sources, but it needs better implements for working with big data

What is our primary use case?

I am a solution architect and PowerExchange is one of the products that I work with. It is used for data integration and we use it to bring together all of the data from our legacy systems.

What is most valuable?

The most valuable feature is connectivity to data sources. I leverage everything in terms of connectors to big data such as DBMS, RDBMS, and conversion to COBOL format. 

What needs improvement?

Saving a COBOL Copybook can be difficult and it would be nice if it were simplified. The complexity arises when we use recursive statements and redefined classes.

Technical support can be improved with respect to delays in ticket response time.

I would like to see more implements for big data including ORC file support. This is what most of our clients are now demanding.

For how long have I used the solution?

I have been working with Informatica PowerExchange for approximately five years. More generally, I have worked with Informatica products for between 10 and 12 years.

What do I think about the stability of the solution?

This has been a wonderful product and we have had no trouble with stability.

How are customer service and technical support?

We have been in contact with technical support and there have been delays in terms of responding to tickets. Overall, I would rate support as average.

Which solution did I use previously and why did I switch?

I have also used Informatica PowerCenter and the main difference is that PowerExchange is mainly cloud-hosted. People can access it from anywhere.

What other advice do I have?

The suitability of this tool depends on the client and their needs. Based on their requirements, this is certainly a solution that I would recommend. For example, if their teams are really diversified and they need a quick solution in terms of integration then this is the right product for them.

So far, I have found this product to be good. That said, we did face some difficulties with respect to data connections where we needed a real-time feed to be consumed.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

**Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
More Informatica PowerExchange reviews from users
...who compared it with Informatica PowerCenter
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: February 2021.
464,655 professionals have used our research since 2012.
Add a Comment