Source Components
Source components deliver data for a transformation stream.
A project typically starts with one or more source components. Source
components have no IN-ports and at least one OUT-port.
- DB Data Provider Full Load
DB Data Provider Full Load is a Source component that extracts data from any datasource that is accessible by an ODBC connection or native driver (DB2, Oracle, Sybase), or from Microsoft SQL Server via OLE DB. The structure of the single output port mirrors the structure of the query result set.
- DB Data Provider Index Load
DB Data Provider Index Load is a Source component that performs incremental data loads based on an ascending index value. During execution, DB Data Provider Index Load ignores any previously extracted data records.
- Text Data Provider
Text Data Provider reads and transforms structured data from a text file into a table. The text source must contain fixed-length or delimited fields.
- XML Via SQL Data Provider
The XML via SQL Data Provider component loads hierarchical XML data into a relational schema that you can query like a relational database.
- CDC Provider Sybase Replication Server
The CDC (Capture Data Changes) Provider Sybase Replication Server component is used for implementing incremental load.
Created May 24, 2011. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com