Overall Satisfaction with PowerCenter
PowerCenter is used in multiple applications across our company. PowerCenter mappings load the data warehouse and various data marts for our marketing and executive teams. The Informatica Cloud platform, based on the PowerCenter engine, replicates data from our Salesforce deployment for downstream consumers. PowerCenter, along with the Informatica Data Quality offering, is utilized to cleanse and land source information for our Master Data Management platform. We utilize PowerCenter and the PowerExchange connector for Salesforce to publish the best version of the truth to the source systems. The tools address the issue of timely and efficient data loads, and to be able to apply data standards and business rules across multiple disparate platforms.
- PowerCenter connects to multiple sources and targets with ease, and at the same time.
- PowerCenter allows the application of complicated business rule logic with ease through a user friendly interface.
- PowerCenter logic can be captured and shared in mapplets, enabling reusability.
- Documentation of how the different offerings in the Informatica product line work together as a total data platform, and licensing across those offerings. This information is difficult to come by and more often than not requires Informatica Professional Services assistance.
- Copy and paste of elements to provide additional documentation and coding capabilities.
- Interface with industry standards such as Microsoft Excel.
- PowerCenter enabled turnaround on critical projects to be increased.
- PowerCenter enabled the delivery of time critical processes.
- PowerCenter allows increased employee efficiency with less experience.
PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar capabilities, but lack the range and depth when compared with the PowerCenter platform.