Integration with Informatica
April 02, 2014

Integration with Informatica

hai Mani | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version


Overall Satisfaction with Informatica Enterprise Data Integration

Informatica is used to integrate to various applications like SAP, Salesforce etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.
  • Tracking Changes in slowly changing dimensions
  • Fact & multi-dimensional loading
  • Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
  • Modularity
  • Several partnerships diminishing the value of technologies
  • Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
  • Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
  • Master data management
  • Data lineage and data archiving
  • Data discovery and profiling
  • Increased reporting strategy
Ab Initio, SSIS, Cognos
Backward Compatability.
Easy Upgrade.
Support from Vendor

Using Informatica Enterprise Data Integration

Availability of options to integrate with application oriented databases like SAP, Salesforce etc.
Product Support.