Sybase IQ InfoPrimer Development offers three different project types for creating a data transformation flow.
The Extract Load (EL) Project – extract data from any supported datasource and load the data into a Sybase IQ database.
SQL Transformation Project – create a transformation project that models the data transformation and generates executable transformation SQL for Sybase IQ. This project type is specialized to perform SQL transformations where the source and target are both on the same instance of Sybase IQ.
Extract Transform and Load (ETL) Project – extract data from multiple heterogeneous datasources, apply a series of transformation rules or functions to the extracted data to derive the data for loading into the end target, and load it into one or more Sybase IQ data targets.
ETL and SQL Transformation projects are both collections of components, links, and transformation rules. Each project contains one or more steps that are executed sequentially when the project is run. ETL and SQL Transformation projects consist of various components and links, which connect components through their ports. These components are stored in the Component Store and each of them is dedicated to a specific task, and incorporates task-specific features. The ETL project components connect to various datasources from which they read data to transform based on the transformation rules.