What is our primary use case?
Informatica PowerCenter is used for data integration.
What is most valuable?
To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions.
Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use.
Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle.
What needs improvement?
Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful.
Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it.
What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together.
For how long have I used the solution?
I've been using Informatica PowerCenter for six or seven years.
I'm still using it as my company has many solutions that leverage Informatica PowerCenter, though the solution isn't that active nowadays because Informatica has a different strategy to promote the cloud-based data integration offering.
Informatica PowerCenter is still in the market, and what my company is using is the on-premise version.
What do I think about the stability of the solution?
Informatica PowerCenter is a stable solution, and I would rate its stability seven out of ten. There's a small improvement needed in terms of stability because it's linked to the clustering and high availability. Somehow you'll need a lot of automation to get Informatica PowerCenter to handle the workload, and in certain situations, there could be failures.
How are customer service and support?
I found the technical support for Informatica PowerCenter brilliant. I'm even giving it a rating of four out of five just because I can't give it a five. Informatica support is even awarded for customer satisfaction if I remember correctly.
How was the initial setup?
The initial setup for Informatica PowerCenter was simple. It was a straightforward setup, and it wasn't complicated at all.
What's my experience with pricing, setup cost, and licensing?
Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products.
Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive.
Which other solutions did I evaluate?
I evaluated Talend, which is an open-source data engineering and data integration platform. Comparing the two solutions, Informatica PowerCenter is still more robust and has an extendable platform. You can add other capabilities, such as data quality and so on, but if you'll be focusing only on data integration, Talend, especially coming from an open-source mindset, would be a good competitor.
My preference, because I had experience with IBM and Talend, would be Informatica PowerCenter because of the ease of use, flexibility, and features that come with it.
What other advice do I have?
Informatica PowerCenter is an on-premise data integration solution, but two or three years ago, Informatica introduced a new, intelligent data platform. That new platform is the equivalent of Informatica PowerCenter in terms of capability, but the only difference is that it's a fully on-cloud solution.
Informatica PowerCenter is best for big enterprises. Technically, you can use it for any scale, but practically you will get the most output when you're dealing with high volumes and heavy processing. This is from a technical aspect. Price-wise, it's not a cheap platform, so only enterprises with a bigger data management budget will be able to afford to invest in a data management platform such as Informatica PowerCenter.
My rating for Informatica PowerCenter is eight out of ten. Eight is a fair rating because it's a very stable and very mature product.
My company has a partnership with Informatica and other vendors. I'm a system integrator.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner/Integrator