Informatica PowerCenter Review

Utilized to ease and speed up building integrations between applications

What is our primary use case?

Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was very difficult to connect and integrate with other new applications. We used Informatica to read from our Hospital Information System and transform the data into a relational model in order to speed up reporting and do cleansing of the data. We also used Informatica to integrate SQL Server based applications with our Oracle applications.

How has it helped my organization?

Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System. 

What is most valuable?

The GUI.

For how long have I used the solution?

10 years.

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


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

Its maintenance is expensive.

Which other solutions did I evaluate?

Yes, we evaluated SSIS and IBM. We also looked at additional features in Informatica.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Informatica PowerCenter reviews from users
...who work at a Comms Service Provider
...who compared it with Oracle Data Integrator (ODI)
Add a Comment