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.

NOTE. If Foresight Analytics Platform (x64) is installed, Microsoft Office is not installed, and the corresponding provider is not found, the message is displayed: OLE DB provider Microsoft.ACE.OLEDB.12.0 is not found.

The following data providers can be specified in the Provider property:

• Repository provider (table MDM dictionary).

• Import from Access.

• Import from Visual FoxPro.

• Import from Dbase.

• Import from Paradox.

• Import from Excel.

• Import from XML.

• Import from Web.

• Import from text.

• Import from OLE DB.

• Custom provider.

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.
	Task	The Task property returns the ETL task, in which an object is created.

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