Selecting Data Consumer

Appearance of the Data Consumer page on selecting the consumer of this type is given above.

Specify parameters:

Set Up Connection. Click the button. The dialog box to set up connection to the Oracle database opens, to which the data is saved. For detailed information about working with the dialog box refer to Windows help.
Table. Specify the database table, to which the data is loaded.

Clear Consumer Before Loading Data. It determines whether all information should be deleted from consumer before loading data. By default this checkbox is selected, and the consumer is cleared before loading data.

Data consumer parameters match the parameters for the consumer of the Microsoft OLEDB Provider for Oracle type.

Specify parameters:

NOTE. Driver selection is available only for the files in the XLS format.

Specify parameters:

File. Specify the Microsoft Access database file, to which the data will be loaded.
Table. Specify the database table, to which the data will be loaded.
Clear Consumer Before Loading Data. It determines whether all information should be deleted from consumer before loading data. By default this checkbox is selected, and the consumer is cleared before loading data.

Specify parameters:

File. Specify XML file, to which the data will be loaded.
File Format. Specify the data format, which is used to load data to an XML file:
- Fields in Nodes. Fields are given as child nodes.
- Fields in Attributes. Fields are shown as attributes.
Root Name. Specify the name of the root elements in the XML file.
Data Node Name. Specify the name of the element, to which the data will be loaded.
Clear Consumer Before Loading Data. It determines whether all information should be deleted from consumer before loading data. By default this checkbox is selected, and the consumer is cleared before loading data.

Specify parameters:

Text File. Specify the file, to which the data will be loaded.
Each row of the file is a set of fields separated from each other by the separator character. Beginning and end of field text is marked with a qualifier.
Encoding. Specify file encoding.
Export Fields Headers. To load field names to the file, select this checkbox. By default the checkbox is deselected, and only data is loaded to the file.
Row Delimiter. Select or enter the symbol, separating rows in the file.
Column Delimiter. Select or enter symbol, separating columns in the file.
Text Qualifier. Select or enter the symbol limiting columns in the file.
Clear Consumer Before Loading Data. It determines whether all information should be deleted from consumer before loading data. By default this checkbox is selected, and the consumer is cleared before loading data.

Parameters to Set Up Data Consumers of Different Types