A Powerful ETL Tool in Informatica PowerCenter
Overall Satisfaction with Informatica Enterprise Data Integration
Pros
- 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.
Cons
- 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.
Comments
Please log in to join the conversation