Source components

Source components deliver data for a transformation stream. A project must start with one or more source components. Source components have no IN-port and one or more OUT-ports.

Component

Description

DB Data Provider Full Load

Extracts data from any data source accessible by an ODBC connection or a native driver (DB2, Oracle, Sybase)

DB Data Provider Index Load

Performs incremental data loads. The incremental load is controlled by an Ascending Index attribute that contains the ascending values.

Text Data Provider

Reads and transforms structured data from a text file into a table.

XML via SQL Data Provider

Loads hierarchical XML data into a relational schema.