Advanced ETL Processor

Getting started with Advanced ETL Processor

Getting Started with Advanced ETL Processor, covering installation, configuration, repositories, the user interface and the basics of creating ETL transformations and automation packages.

Connections

Connections documentation covering database, cloud, email, message queue and other connections used to integrate data sources and systems.

Options List

Comprehensive list of Advanced ETL Processor options and settings

Importing Data

Advanced ETL Processor Importing Data documentation covering import scripts and guides for importing data from databases, Excel, CSV, text files and other data sources.

Block Transformation

Block transformation is used to restructure or convert complex Excel files into a simpler and more user-friendly format

Transformation Objects

Comprehensive list of Transformation Objects

Transformation Functions

Comprehensive list of Transformation Functions

Validation Rules

Comprehensive list of Validation Rules

Packages

Advanced ETL Processor Packages documentation covering dynamic and legacy package actions, action parameters, automation workflows and package examples.

Automation

Learn how to automate workflow and data transformation execution

Advanced

Advanced ETL Processor documentation covering reports, SQL scripts, lookups, scripting, reusable objects, dynamic file names, regular expressions and repository management.

Event Monitors List

Event monitor waits for a certain event to happen (for example new file arrival into the directory) and when it does happens it executes a predefined task.