Class OneStreamSqlTabularLoader

A concrete implementation of Workspace.XBR.Xperiflow.Etl.Tabular.ITabularLoader that loads tabular data into a OneStream SQL Database. The OneStreamSqlTabularLoader uses a [Workspace.XBR.Xperiflow.Etl.OneStreamSqlConnectionContext](../Xperiflow.Etl/OneStreamSqlConnectionContext.md) and [Workspace.XBR.Xperiflow.Etl.TableDataContainerContext](../Xperiflow.Etl/TableDataContainerContext.md) to create and load data into a SQL table.

Namespace: Workspace.XBR.Xperiflow.Etl.Tabular

Assembly: Xperiflow.dll

Declaration

public class OneStreamSqlTabularLoader : ITabularLoader, ILoader<IDataReader>

Implements: Workspace.XBR.Xperiflow.Etl.Tabular.ITabularLoader, Workspace.XBR.Xperiflow.Etl.ILoader<System.Data.IDataReader>

Methods

GenerateCreateTableSql(IDataReader, string)

Creates an SQL Command to create a table based on the schema of the provided IDataReader and table name.

Declaration

public static string GenerateCreateTableSql(IDataReader dataReader, string tableName)

Returns

System.String

A string containing the SQL Command to create the table

Parameters

Type	Name	Description
System.Data.IDataReader	dataReader	The IDataReader object used to define the table schema
System.String	tableName	The name of the table to create

Load(IDataReader)

Writes the data from the provided IDataReader to the OneStream SQL Database.

Declaration

public void Load(IDataReader payload)

Remarks

This method will throw an exception if the table already exists in the database

Parameters

Type	Name	Description
System.Data.IDataReader	payload	The IDataReader object containing the data to write to the OneStream SQL Database

Implements

• Workspace.XBR.Xperiflow.Etl.Tabular.ITabularLoader
• Workspace.XBR.Xperiflow.Etl.ILoader<System.Data.IDataReader>

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