Sybase IQ InfoPrimer - An Option to Sybase IQ

Sybase IQ InfoPrimer, previously known as Sybase ETL, is now packaged and delivered as a separately licensed option to Sybase IQ 15.3, and must be installed using its own installer.

Sybase IQ InfoPrimer provides mechanisms for:

Extracting data from a datasource, transforming and cleaning the data, and loading it into a Sybase IQ data target using a comprehensive set of transformation functions.
Extracting and loading data from data sources into Sybase IQ and then performing a set of transformations on the data directly in the Sybase IQ data targets.

Sybase IQ InfoPrimer supports extracting data from multiple heterogeneous data sources namely, Adaptive Server® Enterprise, IBM DB2, Oracle, Microsoft SQL Server, Sybase IQ, SQL Anywhere®, MySQL, text files, and XML files.

Sybase IQ InfoPrimer offers these new capabilities:

Extended high speed extract and load capabilities
- Supports large objects (LOB) data from enhanced datasources namely, Sybase ASE, Oracle, Microsoft SQL Server, and files.
- Enables high-speed bulk extraction from Sybase Adaptive Server, Microsoft SQL Server, and Oracle datasources.
- Enhances support for generating LOAD TABLE commands for existing bulk- load files if they are:
  - Sybase IQ compatible binary format
  - Text files with delimited records
  - Files with fixed length values and variable length records
  - Files in Apache Web log formats (Common Log Format and Extended Log Format)
  - LOBs
  - Text files generated by the extract phase of execution.
- Continues to support XML, SQL Anywhere, MySQL, Sybase IQ, and IBM DB2 as datasources.
- Supports parallel loading and transformation of multiple tables.
- Provides better support for large tables, wide tables, and large number of tables.
- Supports incremental data changes in existing tables (insert, update, delete).
Ease of use
- Enhances repository performance.
- Enables fast and easy migration of repositories.
- Supports full initialization from source to target with and without applied transformation.
- Supports incremental loads to existing tables with and without transformation.
- Enhances life cycle management with database connection profiles.
Seamless integration with Sybase IQ
- Supports table-based, schema-based, and column-based transformation.
- Supports generation of Sybase IQ LOAD TABLE input from a variety of data sources.
- Enhances support for Insert Location capability of the Sybase IQ host.
- Enhances JavaScript-based transformation support.
- Supports multiple numbers of transformations within a single load.
- Supports multiple numbers of load or transformation jobs concurrently.
Enhanced licensing capabilities
- Supports SySAM sub-capacity licensing.

See this guide in the Sybase IQ documentation:

Sybase IQ InfoPrimer Users Guide