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.
Assign the columns of the input source to the respective columns of tUniservRTMailBulk. For this purpose, select a column of the input source and drag it onto the appropriate column on the right side. The meaning of the individual arguments is described in the Uniserv user manual mailRetrieval.
Click OK to close the window.
Double-click tUniservRTMailBulk to open its Basic Settings view.
Fill in the server information and specify the service.
Select Advanced Settings to adapt the server parameters.