4 out of 5.0, Reviewed Dec 7, 2015
Informatica PowerCenter and PowerExchange have been very capable products that provide a very comprehensive base level of data integration capability; although it is quite a steep learning curve before our developers became reasonable proficient. Informatica TDM is built on top of PowerCenter and has also been a very intuitive extension of the PowerCenter capabilities to provide lifecycle/test data management. Informatica DDM however is a very disappointing offering. It looks, behaves, and operates exactly like an acquired third party package. It shares no commonality with the rest of the Informatica platform, and simply does not have the same level of sophistication. Informatica support has been very lack-lustre. Although vendor 1st line support is initially responsive, any escalations take progressively longer amounts of time, with more "finger pointing" as the complexity of the issues get revealed. Fortunately, product issues with Powercenter, Powerexchange, and TDM have been fairly minor and rare. DDM on the other hand, has had more issues, as it is a less mature offering and its capabilities have been seemingly overstated.
Be extremely persistent with making your requirements known and ask for very explicit confirmation of product capabilities, especially with their maturing offering, DDM. Asking for a proof of concept or proof of technology during pilot project may also make sense.
Powercenter is a very comprehensive and well designed product. Once you are proficiently trained in it, it is quite easy to produce complex integration workflows.
The administration interface is a bit convoluted and difficult to navigate. The use of 4 different client tools also complicates the usage of powercenter. However, the eventual switch to Informatica Developer may help on the thick-client front.
Second line product support leaves a little to be desired. We occasionally came across finger pointing across complex issues.
ETL, TDM, and DDM should be treated as separate entities and we should not have attempted to just stick to one vendor for all types of functionality.
Installation and integration with other products is well documented and works as prescribed.
3 out of 5.0, Reviewed Oct 21, 2015
Overall the product suite, once understood and integrated met most of our needs. The amount of products and integration is somewhat confusing and took a long time to understand. The vendor oversold their ability to archive healthcare applications.
Have a good project plan in place and understand that the different pieces of the Informtica suite are not completely integrated. Understand that you will have to know exactly what you need for health application decommissioning needs. This is not an area that Informatica is strong in.
They work very well to accommodate with necessary end results on problems and product enhancements.
It is not well suited as an enterprise product. No LDAP groups, reporting not well integrated.
Identify all the different products, how they work together and understand how to put them together for "our" solution.
Interview people in healthcare who have already done this or who are currently doing this to see what their results are. But process plan around this.
As mentioned the overall product set meets most needs although somewhat over complicated.
Service and support is somewhat slow to respond but very good once engaged.
Too many different applications to integrate to get to the end result.