• Getting started
  • API Documentation
  • Pricing
  • Contact
Show / Hide Table of Contents
  • ETLBox.Connection
    • AccessOdbcConnectionManager
    • AdomdConnectionManager
    • ConnectionManagerType
    • Db2ConnectionManager
    • Db2ConnectionString
    • DbConnectionManager<Connection>
    • DbConnectionString<T, TBuilder>
    • IConnectionManager
    • IDbConnectionString
    • MariaDbConnectionManager
    • MariaDbConnectionString
    • MySqlConnectionManager
    • MySqlConnectionString
    • MySqlOdbcConnectionManager
    • OdbcConnectionManager
    • OdbcConnectionString
    • OleDbConnectionManager
    • OleDbConnectionString
    • OracleConnectionManager
    • OracleConnectionString
    • OracleOdbcConnectionManager
    • PostgresConnectionManager
    • PostgresConnectionString
    • PostgresOdbcConnectionManager
    • SqlConnectionManager
    • SqlConnectionString
    • SQLiteConnectionManager
    • SQLiteConnectionString
    • SqlOdbcConnectionManager
    • SqlOleDbConnectionManager
  • ETLBox.ControlFlow
    • ControlFlow
    • ControlFlowTask
    • DbTask
    • DropTask<T>
    • IfExistsTask
    • ILoggableTask
    • ITableData
    • LoggableTask
    • ProcedureDefinition
    • ProcedureParameter
    • QueryParameter
    • TableColumn
    • TableData
    • TableData<T>
    • TableDefinition
  • ETLBox.ControlFlow.Tasks
    • CalculateDatabaseHashTask
    • CleanUpSchemaTask
    • CreateDatabaseTask
    • CreateIndexTask
    • CreateProcedureTask
    • CreateSchemaTask
    • CreateTableTask
    • CreateViewTask
    • DropDatabaseTask
    • DropIndexTask
    • DropProcedureTask
    • DropSchemaTask
    • DropTableTask
    • DropViewTask
    • GetDatabaseListTask
    • IfDatabaseExistsTask
    • IfIndexExistsTask
    • IfProcedureExistsTask
    • IfSchemaExistsTask
    • IfTableOrViewExistsTask
    • RecoveryModel
    • RowCountOptions
    • RowCountTask
    • SqlTask
    • TruncateTableTask
    • XmlaTask
  • ETLBox.DataFlow
    • AggregateColumn
    • ChangeAction
    • ColumnMap
    • CompareColumn
    • DataFlow
    • DataFlowBatchDestination<TInput>
    • DataFlowComponent
    • DataFlowDestination<TInput>
    • DataFlowExecutableSource<TOutput>
    • DataFlowJoinTarget<TInput>
    • DataFlowSource<TOutput>
    • DataFlowStreamDestination<TInput>
    • DataFlowStreamSource<TOutput>
    • DataFlowTransformation<TInput, TOutput>
    • DeleteColumn
    • DistinctColumn
    • ErrorSource
    • ETLBoxError
    • ExcelColumn
    • ExcelRange
    • GroupColumn
    • ICacheManager<TInput, TCache>
    • IDataFlowBatchDestination
    • IDataFlowBatchDestination<TInput>
    • IDataFlowComponent
    • IDataFlowDestination
    • IDataFlowDestination<TInput>
    • IDataFlowExecutableSource
    • IDataFlowExecutableSource<TOutput>
    • IDataFlowLogging
    • IDataFlowSource
    • IDataFlowSource<TOutput>
    • IDataFlowStreamDestination
    • IDataFlowStreamDestination<TInput>
    • IDataFlowStreamSource
    • IDataFlowStreamSource<TOutput>
    • IDataFlowTransformation<TInput, TOutput>
    • IDataFlowTransformation<TOutput>
    • IdColumn
    • IMergeableRow
    • JoinTarget<TInput>
    • MatchColumn
    • MemoryCache<TInput, TCache>
    • MergeableRow
    • MergeMode
    • MergeProperties
    • Network
    • ResourceType
    • RetrieveColumn
    • StreamMetaData
    • TypeInfo
    • UpdateColumn
  • ETLBox.DataFlow.Connectors
    • ConcurrentMemoryDestination
    • ConcurrentMemoryDestination<TInput>
    • CsvDestination
    • CsvDestination<TInput>
    • CsvSource
    • CsvSource<TOutput>
    • CustomBatchDestination
    • CustomBatchDestination<TInput>
    • CustomBatchSource
    • CustomBatchSource<TOutput>
    • CustomDestination
    • CustomDestination<TInput>
    • CustomSource
    • CustomSource<TOutput>
    • DbDestination
    • DbDestination<TInput>
    • DbMerge
    • DbMerge<TInput>
    • DbSource
    • DbSource<TOutput>
    • ExcelSource
    • ExcelSource<TOutput>
    • JsonDestination
    • JsonDestination<TInput>
    • JsonSource
    • JsonSource<TOutput>
    • MemoryDestination
    • MemoryDestination<TInput>
    • MemorySource
    • MemorySource<TOutput>
    • TextDestination
    • TextDestination<TInput>
    • TextSource
    • TextSource<TOutput>
    • VoidDestination
    • VoidDestination<TInput>
    • XmlDestination
    • XmlDestination<TInput>
    • XmlSource
    • XmlSource<TOutput>
  • ETLBox.DataFlow.Transformations
    • Aggregation
    • Aggregation<TInput, TOutput>
    • AggregationMethod
    • BatchTransformation
    • BatchTransformation<TInput, TOutput>
    • BatchTransformation<TInput>
    • BlockTransformation
    • BlockTransformation<TInput, TOutput>
    • BlockTransformation<TInput>
    • CachedBatchTransformation
    • CachedBatchTransformation<TInput, TOutput, TCache>
    • CachedBatchTransformation<TInput, TOutput>
    • CachedBatchTransformation<TInput>
    • CachedRowTransformation
    • CachedRowTransformation<TInput, TOutput, TCache>
    • CachedRowTransformation<TInput, TOutput>
    • CachedRowTransformation<TInput>
    • CacheMode
    • ColumnRename
    • ColumnRename<TInput>
    • CrossJoin
    • CrossJoin<TInput>
    • CrossJoin<TInput1, TInput2, TOutput>
    • CrossJoin<TInput1, TInput2, TOutput>.InMemoryDestination<TInput>
    • Distinct<TInput>
    • LookupTransformation
    • LookupTransformation<TInput, TSource>
    • LookupTransformation<TInput, TSource>.PartialDbCacheSettings
    • MergeJoin
    • MergeJoin<TInput>
    • MergeJoin<TInput1, TInput2, TOutput>
    • Multicast
    • Multicast<TInput>
    • RowDuplication
    • RowDuplication<TInput>
    • RowMultiplication
    • RowMultiplication<TInput, TOutput>
    • RowMultiplication<TInput>
    • RowTransformation
    • RowTransformation<TInput, TOutput>
    • RowTransformation<TInput>
    • Sort
    • Sort<TInput>
    • XmlSchemaValidation
    • XmlSchemaValidation<TInput>
  • ETLBox.Exceptions
    • ETLBoxException
    • ETLBoxFaultedBufferException
    • ETLBoxNotSupportedException
  • ETLBox.Helper
    • BatchLinq
    • BulkSqlGenerator<T>
    • DataTypeConverter
    • ExpandoJsonPathConverter
    • HashHelper
    • IDataTypeConverter
    • JsonPathConverter
    • JsonProperty2JsonPath
    • JsonProperty2JsonPath.MultipleResultsInPath
    • ObjectNameDescriptor
    • PropertyInfoExtension
    • SqlParser
    • StringExtension
  • ETLBox.Logging
    • AbortLoadProcessTask
    • CreateErrorTableTask
    • CreateLoadProcessTableTask
    • CreateLogTableTask
    • CustomTask
    • EndLoadProcessTask
    • ETLLogLayoutRenderer
    • GetLoadProcessAsJSONTask
    • GetLogAsJSONTask
    • LoadProcess
    • LogEntry
    • Logging
    • LogHierarchyEntry
    • LogTask
    • Package
    • ReadLoadProcessTableTask
    • ReadLogTableTask
    • ReadOptions
    • Sequence
    • Sequence<T>
    • StartLoadProcessTask

