Informatica PowerCenter Review

Assists us with integration as we migrate from on-premise to cloud, but it needs a performance analyzer

What is our primary use case?

We are implementing our master data management integration solution. The idea is to have the data cleaned, and have a catalog set up so that we have a library we can consult to see what type of data is being used. At the same time, have a tool to provide a three hundred and sixty-degree view of our customer data. We will also have a unique repository and a data link that we're setting up in Azure.

We will be moving all of our storage to the cloud so that we have a single repository, and this data will be accessible by our tools such as Tableau, for integration with our reporting. 

Currently, we are in a hybrid-cloud environment, but our intention is to be cloud-based using Azure.

What is most valuable?

The two most important components are the building and integration. On top of that, you can clean and analyze your data to make sure that you don't have any corruption. In the end, you have structured, proper data for use in an integrated BI solution.

What needs improvement?

I would like to see the inclusion of a tool that allows you to report performance metrics. For example, it can determine whether the connectivity is correct, or how long it's taking the integration to move data from one place to another. This would allow administrators to govern the performance and better maintain the solution. Having a tool that can work is nice, but we're not sure if it works accurately without something to evaluate performance.

Integration with Artificial Intelligence would benefit this solution. The system should start to learn the behavior of your connections, and understand where your data is coming from to ensure that the process is being done correctly. As the system learns the stages, it will be able to easily identify problems. For example, if I have different databases where I want to store information, such as pictures in one and PDF files in another, it will be able to distinguish that.

For how long have I used the solution?

We have been using this solution for less than one year and are still pre-production.

What do I think about the stability of the solution?

We are still launching this solution so I cannot tell you if it is stable or not. We believe that with the support and resources we are getting, it will be. Our vision is to be as stable as possible, and we do not want to lose any data.

What do I think about the scalability of the solution?

We performed some testing with our Asian platform and it was working fine. We are working in several countries at the same time, integrating their products, and we are hoping that it goes as smoothly as the one from Asia. This tool should allow us to scale, but we will have to wait and see.

We have between fifty and sixty people using this solution.

How are customer service and technical support?

Informatica is assisting us with the implementation and they know what we are trying to accomplish. They have visibility as to what our company does, and having people like that helps a lot. Overall, at the moment we are very happy with the support and their contribution.

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

We did not have another solution in place before this. We knew that it was something that we needed to do. Since we are moving from on-premise to the cloud, we needed something to help us with the integration.

What about the implementation team?

We hired somebody from Informatica to help us with the implementation. We have no complaints about their service.

Which other solutions did I evaluate?

Choosing this solution was a little bit complex for us because there are a lot of different vendors in that space. We had to do a proper evaluation and negotiation to get to the solution that we needed. Some vendors offer a certain package, whereas others offer another package, and there are certain components from one vendor that we needed in the other one. There is where the complexity came from. In the end, we choose the one that we thought was the proper solution for us.

What other advice do I have?

There is a lot of competition in the space, and the vendors want to get good companies where they can implement their solution. It doesn't mean that every product fits every organization. My advice for anybody researching this type of solution is to meet with all of the vendors, discuss the proof of concept based on what the company has, and see if the solution is really the proper one for them. The vendors need to be honest in evaluating whether the product can really fit the needs, and they should be able to justify it.

Overall, we are satisfied with the product so far, as well as the support. In any tool, there's always something to chase and always something that can be done better.

I would rate this solution a seven out of ten.

**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 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: June 2021.
511,607 professionals have used our research since 2012.
Add a Comment
ITCS user