Introduction: Loading Data from EXCEL file into MySQL Database

In this tutorial, you will learn how to use Advanced ETL Processor Pro workflow designer to create a simple data transformation package. The package will take the data from an Excel file, validates the data, and then inserts the data into a MySQL fact table. In the following lessons, the package will be expanded to demonstrate connections, package configurations, logging and error flow.

This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Advanced ETL Processor.

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

Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you