Learn how to Automate Complex Data Transformation and Related Tasks

Using Advanced ETL Processor Enterprise and Professional

The best way learn the new tools, controls and features available in Advanced ETL Processor is to use them. These tutorials walk you through various data integration tasks from exporting the data to creation complex ETL Packages.

Please: Watch the following on-line tutorials, they will answer most of the questions.

00 Learn what makes Advanced ETL Processor special

00 Learn what makes Advanced ETL Processor special

01 Introduction

01 Introduction

In this tutorial, you will learn how to use Advanced ETL Processor Pro/Ent Designer to create a simple data transformation that takes data from a excel file, validates the data, and then inserts the data into a MySQL fact table.

02 Exporting data from MySQL Database into text files

02 Exporting data from MySQL Database into text files

In this tutorial, you will learn how to use Advanced ETL Processor Pro/Ent to export all data from any database into text files. The package that you create takes data from Sakila (MySql) and saves all tables into separate csv files.

03 Creating Groups

03 Creating Groups

Short guide for beginners

04 Working with Variables

04 Working with Variables

Advanced ETL Processor Pro variables are used for dinamic tasks or passing parameters between objects. Anywhere the user can enter text the user can use variables. In the most of the cases variables are replaced with actual values before the execution of the object..

05 Global Variables

05 Global Variables

This tutorial exaplains how to use variables when same repository is used by multiple developers and production servers.

06 Creating Reports Part One

06 Creating Reports Part One

 

In this tutorial we demonstrate how to create reports and work with parameters.

This tutorial is releavant to both Advanced ETL Processor and Visual Importer ETL
07 Creating Reports Part Two

07 Creating Reports Part Two

 

In this tutorial we demonstrate how to create multiple reports and work with loop package action.

This tutorial is releavant to both Advanced ETL Processor and Visual Importer ETL
08 Loading Data Into MariaDB

08 Loading Data Into MariaDB

 

In this tutorial we demonstrate how to load data into MariaDB.

 
 09 Transforming QlikView QVD file to Tableau TDE File

09 Transforming QlikView QVD file to Tableau TDE File

 

Learn how to transform QlikView QVD file to Tableau TDE File

 
 Advanced ETL Pro - Loading Data from Excel file into MySQL Database

10 Could not find anything to load

In this tutorial we will explain how to avoid "Could not find any files to load" error

 
Advanced ETL Pro - Working with repository

11 Working with the Repository

 Advanced ETL Processor Pro/Ent stores all information in the repository. Visual Importer, Avanced ETL Processor and Active table Editor use the same repository structure so the data can be easily shared. Repository type can be MS Access, SQL Server, Oracle, PostgreSQL, MySQL. The default repository type is MS Access. Repository can be created by running scripts or by runnig Wizard.
Note: One of the most important tutorials
 
 Advanced ETL Pro - Working with Package Variables

12 Migrating Repository from one database to another

Moving repository from MS Access to Oracle, migrating it from test to production? Learn how to do it in 2 clicks.
 
 Advanced ETL Pro - generating QVX files

13 Working with sheduler and execution agent

 
Agent is used for the execution automation and scheduling. 
Advanced ETL Pro - Working with repository

14 Learn how to publish TDE file to Tableau Server

 
04 Working with Variables

15 Monitoring Directories for New files

Directory Monitor is windows service which executes predefined action when new file is added to the directory. Both local directories and network shares (using UNC path) can be monitored.


 
Advanced ETL Pro - Loading Data from Excel file into MySQL Database

16 Troubleshooting Agent and Monitors

Short tutorial for beginners

 

Please also wach the tutorias for Advanced ETL Processor Standard.

 

We are here to help and we mean it

 

 brain target boy 

Step-by-Step tutorials

Watch videos

Online Documentation

Read wiki

Support Forum

Visit Forum

Go to top