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.
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.
Select tMysqlInput and then click OK to close the dialog box.
The component is then displayed in the workspace.
Drag the following components from the Palette into the design workspace: tMap and tUniservRTMailBulk.
Connect tMap with tUniservRTMailBulk first.
Accept the schema from tUniservRTMailBulk by clicking Yes on the prompt window.
Connect the other components via Row > Main.
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.