Projects are the working units of Sybase ETL Small Business Edition. A project consists of components and links, which connect components through their ports. There are basic operations that involve projects (such as creating, deleting, renaming, saving) and there are complex operations like simulation.
A Sybase ETL Small Business Edition project starts with one or multiple source components and ends with one or more destination components.
The following list summarizes the components:
A Data Provider component is usually connected to a Transformation component, a Processing component, or a Data Sink component.
Transformation components and Processing components have input and output ports and can have adjacent components of any type.
If a Transformation component allows multiple input data streams, multiple originating Source components are required.
If a Transformation component has more than a single output of data streams, each data stream can be connected with a component.
To create a project
Select New | Project from the File menu. You can also right-click a project, job, or template in the Navigator and select New | Project.
Drag components from the Component Store onto the Design section as your project requires it.
To execute a project, right-click the project in the repository and select Execute from the pop-up menu.
To modify a project, double-click the project name in the Navigator section. The project opens and you can make changes.
If a project is locked, the project can generally be opened in read-only mode. To make a project available for read/write access, select Unlock.
To copy a project or job, you can select it from the Navigator tree, right-click, and select Save As.
If you select Save As, you create a copy of an existing project or job, leave the original untouched, and store no reference to the originating project or job.
The Delete command deletes a project from a repository. To delete a project, right-click it in the Navigator section and select Delete from the pop-up menu.
Use the Rename command to rename the current project.
Resets the current value of the Load Index Value (DB Index Load component). This is used to reset loading options for incremental load.
