While mostly invisible to users of the BI platform, ETL processes retrieve the data from all operational systems and pre-process it for the analysis and reporting tools.
Talend Studio offers nearly comprehensive connectivity to:
Packaged applications (ERP, CRM, etc.), databases, mainframes, files, Web Services, and so on to address the growing disparity of sources.
Data warehouses, data marts, OLAP applications - for analysis, reporting, dashboarding, scorecarding, and so on.
Built-in advanced components for ETL, including string manipulations, Slowly Changing Dimensions, automatic lookup handling, bulk loads support, and so on.
Most connectors addressing each of the above needs are detailed in Talend Open Studio Components Reference Guide. For information about their orchestration in Talend Studio, see Designing a Job. For high-level business-oriented modeling, see Designing a Business Model.