A Powerful ETL Tool in Informatica PowerCenter
October 09, 2013

A Powerful ETL Tool in Informatica PowerCenter

Robert Goodman | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Software Version

9.5.1

Overall Satisfaction with Informatica Enterprise Data Integration

  • 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.
We are considering their PowerCenter Advanced version which will add metadata and business glossary capabilities.

Using Informatica Enterprise Data Integration

Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.