Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Velocity transformation input format

Velocity transformation input format

You configure the format of the incoming data on the
Input Format
tab. Configure input format properties such as the input field and type, the format of the data that you want to convert, and the variable name that refers to the data in the template. If the data to be converted is binary data or is in a file, you also select the code page.
The following table describes the file input format properties:
Property
Description
Input Field
Field in the upstream transformation that contains the input for the Velocity transformation. The field that you select must contain either the data to be converted or the file path and name of the flat file that contains the data.
Since the input to the transformation must be character or binary data, this field displays only string, text, and binary fields from the upstream transformation.
Input Type
Type of data in the selected input field. Select one of the following input types:
  • Buffer. Select this option when the input field contains the data that you want to convert such as a JSON BLOB or XML string.
  • File. Select this option when the input field contains the path to a flat file that contains the data to be converted.
Format Type
Format type of the data that you want to process, either JSON or XML.
Variable Name in Template
The variable that you define in the template to refer to the data to be processed. Do not include a leading dollar sign or other special character.
For example, in the following template, the variable name "root" is used to refer to the data to be processed:
<xml> #foreach ($child in $root.getRootElement().getChildren() ) <$child.getChild("name").getText()> <id>$child.getChild("id").getText()</id> <size>$child.getChild("size").getText()</size> </$child.getChild("name").getText()> #end </xml>
The following table describes the file input format advanced property:
Property
Description
Code Page
Code page of the data that you want to convert. This field is enabled if the input type is File or if the input field contains binary data.
Select a code page if the code page of the data that you want to convert differs from the code page of the Secure Agent machine. Otherwise, select
Default
.