Informatica is a powerful ETL tool
Use Cases and Deployment Scope
We use Informatica Cloud Data Integration for a number of things. We use it to retrieve files from and SFTP and import records into our CRM. We use it to create reports that combine data from multiple systems that are otherwise not connected. We also use it to update records within our CRM based on criteria. Most of the processes are executed by automated jobs running on a schedule.
Pros
- Transform and format data
- Match and merge data
- Very flexible scheduling options for automated tasks
Cons
- There is a moderately steep learning curve
- Has some idiosyncrasies
- Can be finicky with date formats
Return on Investment
- Informatica allows our system administrators to perform numerous data tasks without having to engage developers.
- Scheduling functionality is a huge time saver. Email notifications alert us to any errors encountered.
- Reduces duplicate records and manual cleanup
Usability
Alternatives Considered
DemandTools
Other Software Used
FormAssembly, Salesforce Sales Cloud, TargetX, from Liaison, DemandTools
