Data integration and Talend Open StudioData analytics

1.1Data analytics

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 Open 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 the Talend Open Studio

Components Reference Guide. For information about their orchestration in Talend Open Studio, see Designing a data integration Job on page 57. For high-level business-oriented modeling, see Designing a Business Model on page 43.

1.2Operational integration

Operational data integration is often addressed by implementing custom programs or routines, completed on-demand for a specific need.

Data migration/loading and data synchronization/replication are the most common applications of operational data integration, and often require:

Complex mappings and transformations with aggregations, calculations, and so on due to

variation in data structure,

2Talend Open Studio