Connect 11 Documentation Data Integration and Web Services Using Informatica This section describes how to do data integration using the Informatica-based Toolkit. Before You Begin Database Connections Server Configuration Sessions and Batches E-mail Notification File Wait Job Control Loading Data Pre- and Post-Session Commands The ETL Process Advanced Integrations Phase 1: Moving Data from Source Files to Staging Tables Phase 2: Moving Data from Staging Tables to the Connect Tables The Repository Backup and Restore Locks Security: Users and Folders Using Databases as Sources General Rules for Integration Overview: Using Databases as Sources Using Flat Files as Sources General Rules for Integration Key Concepts for Using Flat Files Overview: Using Flat Files as Sources Preliminary Steps Using the Mapping Designer Ports Source Files Staging Tables Target Tables Transformations