ETL and Data Integration tools - Modern ETL software for everyone

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

• Download and install the software, here are the links to the latest versions

Advanced ETL Processor Professional						Advanced ETL Processor Enterprise

• Watch the following on-line tutorials, they will answer most of the questions

	Advanced ETL Pro - Exporting data from MySQL Database into text files In this tutorial, you will learn how to use Advanced ETL Processor Pro to export all data from any database into text files. The package that you create takes data from a Jomla Repository (MySql) and saves all tables into separate csv files.
	Advanced ETL Pro - Loading Data from Excel file into MySQL Database In this tutorial, you will learn how to use Advanced ETL Processor Pro Designer to create a simple data transformation package. The package that you create takes data from a excel file, validates the data, and then inserts the data into a MySQL fact table. In following lessons, the package will be expanded to demonstrate connections, package configurations, logging and error flow.
	Advanced ETL Pro -Working with the Repository Avanced ETL Processor 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 cretead by running scripts or by runnig Wizard.
	Advanced ETL Pro -Working with the Lookup Object In this tutorial, you will learn how to use Advanced ETL Processor lookup object to perform data transformation.
	Advanced ETL Pro - Generating QlikView QVX files  QVX (QlikView data eXchange) is a new file/stream format for high performance data input into QlikView. A QVX formatted file contains metadata describing a table of data and the actual data. In contrast to the QVD format, which is proprietary and optimized for minimum transformations inside QlikView, the QVX format is public and requires a few transformations when exporting data from traditional data base formats..

All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

• Still have questions?