DTL overview

The Data Transformation Language (DTL) is InfoSum's custom scripting language, which can help you map your original data format onto InfoSum's Global Schema.

If you haven't read them already, our glossary topics on normalisation and transformations will explain more about the role of DTL and the requirement to transform your data.

Many transformations can be configured using your Bunker's user interface, without the need to write or understand DTL. For more advanced requirements, however, DTL offers a powerful tool to apply complex logic to your transformations.

DTL is an advanced technique. Before you decide to write a DTL script, check whether other features in your Bunker - such as mappings - might be enough to meet your needs.

How to learn DTL

First, read these articles, which bring you up to speed on the key principles of DTL.

  • Bunker and the Script Editor explains where DTL fits in the overall process of importing and normalising your data, and how you can write a DTL script inside your Bunker.
  • Language essentials gives a run-down of DTL's syntax, and how it's similar to and different from other scripting languages you may have used.
  • Three rules to remember outlines three important principles for the output of your DTL scripts, which you'll need to follow as you transform your data.

You'll then be ready to check out these tutorials - which talk you through some of DTL's main features using practical, real-world examples.

Finally, two reference articles provide technical detail on the DTL language.

  • Functions provides comprehensive information on DTL's built-in functions, which you can use for string manipulation and a few other tasks.
  • Transformations similarly lists DTL's transformations, which are the mechanism for actually changing your imported data.