Advanced ETL Processor uses the Writer object to finish the transformation by loading data into a file, database, or external system. Without a Writer, the transformation may look busy, but it has nowhere to put the results. Very ETL. Very dramatic.
What You Will Learn
- Understand why each transformation needs at least one Writer object.
- Choose a target type before configuring Writer properties.
- See how the Universal Data Writer supports files, databases, and external systems.
- Keep output settings separate from Reader and Transformer work.
Before You Start
Use a small output target first. If the file path or table permissions are wrong, it is better to find out before the overnight job starts writing strongly worded log entries.
Universal Data Writer Docs
The Data Writer documentation explains how the Writer sends transformed data to a selected destination.
Start with Supported Data Targets when choosing where the output should go. Writer options change depending on whether the target is a file, database, or external system.
Use Writer Targets for the full target list, then pair this page with the Reader, Transformer, and Validator docs for the full transformation flow.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.