Class TabularEtlManager

The TabularEtlManager class is used to manage the extraction and loading of tabular data. Implements the Workspace.XBR.Xperiflow.Etl.Tabular.ITabularEtlManager interface.

Using a Workspace.XBR.Xperiflow.Etl.Tabular.TabularEtlManager, you can extract data from a source and load it into a destination in separate steps, or with a call to ExtractAndLoad(). Use the XBRApi to instantiate an Workspace.XBR.Xperiflow.Etl.Tabular.ITabularEtlManager. For example:

Example:

` var etlManager = XBRApi.Etl.GetTabularEtlManager(si); `

Example:

` var dataReader = etlManager.ExtractDataReader(sourceData); `

Example:

` etlManager.Load(destinationData, dataReader) `

• OR more simply-

Example:

` etlManager.ExtractAndLoad(sourceDataDefinition, destinationDataDefinition); `

Namespace: Workspace.XBR.Xperiflow.Etl.Tabular

Assembly: Xperiflow.dll

Declaration

public class TabularEtlManager : ITabularEtlManager

Implements: Workspace.XBR.Xperiflow.Etl.Tabular.ITabularEtlManager

Methods

ExtractDataReader(string)

Extracts data from a JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinition as an IDataReader, for example:

Example:

` var dataReader = etlManager.ExtractDataReader(jsonSource); `

Declaration

public IDataReader ExtractDataReader(string sourceDataDefinition)

Returns

System.Data.IDataReader

An IDataReader object

Parameters

Type	Name	Description
System.String	sourceDataDefinition	The JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinition object to extract data from

ExtractDataReader(DataDefinition)

Extracts data from a Workspace.XBR.Xperiflow.Etl.DataDefinition as an IDataReader, for example:

Example:

` var dataReader = etlManager.ExtractDataReader(sourceDataDefinition); `

Declaration

public IDataReader ExtractDataReader(DataDefinition sourceDataDefinition)

Returns

System.Data.IDataReader

An IDataReader object

Parameters

Type	Name	Description
Workspace.XBR.Xperiflow.Etl.DataDefinition	sourceDataDefinition	The Workspace.XBR.Xperiflow.Etl.DataDefinition object to extract data from

ExtractDataTable(DataDefinition)

Extracts data from a Workspace.XBR.Xperiflow.Etl.DataDefinition as a DataTable, for example:

Example:

` var dt = etlManager.ExtractDataTable(sourceDataDefinition);`

Declaration

public DataTable ExtractDataTable(DataDefinition sourceDataDefinition)

Returns

System.Data.DataTable

A DataTable object containing the data defined by the sourceDataDefinition

Parameters

Type	Name	Description
Workspace.XBR.Xperiflow.Etl.DataDefinition	sourceDataDefinition	The Workspace.XBR.Xperiflow.Etl.DataDefinition object to extract data from

ExtractDataTable(string)

Extracts data from a JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinition as a DataTable, for example:

Example:

` var dt = etlManager.ExtractDataTable(jsonSource);`

Declaration

public DataTable ExtractDataTable(string sourceDataDefinition)

Returns

System.Data.DataTable

A DataTable object containing the data defined by the sourceDataDefinition

Parameters

Type	Name	Description
System.String	sourceDataDefinition	The JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinition object to extract data from

Load(string, IDataReader)

Writes data from an IDataReader to a JSON serialized destination Workspace.XBR.Xperiflow.Etl.DataDefinition, for example:

Example:

` etlManager.Load(destinationJSON, reader); `

Declaration

public void Load(string destinationDataDefinition, IDataReader reader)

Parameters

Type	Name	Description
System.String	destinationDataDefinition	The JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinition object to load data into
System.Data.IDataReader	reader	The IDataReader object containing the data to load

Load(DataDefinition, IDataReader)

Writes data from an IDataReader to a destination Workspace.XBR.Xperiflow.Etl.DataDefinition, for example:

Example:

` etlManager.Load(destinationDataDefinition, reader); `

Declaration

public void Load(DataDefinition destinationDataDefinition, IDataReader reader)

Parameters

Type	Name	Description
Workspace.XBR.Xperiflow.Etl.DataDefinition	destinationDataDefinition	The Workspace.XBR.Xperiflow.Etl.DataDefinition object to load data into
System.Data.IDataReader	reader	The IDataReader object containing the data to load

Load(string, DataTable)

Writes data from a DataTable to a JSON serialized destination Workspace.XBR.Xperiflow.Etl.DataDefinition, for example:

Example:

` etlManager.Load(destinationJSON, dt); `

Declaration

public void Load(string destinationDataDefinition, DataTable dt)

Parameters

Type	Name	Description
System.String	destinationDataDefinition	The JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinition object to load data into
System.Data.DataTable	dt	The DataTable object containing the data to load

Load(DataDefinition, DataTable)

Writes data from a DataTable to a destination Workspace.XBR.Xperiflow.Etl.DataDefinition, for example:

Example:

` etlManager.Load(destinationDataDefinition, dt); `

Declaration

public void Load(DataDefinition destinationDataDefinition, DataTable dt)

Parameters

Type	Name	Description
Workspace.XBR.Xperiflow.Etl.DataDefinition	destinationDataDefinition	The Workspace.XBR.Xperiflow.Etl.DataDefinition object to load data into
System.Data.DataTable	dt	The DataTable object containing the data to load

ExtractAndLoad(DataDefinition, DataDefinition)

Extracts data from a source Workspace.XBR.Xperiflow.Etl.DataDefinition and loads it into a destination Workspace.XBR.Xperiflow.Etl.DataDefinition, for example:

Example:

` etlManager.ExtractAndLoad(sourceDataDefinition, destinationDataDefinition); `

Declaration

public void ExtractAndLoad(DataDefinition sourceDataDefinition, DataDefinition destinationDataDefinition)

Remarks

Note: This method does not support loading from and extracting to JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinitions. However, if you have JSON serialized Workspace.XBR.Xperiflow.Etl.DataDefinitions, you can instantiate Workspace.XBR.Xperiflow.Etl.DataDefinition objects using Workspace.XBR.Xperiflow.Etl.DataDefinition

Parameters

Type	Name	Description
Workspace.XBR.Xperiflow.Etl.DataDefinition	sourceDataDefinition	The Workspace.XBR.Xperiflow.Etl.DataDefinition object to extract data from
Workspace.XBR.Xperiflow.Etl.DataDefinition	destinationDataDefinition	The Workspace.XBR.Xperiflow.Etl.DataDefinition object to load data into

Implements

• Workspace.XBR.Xperiflow.Etl.Tabular.ITabularEtlManager

Inherited Members

• System.Object.Equals(System.Object)
• System.Object.Equals(System.Object,System.Object)
• System.Object.GetHashCode
• System.Object.GetType
• System.Object.MemberwiseClone
• System.Object.ReferenceEquals(System.Object,System.Object)
• System.Object.ToString