Specify database connection parameters in the:
Database Configuration window, which appears when you add a component to the Design window, or when you double-click an existing project component.
Properties window, which appears when you select a project component in the Design window.
The database connection parameters are:
Interface – select the method or driver you want to use to connect to the destination or source database. To set special database options, click the Database options icon.
Sybase Open Client™ must be installed on the
same computer as Sybase ETL Development, and the database server
must be defined in the %SYBASE%\ini\sql.ini file
on Windows, and in the $SYBASE/interfaces file
on UNIX and Linux. If you are executing a project on an ETL Server, the
ETL Server must also have access to Open Client libraries.
The available interfaces for a component can be one or more of:
Sybase
ODBC – the ODBC driver must be installed on the same computer as Sybase ETL Development, and a system data source name (DSN) must be defined for the target. If the project is to be executed on an ETL Server, the ETL Server must also have access to the proper ODBC drivers and DSN.
OLE DB
Oracle
DB2
SQLite Persistent
Host Name – select the source or destination database. The options that appear on the Host Name list depend on the interface you selected.
If you selected the SQLite Persistent interface, you
can enter an existing or new database file name. See “Connecting to a SQLite database”.
Database user name and password – specify the authorized database user name and password.
Database name – specify the database you want to use as the source or destination database.
Database schema – specify schema or owner to restrict the objects displayed and create new tables in that schema.
Standardize Data Formats – convert incoming date and number information into a standard format, which Sybase ETL can move between systems that support different formats.
Database options – override performance defaults and control the behavior of some transactions. For a list of database options, see “Interface-specific database options”.
