IEtlPlainDataConsumer

Description

The IEtlPlainDataConsumer interface is used to work with data consumer.

Comments

To work with providers XLS, MDB, DBase in OS x64 bit version it is necessary to have following drivers:

The AccessDatabaseEngine_x64.exe driver must be installed, if a x64 OS and Prognoz Platform 9 x64 are used, and MSOffice x64 is not installed.
The AccessDatabaseEngine.exe driver must be installed, if a x64 OS and Prognoz Platform 9 x86 are used, and MSOffice x86 is not installed.
If OS x64, Prognoz Platform 9 x64 and MSOffice x86 (or x86 driver) are used, import does not work - error message is displayed. In this case only reinstall of MSOffice will help.
With combination of OS x64, Prognoz Platform 9 x86, and MSOffice x64 (or x64 driver) only import from *.xlsx does not work - it is a driver feature.

If MS Office is not installed and corresponding provider is not found, the message "OLE DB provider Microsoft.ACE.OLEDB.12.0 is not found" message is displayed.

Properties

	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 used to find identical records in a source and consumer.
	PlainInput	The PlainInput property determines input fields list.

Properties inherited from IEtlObject

	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.

Methods

	Method name	Brief description
	Edit	The Edit method creates 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.

Methods inherited from IEtlObject

	Method name	Brief description
	Remove	The Remove method removes ETL task object.