User`s guide

Creating your first project
22 Sybase IQ ETL 4.1
5 Select an existing project, or right-click on Projects to create a new project.
Creating your first project
This section describes how to create and simulate a sample project with sample
components. It does not explain all of the components, nor does it explain their
properties and features. For details about components, see Chapter 6,
“Components.”
A project usually contains one or more of the following:
• Data providers that provide the data feeding the project data stream
• Data transformers that transform or remap field values
• Data sinks that write the transformed values to their target
Note The results of this section can be viewed in the “Demo Getting Started”
project shipped as a demo project within your default repository.
Adding a data provider
Use one of the following methods to add a data provider to your project:
• Drag the component from the Component Store to the Design section.
• Right-click the component that you want to add and select Add from the
pop-up menu.
• Double click the component.
As soon as you add a component to the Design section, the component displays
its default configuration.
Note Properties shown in bold in any configuration window are required.
❖ To configure a data provider
1 Select ODBC from the Interface drop-down list. (See “Entering database
connection parameters” on page 71 for information about all of the
Interface types.)