Scenario: Creating an index pool - 6.1

Talend Components Reference Guide

English (United States)
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
Talend Studio
Data Governance
Data Quality and Preparation
Design and Development

This scenario describes a batch job that loads the address list of an SQL database into the index pool.

The database for this scenario is already saved in the Repository, so that all schema metadata is available.

  1. In the Repository view, expand the Metadata node and the directory in which the database is saved. Then drag this database into the design workspace.

    The dialog box below appears.

  2. Select tMysqlInput and then click OK to close the dialog box.

    The component is then displayed in the workspace.

  3. Drag the following components from the Palette into the design workspace: tMap and tUniservRTMailBulk.

  4. Connect tMap with tUniservRTMailBulk first.

    Accept the schema from tUniservRTMailBulk by clicking Yes on the prompt window.

  5. Connect the other components via Row > Main.

  6. Double-click tMap_1 to open the schema mapping window. On the left is the schema of the database file and on the right is the schema of tUniservRTMailBulk. At the bottom is displayed the Schema Editor, where you can find the attributes of the individual columns and edit them.