User`s guide
Projects and jobs
2 Sybase IQ ETL 4.1
Sybase ETL Server
The Sybase ETL Server provides the GRID engine service, which, by default,
processes desktop requests locally. The GRID engine is designed for massively
parallel transformation processing across operating system boundaries and
machines. To make GRID engines available for parallel execution, you must
register them in Engine Manager (see “Using multiple engines to reduce job
execution time” on page 61 for more information). The GRID engine leverages
JavaScript to extend the transformation framework across multiple operating
systems.
For more information about Sybase ETL Server and GRID engines, see
Appendix B, “Sybase ETL Server.”
Projects and jobs
A project is a collection of components, links, and transformation rules. Each
project contains one or more steps that are simulated or executed sequentially
when the project is run. When simulated or executed, the components connect
to the correct data sources where they read and transform data. A project
consists of various components that can be freely arranged on your project
desktop. You can add components to your project by simply dragging them
from a section of the Component Store onto your workspace.
Multiple projects can be run sequentially or parallel in a job. Jobs control the
order in which projects are being executed. Jobs can be scheduled and
monitored.
Component concepts
Stepping a component record-by-record
In simulation mode, many of the transformation components offer a convenient
way to step through the current set of data and visualize the result of any
applied transformation immediately.