A powerful Data transformation language similar to Pascal is embedded in all our ETL and Business automation tools.

It can be used with Calculation Transformation Function, Package Script Action or inside any text object

:Transforming data using calculation function


Click on thumbnail to see the screenshot

Embedded Data Transformation Language Embedded Data Transformation Language Embedded Data Transformation Language

Performance considerations

New users tend to rush using the scripting language.  Integrated transformation and validation functions offer much better performance and a lot of flexibility. The scripting language must be used as a last resort. If some function is missing please post your suggestion on our support forum. We would be happy to add it for you.

Next: The Basic Structure