Creating DTS Files

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:

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.

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

  1. For each DTS file, define the connections to use for your DTS files using the Connection Manager.
  2. Configure your source using a query to filter source data, if necessary.
  3. Configure your target using steps to define the data processing logic.
  4. Create lookup links to be used for matching with all seek, update, or delete steps.
  5. 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.
  6. Save your DTS file.
  7. Test your DTS file to make sure you are getting the results you expect from your design.
  8. If you want your DTS file to run automatically, add an IP to run your DTS file for you.

See also

About Connections

Creating A Collaboration

Links tab

Managing Integration Processes

Planning Tips