This tutorial shows the basic ETL transformation flow in Advanced ETL Processor: read source data, map fields, transform where needed, and write the result to a target. It is the ETL equivalent of learning where the brake pedal is before joining motorway traffic.
What You Will Learn
- Create a basic ETL transformation.
- Connect a source and target.
- Map fields between source and destination.
- Run and review a simple transformation before automating it.
Before You Start
Create a repository and at least one source or target connection first. A transformation without data is mostly a diagram with ambition.
Transforming Data Docs
This tutorial matches the Transforming Data getting started guide. Start there when you need the basic map: reader, transformation screen, mapping, and writer.
The docs explain the transformation step and link to the mapping screen overview. That screen is where most first transformations either become useful or become modern art.
Related references include the Reader, Transformer, Validator, and Writer sections.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.