About Sybase IQ InfoPrimer

Sybase® IQ InfoPrimer provides a mechanism for extracting data from various datasources, transforming and cleaning data, and then loading it into Sybase IQ. It also lets you extract and load data from datasources into Sybase IQ, then perform a set of transformations on the data directly in the Sybase IQ target database.

Sybase IQ InfoPrimer capabilities include:

Data extraction – extract data from various datasources, including Adaptive Server® Enterprise, IBM DB2, Oracle, Microsoft SQL Server, SQL Anywhere®, Sybase IQ, MySQL, text files, and XML files.
Data transformation – convert, clean, merge, and split data streams as well as transform data already loaded into Sybase IQ.
Data loading – load data into an IQ target database using update, insert, delete, or bulk copy statements.

Sybase IQ InfoPrimer Architecture
Sybase IQ InfoPrimer includes Sybase IQ InfoPrimer Development and Sybase IQ InfoPrimer Server.
Repositories
Repositories contain all data and information related to Sybase IQ InfoPrimer objects, projects, and jobs.
Project Types
Sybase IQ InfoPrimer Development offers three different project types for creating a data transformation flow.
Schedules
Use the Runtime Manager in the Sybase IQ InfoPrimer Development interface to manage projects and jobs and see an overview of your current scheduled task.
Alerts
Set alerts to be notified by e-mail messaging of runtime events, such as project or job execution, or when an error message occurs.
Monitor
Sybase IQ InfoPrimer lets you monitor grid engines, projects, and jobs.