|
Sun Documentation -
System Administration
|
|
Page 1 of 2 Transfer Desk provides the SunSystems user with an interface to SunSystems Connect. Using Transfer Desk, data can be imported from or exported to flat format or hierarchical structure files, or data can be moved within the SunSystems database. During a Transfer Desk transfer process, data values can also be changed. The native format of data understood by SunSystems Connect is SSML. This is a structured hierarchical definition of SunSystems data, in industry standard XML. If data is to be transferred from or to an external format file (i.e. not in SSML format), Transfer Desk provides the ability to define that format and map it to SSML format. Using these definitions, the data is transformed from or to the external format, during the transfer process. Transfer Desk transfers are set up using three applications: - TFD - Transfer File Designer
- TXD - Transformation Designer
- TPD - Transfer Profile Designer.
|
TFD - Transfer File Designer
In Transfer File Designer you create external file format definitions, which are then available to Transfer Profile Designer and Transformation Designer as a source or target data type. You can define any flat or hierarchical data layout, also called a schema. These are defined in an XML scripting language with pre-defined syntax. Refer to the Help for details of the syntax.
TXD - Transformation Designer
In Transformation Designer, you create transformation records for specific source and target data types. The source or the target may be an external file format, created in Transfer File Designer. Transformation records are then available to Transfer Profile Designer. Transformations define how external format and SSML format data map to each other, and how data values should be manipulated during a transfer process. They can be defined using several different scripting languages:
- TML – Transformation Language. An XML scripting language with pre-defined syntax and a set of commands. Refer to the Help for details of the syntax and commands.
- JavaScript
- XSL – Extensible Scripting Language. An industry standard XML format scripting language.
|
JavaScript can also be incorporated into TML scripts.
Transfer Profile Designer
In Transfer Profile Designer, you create profiles that will be available to users to run in Transfer
Desk. Transfer Profiles define:
- Whether a transfer process is an export, an import or an internal transfer.
- What the source and target data types are. These can be SSC components, or they can be external file formats defined in Transfer File Designer.
- What the run-time parameter values are, and whether the user can enter or change them at run-time.
- What transformation is to be carried out during the transfer process. Transformations are only available to attach to a profile, if they use the same source and target data type as those selected on the profile.
|
If the source and the target are the same SSC data type, a system transformation can be attached to the profile. This will not carry out any changes to data values.
|
Sun Documentation 
