IEtlPlainDataProvider

Description

The IEtlPlainDataProvider interface is used to work with a data source.

Comments

To work with the XLS, MDB, DBase provider, install the AccessDatabaseEngine_x64.exe driver if Foresight Analytics Platform (x64) is installed in x64 operating system, and Microsoft Office x64 is not installed.

Import Restrictions

If Foresight Analytics Platform (x64) is installed, Microsoft 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.

Properties

	Property name	Brief description
	FetchBlockSize	The FetchBlockSize property determines the number of processed records on using partial data sampling in source.
	PlainOutput	The PlainOutput property determines output fields list.
	Provider	The Provider property returns import or export object.
	UnpivotMode	The UnpivotMode property determines whether data is imported in the crosstab mode.
	UnpivotProvider	The UnpivotProvider property returns crosstab parameters, according to which data is identified.

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 a data source copy for editing.
	FillDefault	The FillDefault method fills fields based on data about source fields.
	FillFromSource	The FillFromSource method fills output fields based on a source file structure.
	Save	The Save method saves results of editing.

Methods inherited from IEtlObject

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

See also:

ETL Assembly Interfaces