The Transformation is to be applied to each of the xml files in the FILELIST.

  1. Select the Transformations tab (top left). In the list of Transformations shown, select your tutorial map (iiiTUTMAP) and add it to the Processing Sequence after the Loop. Your Transformation should be nested within the Loop construct. If you select the *** End of processing sequence *** text before dropping the transformation map into the processing sequence editor, you'll ensure the Loop is placed at the end.

    You may use the Promote  or Demote  buttons on the tool bar to adjust the level of nesting.
  2. Select the Transform in the sequence details. The parameters for this Transformation will then be shown in the Parameters tab (bottom right). Against these parameters, you need to identify which values and variables are to be used.
  3. For the SourceFileName, set the Variable or value for the parameter to &THISFILE. You may select a variable from the Variables tab (top left) and drag and drop it onto the Variable or value for the parameter.
  4. For the BatchNumberSourceParameter set the Variable or value for the parameter to iii123. For the input Batch Number for this tutorial, use a constant value of iii123.
  5. For the DBTargetConnection set the Variable or value for the parameter to the name of the DataBase Connection Id you created in LIC003, Step 7. Set up the Database Configuration (iiiTUTDBID). You may also select the configuration from the Configurations tab (top left) and drag and drop the required configuration onto the Variable or value for the parameter.
  6. Save your Processing Sequence.