A Powerful ETL Tool in Informatica PowerCenter Enterprise Data IntegrationUnspecified850101
Robert Goodman profile photo
October 09, 2013

A Powerful ETL Tool in Informatica PowerCenter

Score 8 out of 101
Vetted Review
Verified User
Review Source

Software Version


Modules Used

  • PowerCenter

Overall Satisfaction

  • Informatica is a complex, full-featured data integration tool. We use Informatica primarily to extract data from our ERP systems, transform, and load it into operational and dimensional data stores.
  • We have found that upgrading from version to version can be a bit clunky and complex.
  • Watch out for their audit department. They will hunt down development environments that are in use and try to back charge you for their repositories. Ensure your development environments are properly licensed.
  • Informatica allows us to achieve complex data integration among our systems and into our data warehouse environment. Without this tool in place, hours of manual manipulation would occur to integrate this data and extract it into the appropriate DW solution.
Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
We are considering their PowerCenter Advanced version which will add metadata and business glossary capabilities.