The best way to become acquainted with 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 loading the data to performing complex data transformations.
We are constantly working on improving our ETL software, tutorials below may miss some latest features. They demonstrate basic principles of designing Business Intelligence solutions. Straight forward interface allows our users to create simple and practical solutions to everyday data integration problems.
- Download and install the software, here are the links to the latest version
- Watch the following online totorials, they will answer most of the questions
- Still have questions?
Advanced ETL Processor |
|
 |
 |
 |
There are several ways of of generating XML with Advanced ETL Processor: using transformation functions In Place Replace, Encode Xml Element,
Decode Xml Element, Encode Xml Attribute, Decode Xml Attribute, Encode Xml String, Decode Xml String or by using XML writer |
 |
How to verify layout of the file before importing data. First line of file holds list of fields. All processed files must have same CRC for the first line. Transformation checks CRC of first line and abort processing if it is different. |
 |
In this tutorial, you will learn how to use Advanced ETL Processor to perform simple data transformation of a text file. The following lesson explains data transformation and validation processess.
|
 |
Loading data from multiple files into MS Sql Server In this tutorial, you will learn how to use Advanced ETL Processor to perform Loading data from multiple files into MS Sql Server. |
 |
In this tutorial, you will learn how to use Advanced ETL Processor to perform star transformation. The package that you create takes data from Access Database, deduplicates ad sorts lookup data, and then inserts the result into a MS SQL Server fact table and lookup tables. In following lessons, the package will be expanded to demonstrate connections, package configurations, logging and error flow.
|
 |
In this tutorial, you will learn how to use Advanced ETL Processor to create a simple data transformation. The transformation that you create takes data from a text file, sorts the data, performs pivot transformation and then saves the data into new text file. In following lesson, the transformation will be expanded to demonstrate connection configurations, logging and error flow. |
|
|
In this tutorial, you will learn how to use Advanced ETL Processor to load data into blob fields.
"Imagine that you are an owner of very large and famous social network web site. Today you would like to load pictures of your best friends into the database. This can be easily done with Advanced ETL Processor". |
 |
Exporting Data from blob fields In this tutorial, you will learn how to use Advanced ETL Processor to export Blob Fields into Files |
All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.
