Extract and Load (EL) Projects

The Extract and Load (EL) project is a multipurpose project for designing high-speed bulk extraction and bulk-loading processes.

The EL Project allows you to extract data from any of the supported datasources and load it into a Sybase IQ database.

An EL project facilitates loading multiple tables from a single database source or from multiple files. Sybase recommends that you use the EL project for migrating data from Oracle, Adaptive Server Enterprise, Microsoft SQL Server, flat files, and other supported datasources to a Sybase IQ database.

The EL project supports loading data into Sybase IQ from any of these supported file types:

Sybase IQ compatible binary format
Text files with delimited record values (including Apache Web log formats)
Files with fixed length values and variable length records
Large objects (LOBs)

Note: Files with fixed-length values and fixed-length records are not supported. For this particular file type, use ETL project instead.

Extracting LOB data is only supported for enhanced datasources namely, Adaptive Server Enterprise, Oracle, Microsoft SQL Server, and LOB files (binary files or character files).

Configuring an EL Project
To configure an EL project define a datasource and the data destination, then select the tables to be extracted and loaded into Sybase IQ.
Configuring a File Format
Use the File Format Editor to configure file formats. The different types of configurable file formats are text files with delimited record values (includes Web Log format), files with fixed-length values and variable length records, IQ binary, and large objects.
Setting Project Properties
Set evaluation, externalization, and encryption property options for the EL project.
Runtime Variables
Use runtime variables to parametrize the executables commands or scripts in the Processing tab or to specify archive paths in the Source and Advanced tabs.