Informatica PowerExchange Review

Easy to work with, fast, and very stable

What is our primary use case?

We work with Informatica PowerExchange for a very big trial for data warehousing and loading data for various systems. They work off transformation, creating a data warehouse. We also made part of the administration for that client. 

What is most valuable?

They wanted to load data continuously, so the jobs were run twenty-four hours per day because the volume of data was huge. The big transformations were made in a data warehouse for this project and it was very fitting to do this. So the transformation work called for Informatica PowerExchange. It was easy to work with this and very stable.

What needs improvement?

Integration with the largest number of databases and other systems would be important. We worked a lot with this ETL tool and in my opinion, it is the best on the market and what we missed in Informatica, compared with ETL. For example, each component in parallel with a configurable parallel made on the same machine or even on different machines. It's that kind of thing that I don't think Informatica PowerExchange can provide at this moment. In Informatica PowerExchange we ran jobs in parallel but not components with a parallel degree.

How are customer service and technical support?

We had two or three training meetings at the time it was set up with Informatica and after that, we kept the link with them so in case we had any issue, we could ask them. The support was very good.

What's my experience with pricing, setup cost, and licensing?

The setup was straightforward and not very complex.

What other advice do I have?

I would rate Informatica PowerExchange at a nine on a scale of ten. I would recommend it. I would not rate it a ten because I have seen better tools.

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,082 professionals have used our research since 2012.
Add a Comment