Projects consist of components and links, which connect components through their ports. There are basic operations that involve projects, such as creating, deleting, renaming, and saving, and there are complex operations, such as simulation.

A Sybase ETL project starts with one or multiple source components and ends with one or more destination components.

These are the Sybase ETL 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 IN-ports and OUT-ports, and can have adjacent components of any other type.

• If a transformation component allows multiple input data streams, multiple originating source components are required.

• If a transformation component has multiple outputs of data streams, you can connect each data stream with a component.

1. In the Navigator, right-click Projects and select New | Project. Alternatively, select File | New | Project.

2. Drag the components for the project from the Component Store onto the Design window.

1. In the Navigator, double-click the project you want to modify.

2. Make the changes and save the project.

A project locked by another user client opens in read-only mode.

1. To make the project available for reading or writing, click Unlock and Open on the window that appears when you open a locked project.

1. Double-click the project you want to copy to open it in the Design window.

2. In the Navigator, right-click the project and select Save As. Alternatively, select File | Save As.

   If you are working with multiple repositories, select the target repository.

3. Enter a name for the new project. A copy of an existing project is created, leaving the original untouched, and storing no references to the originating project.

If you are using multiple repositories, you can copy complete projects from one repository to another, maintaining references to the originating project. For example, you may want to move a project from a development repository to a test or production repository. By storing the references to its origin, the transfer recognizes the project the next time it is initiated and selectively replaces everything related to the incoming object.

1. In the Navigator, right-click the project you want to transfer and select Transfer. Alternatively, select File | Transfer.

2. Select the repository where you want the project to be transferred.

1. In the Navigator, right-click the project and select Delete.

2. Click Yes to confirm the deletion.

1. In the Navigator, right-click the project and select Rename.

2. Enter a new name for the project and click OK.

To reset loading options for incremental load:

1. In the Navigator, right-click the project, and select Reset Execution Properties.

2. Click Yes to confirm that you want to reset execution properties. The current value of the Load Index Value (DB Index Load component) is reset.