User`s guide

Overview
72 Sybase IQ ETL 4.1
• ODBC
Note The ODBC driver must be installed on the same machine as
Sybase IQ ETL Development desktop and a system data source name
(DSN) must be defined for the target. If the component is to be sent to
an ETL Server, then the ETL Server must also have access to the
proper ODBC drivers and DSN.
• Oracle
2 Click the Host Name list and select one of the available host names.
If you are interfacing to a SQLite Persistent interface, you can enter a
database file name.
3 Enter a valid database user and password combination for your connection
if required.
The value provided for the password is encrypted and saved permanently
to avoid repetitive entry.
4 Click Query to open the Query dialog box. (Refer to Chapter 5,
“Advanced Concepts and Tools” for a detailed description of the Query
Designer/Content Explorer.)
5 In the Database field, enter a database name, if required.
6 In the Schema field, enter a database schema name, if required.
7 Activate the standardize data format option.
When you activate the Standardize Data Format in a Data Provider
component, incoming DATE and NUMBER information is automatically
converted into a standardized format (Date: CY-M-D H:N:S.s; Example:
2005-12-01 16:40:59.123; Numbers with a '.' as decimal separator). This
allows to automatically move and convert this format sensitive
information between systems using different DATE and NUMBER
information.
When activated in a Data Sink component, the component expects to
receive all data in attributes of the datatypes DATE or NUMBER in the
standardized data formats. The data sink component then automatically
converts from the standardized data format to the native format of the
connected database system.
8 Click Edit to open the Database Options dialog box and select the database
options.