Sybase IQ InfoPrimer includes Sybase IQ InfoPrimer Development and Sybase IQ InfoPrimer Server.
IQ InfoPrimer Development – which is available only on Windows, is a graphical user interface (GUI) tool for creating and designing data transformation projects and jobs.
You can create a data transformation flow using any or all project types: Extract and Load (EL), SQL Transformation, and Extract Transform and Load (ETL).
IQ InfoPrimer Server – is a scalable and distributed grid engine that connects to datasources, and extracts and loads data to data targets using transformation flows designed using IQ InfoPrimer Development.
Note: The terms grid engine and IQ InfoPrimer server are used interchangeably in this guide.
By default, IQ InfoPrimer Development includes an embedded IQ InfoPrimer Server, which is a runtime engine that controls processing, such as connecting to databases and executing procedures. However, to perform parallel execution of jobs and projects, you must install Sybase IQ InfoPrimer Server, which is available as a separate executable.
You can add multiple servers on different operating systems within your network. All the Sybase IQ InfoPrimer Servers that you add to the grid must be registered. You can use the Engine Manager, available within IQ InfoPrimer Development interface to register servers.
Each server exposes certain services to all other peer servers. IQ InfoPrimer uses the various servers on a grid for parallel execution of projects and jobs.
IQ InfoPrimer Server connects to the destination or the source database using methods or drivers called interfaces. One of the supported interfaces, the Sybase SQL Anywhere 11 ODBC driver, which is used to connect to Sybase SQL Anywhere, is automatically installed by the IQ InfoPrimer Development installer. Sybase IQ ODBC driver, which is used to connect to Sybase IQ is packaged with the Sybase IQ 15.3 Server or Client. To install the other supported interfaces, see the respective vendor documentation.
You can monitor the Sybase IQ InfoPrimer Servers installed in your network using either the Engine Monitor or a Web browser.
You can use the Sybase IQ InfoPrimer Development interface to create schedules and alerts for projects and jobs.
