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 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.
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).
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.
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.
Supports SySAM sub-capacity licensing.