Advanced ETL Processor is a Codeless ETL Tool. It has two major components Data transformation engine and Automation engine

Transformation Example

Transformation engine converts data from one format into anther for example text file into excel file. Typical transformation consist of reader, validator, transformer and writer. Data flows from the left to the right.

Advanced ETL Processor Transformation Example

Automation Example (Package)

Automation Package consist of actions. Action represent a single step of work. For example copy file or send email. Every package has a stating point. Action has two execution statuses Failure or Success. Once action execution is completed next action is executed depending on the execution status.

Advanced ETL Processor Example

The best way to learn our ETL software is to watch video’s. They are very shot and designed to explain one function. Documentation provides more detailed information.

Please also watch the repository videos. Understanding working with the repository is extremely important.

Video Tutorial

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: August 1, 2022