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.

Note:

The configured project can be used within a job that would use the EL project to load data into Sybase IQ, and one or more SQL Transformation projects to transform the data and load them into the final destination tables.

From the Navigator, right-click Extract and Load Projects, and select New > Extract and Load Project to start configuring an EL project.

Defining a Datasource
Define the datasource in the Source tab.
Defining a Data Destination
Define the data destination in the Destination tab.
Reviewing the Source and Destination Table Details
Verify the source and destination table details in the Tables tab.
Specifying Processing Details
View a list of executables commands or scripts to be executed.
Specifying Advanced Options
Specify how you want to execute the project in the Advanced tab.
Configuring Replication Server
Enter the configuration details for Replication Server in the Replication Server tab, if you have selected to load data using Replication Server materialization.

Parent topic: Extract and Load (EL) Projects