Define mapping between source and target

This documentation describes how to use Design Server to define mapping between source and target.

About this task

This task introduces the concepts you will use to define mapping between a source and a target. Such mapping can be accomplished in multiple ways, however, the following requirements remain constant:
  • For each input, a connection to the source resource must be defined and action properties must be defined, in order to determine how the data is read from the source.
  • For each output, a connection to a target resource must be defined and action properties must be defined, in order to determine how data is written to the target.
  • For each input and output, a schema must be specified to specify the format of the data.

Procedure

  1. On the Design Server Welcome page, create a new project, or select an existing project to open the main Design Server workspace.
  2. Upload a file containing input data by clicking on Files > New.
  3. Create a schema that describes the data in the input file by clicking on Schemas > New
  4. Click on Connections to create a source action to read from the input file.
    1. Select the File connection, and then select New Action from the context menu.
    2. In the Action Type section, select Source as the Direction, then click Next.
    3. In the Properties section, select the file that you uploaded from the File Path drop down list, then click Next.
    4. In the Schema section, select the file that you created and select the root type in the Schema Type drop down list, then click Next.
    5. In the Identification section, name your action. Optionally, you can provide a description, search tags and a folder.
  5. Create a schema that defines the output data.
  6. Create a target action to write to an output file. Follow the same steps as for a source, but select Target as the Action Type.
  7. Create a new map by clicking Maps > New.
  8. Add the source action to the map by navigating to Connection > Files<source_action>, and then selecting Add to Map from the context menu.
  9. Add the target action to the map by navigating to Connection > Files<target_action>, and then selecting Add to Map from the context menu.
  10. To map from a source you must add the source to the mapping area. To do this, click on the context menu for the source in the Map Structure panel, and then click on Add. The input is added to the mapping area..
  11. Expand the schemas for input and output in the mapping area, and define your mapping by dragging types from the source fields to the output fields. More complex mappings can be defined by clicking on the output rules, or icons, to bring up the rule editor.
  12. Click Save on the toolbar to save the map.
  13. Click the Build icon to build the map. You will receive a success message if the build is successful. If it is successful, continue with the next step.
  14. Click Run to run the map.
  15. After running the map, the Results panel appears. Click on inputs or outputs to view the data, trace or audit for the specific input and output.