One stop for all ETL needs
Anonymous | TrustRadius Reviewer
Updated February 29, 2016

One stop for all ETL needs

Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with PowerCenter

PowerCenter is being used across the organization for all our ETL needs, be it generating flat files from different sources or loading data from legacy systems into data warehouse or integrating multiple systems for reporting needs.
  • Ability to work with different types of sources and targets.
  • Version control of the code.
  • Ability to integrate with LDAP for security.
  • Ease of use.
  • Performance with ODBC drivers can be improved.
  • Memory utilization is very high during ETL execution.
  • Improved scheduling capabilities for in built scheduler.
  • Has been a very powerful tool with respect to EDW loads.
  • Has been a very good tool with integrating data from legacy systems with newer application.
  • Has been good with providing compliance extracts and encrypting the data.
PowerCenter can be run from different types of OSs and can integrate with multiple types of databases and applications compared to SSIS. PowerCenter performs better with any type of database due to its ability to use native drivers to read as well as load data. Due to its seam less integration with IDQ it can clean the data in a much easier and faster way than SSIS.
In scenarios where we have to integrate data from heterogeneous sources into targets PowerCenter is the best tool as it can extract as well as load data by using native drivers of each of the different databases with a performance that is not matched by any of its competitors. By bringing power exchange, data quality, metadata management and data discovery under one instance, Informatica has simplified PowerCenter integration with above mentioned tools as well as maintenance of the instance.

Informatica PowerCenter Feature Ratings

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

Using PowerCenter