After you have identified
your requirements, you can begin to create Data Translation Specification
(DTS) files.
DTS files enable you to quickly and accurately migrate and integrate your data by:
Connecting
source and target data stores
Defining data processing logic
Defining functions and formulas to set values in target fields, and convert and import source fields.
The DTS files you create contain the instructions or specifications
that are followed when TIBCO Scribe® Insight actually operates on your data.
Use Workbench to create DTS files and Console to include
those DTS files in Integration Processes (IP) and Collaborations.
Data translation specification (DTS) — A file that includes information about:
Source and target data stores.
Data processing logic to be used when the DTS file is run.
Formulas to link source fields to target fields, set constant values in target fields, or define matching criteria.
Formulas used to convert, parse, or import selected source fields.
As part of the planning
process, determine how many DTS files you need to support the different
objects (types of data) that are handled in this project.
To create a DTS file
For each DTS file, define
the connections to use for your DTS files using the Connection
Manager.
Create
lookup links to be used for matching with all seek,
update, or delete steps.
Create
data links to map source fields to target fields. Create formulas
on data links to transform data or to set values for target fields when
there is no corresponding source field.