Sybase IQ ETL includes Sybase IQ ETL Development and Sybase ETL Server.
Sybase IQ ETL Development is a Graphical User Interface (GUI) tool for creating and designing data transformation projects and jobs. This tool provides a complete simulation and debugging environment, designed to speed the development of ETL transformation flows. It includes a runtime engine that controls the actual processing, such as connecting to databases and executing procedures. It is available only on Windows.
Sybase ETL Server is a scalable and distributed grid engine, which connects to data sources, and extracts and loads data to data targets using transformation flows, which are designed using Sybase IQ ETL Development.
You can add multiple ETL servers on different operating systems within your network. Each server exposes certain services to all other peer servers. Sybase IQ ETL uses the various servers on a grid for parallel execution of projects and jobs, which improves scalability of transformation speed. See Chapter 6, “Sybase ETL Server.”
For parallel execution of projects and jobs developed
using Sybase IQ ETL Development, you must install the Sybase ETL Server,
which is available as a separate executable.
To make ETL servers available for parallel execution, register them in the Engine Manager. See “Using multiple engines to reduce job execution time”.
To monitor multiple servers on a grid, use the Engine Monitor. See “Engine Monitor”.
The terms grid engine and ETL Server are used interchangeably
in this guide.
The interfaces are methods or drivers that you use to connect to the destination or the source database. Out of the supported interfaces, ODBC driver used for connecting to Sybase IQ is automatically installed by Sybase ETL. To install the other supported interfaces, see the respective vendor documentation.