Introduction to Advanced ETL Processor

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

Transformation Example

The Transformation Engine converts data from one format to another, for example, from a text file to an Excel file.

A typical transformation consists of four main components: a Reader, Validator, Transformer, and Writer. Data flows sequentially through these components from left to right, with each component performing a specific step in the transformation process.

Automation Example (Package)

An Automation Package consists of a series of actions, with each action representing a specific task—for example, copying a file, executing a SQL statement, or sending an email.

Every Automation Package has a defined starting point that determines where execution begins.

Each action can have one of two execution statuses:

• Success — the action completed successfully.
• Failure — the action encountered an error or did not meet the required condition.

Once an action completes, the next action is executed based on its Success or Failure status. This allows you to create flexible automation workflows with different execution paths depending on the outcome of each action.

Learning Our ETL Software

The best way to get started with our ETL software is to watch the video tutorials. Each video is short and focused on explaining a specific feature or function.

• For all new users, we recommend watching 002 Getting familiar with the user interface
• If your main goal is transforming the data watch 010 Creating basic ETL Transformation
• If you want to start automating your business watch 011 Creating Packages
• How to connect guides

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

Video Tutorial