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 (x64) and x64 MS Office is not installed.
Install the AccessDatabaseEngine.exe driver if x64 OS is used, Foresight Analytics Platform (x86) and x86 MS Office is not used.
If x64 OS, x64 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.
With combination of a x64 OS, x86 Foresight Analytics Platform, and x64 MSOffice (or x64 driver), the data cannot be imported only from *.xlsx files, it is a driver feature.
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:
Repository consumer (cube, table MDM dictionary).
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 | |
Remove | The Remove method removes ETL task object. |
See also: