Source components

Source components deliver data for a transformation stream. A project has to start with one or multiple Source components. This component type has 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.

XML via XSLT Data Provider

Applies an XSLT transformation on an XML document and outputs the results as a single column record.