Class XmlaTask

This task can exeucte any XMLA.

Inheritance
System.Object
LoggableTask
ControlFlowTask
DbTask
XmlaTask
Implements
ILoggableTask
Inherited Members
DbTask.Sql
DbTask.Actions
DbTask.BeforeRowReadAction
DbTask.AfterRowReadAction
DbTask.Limit
DbTask.RowsAffected
DbTask.Parameter
DbTask.ExecuteNonQuery()
DbTask.ExecuteScalar()
DbTask.ExecuteScalar<T>()
DbTask.ExecuteScalarAsBool()
DbTask.ExecuteReader()
DbTask.BulkInsert(ITableData)
DbTask.BulkDelete(ITableData)
DbTask.BulkUpdate(ITableData, ICollection<String>, ICollection<String>)
ControlFlowTask.ConnectionManager
ControlFlowTask.ConnectionType
ControlFlowTask.QB
ControlFlowTask.QE
LoggableTask.TaskType
LoggableTask._disableLogging
LoggableTask.DisableLogging
LoggableTask.TaskHash
LoggableTask.CopyLogTaskProperties(ILoggableTask)
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()
Namespace: ETLBox.ControlFlow.Tasks
Assembly: ETLBox.dll
Syntax
public class XmlaTask : DbTask, ILoggableTask
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

