Home

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.

The best way to become acquainted with the new tools, controls and features available in Advanced ETL Processor Pro is to use them. This tutorial walks you through Data transformation to create a simple ETL package.

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, that means you can load your data today and solve all the data quality problems right now.

 

Testimonials

I had my first upload running within 10 minutes of installing Visual Importer ETL

Gene Kovacs,
Director of Technical Business Operations,
A2B

Our customers

BP

BBC

HSBC


Databases we work with

Go to top