ETL: data extraction, transformation and loading

Speed, flexibility and power in data extract, transform and load

Video: Introduction

iLoader Quiterian Analytics integrated ETL (data extraction, transformation and loading), which is known for its great speed (minimum 10 GB/hour) and for extracting data from various origins in any format (Access, xls, txt, and from any database that allows a connection chain ODBC, DAO or ADO) into the Analytical Repository.

iLoader provides a wizard to assist the whole process of shaping and defining the data origin, as well as the process of generating instructions for data transformation.

It includes three loading methods:

• Refreshing an existing table
• Appending new records
• Updating modified records