Constructors

XmlaTask()

Declaration
public XmlaTask()

XmlaTask(String)

Declaration
public XmlaTask(string xmla)
Parameters
Type Name Description
System.String xmla

XmlaTask(String, Action, Action, Action<Object>[])

Declaration
public XmlaTask(string xmla, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
Type Name Description
System.String xmla
System.Action beforeRowReadAction
System.Action afterRowReadAction
System.Action<System.Object>[] actions

XmlaTask(String, Action<Object>[])

Declaration
public XmlaTask(string xmla, params Action<object>[] actions)
Parameters
Type Name Description
System.String xmla
System.Action<System.Object>[] actions

XmlaTask(String, String)

Declaration
public XmlaTask(string name, string xmla)
Parameters
Type Name Description
System.String name
System.String xmla

Properties

TaskName

Declaration
public override string TaskName { get; set; }
Property Value
Type Description
System.String
Overrides
LoggableTask.TaskName

Methods

ExecuteNonQuery(IConnectionManager, String)

Declaration
public static int ExecuteNonQuery(IConnectionManager connectionManager, string xmla)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String xmla
Returns
Type Description
System.Int32

ExecuteNonQuery(String)

Declaration
public static int ExecuteNonQuery(string xmla)
Parameters
Type Name Description
System.String xmla
Returns
Type Description
System.Int32

ExecuteNonQuery(String, String)

Declaration
public static int ExecuteNonQuery(string name, string xmla)
Parameters
Type Name Description
System.String name
System.String xmla
Returns
Type Description
System.Int32

ExecuteReader(IConnectionManager, String, Action, Action, Action<Object>[])

Declaration
public static void ExecuteReader(IConnectionManager connectionManager, string xmla, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String xmla
System.Action beforeRowReadAction
System.Action afterRowReadAction
System.Action<System.Object>[] actions

ExecuteReader(IConnectionManager, String, Action<Object>[])

Declaration
public static void ExecuteReader(IConnectionManager connectionManager, string xmla, params Action<object>[] actions)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String xmla
System.Action<System.Object>[] actions

ExecuteReader(String, Action, Action, Action<Object>[])

Declaration
public static void ExecuteReader(string xmla, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
Type Name Description
System.String xmla
System.Action beforeRowReadAction
System.Action afterRowReadAction
System.Action<System.Object>[] actions

ExecuteReader(String, Action<Object>[])

Declaration
public static void ExecuteReader(string xmla, params Action<object>[] actions)
Parameters
Type Name Description
System.String xmla
System.Action<System.Object>[] actions

ExecuteScalar(IConnectionManager, String)

Declaration
public static object ExecuteScalar(IConnectionManager connectionManager, string xmla)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String xmla
Returns
Type Description
System.Object

ExecuteScalar(String)

Declaration
public static object ExecuteScalar(string xmla)
Parameters
Type Name Description
System.String xmla
Returns
Type Description
System.Object

ExecuteScalar(String, String)

Declaration
public static object ExecuteScalar(string name, string xmla)
Parameters
Type Name Description
System.String name
System.String xmla
Returns
Type Description
System.Object

ExecuteScalar<T>(IConnectionManager, String)

Declaration
public static T? ExecuteScalar<T>(IConnectionManager connectionManager, string xmla)
    where T : struct
Parameters
Type Name Description
IConnectionManager connectionManager
System.String xmla
Returns
Type Description
System.Nullable<T>
Type Parameters
Name Description
T

ExecuteScalar<T>(String)

Declaration
public static T? ExecuteScalar<T>(string xmla)
    where T : struct
Parameters
Type Name Description
System.String xmla
Returns
Type Description
System.Nullable<T>
Type Parameters
Name Description
T

ExecuteScalar<T>(String, String)

Declaration
public static T? ExecuteScalar<T>(string name, string xmla)
    where T : struct
Parameters
Type Name Description
System.String name
System.String xmla
Returns
Type Description
System.Nullable<T>
Type Parameters
Name Description
T

ExecuteScalarAsBool(IConnectionManager, String)

Declaration
public static bool ExecuteScalarAsBool(IConnectionManager connectionManager, string xmla)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String xmla
Returns
Type Description
System.Boolean

ExecuteScalarAsBool(String)

Declaration
public static bool ExecuteScalarAsBool(string xmla)
Parameters
Type Name Description
System.String xmla
Returns
Type Description
System.Boolean

ExecuteScalarAsBool(String, String)

Declaration
public static bool ExecuteScalarAsBool(string name, string xmla)
Parameters
Type Name Description
System.String name
System.String xmla
Returns
Type Description
System.Boolean

Implements

ILoggableTask
Back to top Crafted with <3 in Berlin
Contact & legal notice