PowerCenter is a Industry Leading integration tool
October 30, 2015

PowerCenter is a Industry Leading integration tool

Brian Randolph | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Software Version

9.1 AE

Modules Used

  • PowerCenter, IDQ, PowerExchange for Salesforce

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.
PowerCenter is by far the industry leader when it comes to extract, transform and load applications. The ability to access a multitude of data sources and targets makes the product versatile. And the graphic user interface makes it easy to learn and use the tool with limited knowledge. Even business users can understand the mappings and logic applied.

Informatica PowerCenter Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
6
Simple transformations
10
Complex transformations
7
Data model creation
6
Metadata management
6
Business rules and workflow
8
Collaboration
6
Testing and debugging
8
Integration with data quality tools
7
Integration with MDM tools
7