Informatica PowerCenter Review

Stable, reduces your administrative overhead, and the DAC is helpful

What is our primary use case?

This product is primarily used with an Oracle product called OBI EE, Oracle Business Intelligence. It is used for integration and data visualization.

How has it helped my organization?

This is the best tool that we have.

What is most valuable?

The most valuable features are the metadata repository and the data warehouse application console.

What needs improvement?

The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through. I would say that's the biggest issue.

For how long have I used the solution?

We have been working with Informatica PowerCenter for about seven years.

What do I think about the stability of the solution?

I think that PowerCenter is pretty stable.

What do I think about the scalability of the solution?

We have three different instances of this running. There is one for development, one for pre-production, and one for production. As far as having to scale linearly, we haven't had the need by putting additional nodes for high availability or load balancing. It's not something that we've necessarily needed. We have not scaled up, either. So, no vertical and no horizontal scaling. It was pretty much used out of the box.

We have two people who are using this solution and they are developers.

How are customer service and technical support?

Oracle came in and they implemented a lot of the functionality that we needed. Beyond what we received from Oracle, there were very few times where we needed support.

Most of the time, the only thing we needed technical support was with Oracle patches and we ran into a problem, something broke.

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

Initially, we were doing a custom PL/SQL ETL type of procedure.

We just decided to go to an automated tool, something that was more visual.

How was the initial setup?

The initial setup is pretty straightforward. I don't think that there were any problems with it.

What about the implementation team?

We had a lot of assistance from Oracle and the implementation took less than a week.

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

It's much more expensive, almost three times more expensive than most other solutions.

What other advice do I have?

Oracle put Informatica into their product line. They use Informatica fo do the integrations.

The one benefit is that you reduce your administrative overhead by implementing this tool, and you get more functionality out of it versus most other tools. 

With a lot of other tools, you have to do a lot of hacking in order to get things to work properly for you, whereas with Informatica, you have a lot of flexibility.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

**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 Financial Services Firm
...who compared it with Oracle Data Integrator (ODI)
Add a Comment