You can specify database connection parameters in the:
Database Configuration window that appears when you add a component to the Design window, or when you double-click an existing project component.
Properties window that 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.
The available interfaces for a component can be one or more of the following:
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
Use SQLite Persistent for your test environment only.
Do not use it in a production environment.
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 the project is to be executed on an ETL Server, the
ETL Server must also have access to Open Client libraries.
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/owner to restrict the objects displayed and create new tables in that schema.
Standardize Data Formats – select this option to convert incoming date and number information into a standard format, which Sybase ETL can move between systems that support different formats.
Database options – Select this options to override performance defaults and control the behavior of some transactions. For a list of database options, see “Interface specific database options”.
