DB Data Provider Full Load

DB Data Provider Full Load extracts data from any data source accessible by an ODBC connection or a native driver (DB2, Oracle, Sybase). This component issues a query against the data source to retrieve the data. The structure of the (single) output port mirrors the structure of the query result set.

DB Data Provider Full Load is one of the source components that initiates the transformation process. You can use this component whenever the source database has a relational structure and is accessible through a supported driver.