The IEtlPlainDataConsumer interface is used to work with a data consumer.
To work with XLS, MDB, DBase providers in x64 OS, it is necessary to have the following drivers:
Install the AccessDatabaseEngine_x64.exe driver if x64 OS is used, Foresight Analytics Platform and x64 MS Office is not installed.
If x64 OS, Foresight Analytics Platform and x86 MSOffice (or x86 driver) are used, import does not work, and an error message is displayed. In this case only reinstall of MSOffice will solve the problem.
If MS Office is not installed and the corresponding provider is not found, the message "OLE DB provider Microsoft.ACE.OLEDB.12.0 is not found" is displayed.
The following data consumers can be specified in the Consumer property:
Property name | Brief description | |
ClearConsumer | The ClearConsumer property determines whether it is necessary to clear a consumer before adding records. | |
Consumer | The Consumer property returns import or export object. | |
KeyFieldNames | The KeyFieldNames property determines fields to find identical records in a source and a consumer. | |
PlainInput | The PlainInput property determines input fields list. |
Property name | Brief description | |
ConnCompId | The ConnCompId property determines index of connected component of ETL task object. | |
Description | The Description property determines description (annotation) of ETL task object. | |
Id | The Id property determines identifier of ETL task object. | |
InputType | The InputType property returns input type of ETL task object. | |
IsActive | The IsActive property returns whether an object is included into ETL task. | |
Name | The Name property determines name of ETL task object. | |
ObjectType | The ObjectType property returns type of ETL task object. | |
ObjectTypeName | The ObjectTypeName property returns a name of ETL task object type. | |
OutputType | The OutputType property returns output type of ETL task object. | |
Task | The Task property returns the ETL task, in which an object is created. |
Method name | Brief description | |
Edit | The Edit method creates a data consumer copy for editing. | |
FillDefault | The FillDefault method fills fields based on data about consumer fields. | |
Save | The Save method saves results of editing. |
Method name | Brief description | |
GetControlledObjects | The GetControlledObjects method returns the collection of descriptions of repository objects controlled by the current ETL task object. | |
Remove | The Remove method removes ETL task object. |
See also: