Informatica PowerCenter Review

A helpful solution for data integration with good technical support

What is our primary use case?

Our primary uses of the solution are for data integration and to build a warehouse model.

What is most valuable?

The solution is a very helpful product for data integration.

The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter. There are multiple transformations for service consumers to publish and use web services as well,In addition to the ability to implement ETL and ELT n a very easy way and finally, you have structured data for use in an integrated business intelligence solution.

What needs improvement?

The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer.

When we are dealing with multiple transformations and mapping, we cannot see the flow of our transformation until we run reports. It is not like Informatica Developer, where we can see every step of what we're doing and the flow of the mapping. With those solutions, we can see data and transformation and how it's affected by our expressions or anything we do. In Informatica PowerCenter, we cannot see any data in the transformation until the end or you may need to do some debugging, and it is very confusing for some people. They need to enhance their viewer so we can see data within the transformation and show the affected data. 

What do I think about the stability of the solution?

I haven't had a problem with Informatica PowerCenter's stability until recently. Sometimes it's very slow. I don't know why, but recently, the development has been very slow. I'm not sure if this is related to stability, however.

What do I think about the scalability of the solution?

The solution is good for scalability because it can be supplemented by a Data Quality solution ,Also, if our organization needs the scale increased, Informatica can satisfy this need, because it can deal with different types of sources and a huge amount of data. The features in partitioning and data optimization that Informatica uses make it very powerful.

How are customer service and technical support?

Technical support has been very helpful. Whenever we have a problem, they are able to solve it.

How was the initial setup?

Informatica platform installation was straightforward, just If the prerequisites checks done successfully, it will be very easy to do.

What other advice do I have?

I'm working with a lot of Informatica products. I use Informatica PowerCenter and IDQ as well as Informatica Axon.

In terms of Informatica Powercenter, we're not using the cloud. We have it running on our own servers.

Overall, I find that it's a very helpful product and a powerful tool compared to other products.

I would rate this solution eight out of ten.

Which version of this solution are you currently using?

**Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
More Informatica PowerCenter reviews from users
...who work at a Computer Software Company
...who compared it with SSIS
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: April 2021.
473,792 professionals have used our research since 2012.
Add a Comment