A Powerful ETL Tool in Informatica PowerCenterhttps://www.trustradius.com/data-integrationInformatica Enterprise Data IntegrationUnspecified8501012013-10-09T18:12:48.309Z
October 09, 2013
A Powerful ETL Tool in Informatica PowerCenter
Score 8 out of 101
- 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.