User`s guide

CHAPTER 6 Components
User’s Guide 71
Setting up a component
Each component is dedicated to a specific task and therefore incorporates task-
specific features. However, all components that connect to database objects
follow the same procedure to set up the database connection parameters. This
chapter summarizes common characteristics that are available for most
components. When in doubt, refer to the detailed description of the specific
component later in this chapter.
Entering database connection parameters
When you add a component with database connection properties to the Design
section, the Database Configuration dialog box is opened. The dialog box gives
you a central place to enter the most common parameters to set up a
connection. More parameters are available in the Property section once the
Database Configuration dialog is completed. This section explains all
properties of a data provider component.
❖ To enter parameters
1 Click the Interface arrow to select one of the following types of database
interfaces:
• Sybase
Note Sybase Open Client must be installed on the same machine as
Sybase IQ ETL Development desktop and the ETL Server must be
defined in the sql.ini file. If the component is to be sent to an ETL
Server, then the ETL Server must also have access to Open Client
libraries.
• SQLite Persistent
Note Sybase IQ ETL ships with a built-in, general purpose, relational
database that is based on SQLite (www.sqlite.org).
•IBM DB/2