Data Warehouse alert data writer (custom routing)

Microsoft.SystemCenter.DataWarehouse.AlertDataWriter (WriteActionModuleType)

Use this module to write alert data to the Data Warehouse with custom routing (custom data set)

Element properties:

Show References:
- WriteAction Modules (1)

Type	WriteActionModuleType
Isolation	Any
Accessibility	Public
RunAs	Default
InputType	Microsoft.SystemCenter.DataItemAlertSubscription

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	Microsoft.SystemCenter.DataWarehouse.AlertDataWriterInternal	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name
MaxExecutionAttemptCount	int	$Config/MaxExecutionAttemptCount$	Max Execution Attempt Count
ExecutionAttemptTimeoutIntervalSeconds	int	$Config/ExecutionAttemptTimeoutIntervalSeconds$	Execution Attempt Timeout Interval Seconds
BulkInsertBatchSize	int	$Config/BulkInsertBatchSize$	Bulk Insert Batch Size
MaxBatchesToProcessBeforeMaintenanceCount	int	$Config/MaxBatchesToProcessBeforeMaintenanceCount$	Max Batches To Process Before Maintenance Count

Source Code:

<WriteActionModuleType ID="Microsoft.SystemCenter.DataWarehouse.AlertDataWriter" Accessibility="Public" Batching="false">

  <Configuration>

    <xsd:element name="DataRoutingKey" type="xsd:string" minOccurs="1" maxOccurs="1"/>

    <xsd:element name="BulkInsertBatchSize" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="MaxBatchesToProcessBeforeMaintenanceCount" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="MaxExecutionAttemptCount" type="xsd:int" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="ExecutionAttemptTimeoutIntervalSeconds" type="xsd:int" minOccurs="0" maxOccurs="1"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="MaxExecutionAttemptCount" ParameterType="int" Selector="$Config/MaxExecutionAttemptCount$"/>

    <OverrideableParameter ID="ExecutionAttemptTimeoutIntervalSeconds" ParameterType="int" Selector="$Config/ExecutionAttemptTimeoutIntervalSeconds$"/>

    <OverrideableParameter ID="BulkInsertBatchSize" ParameterType="int" Selector="$Config/BulkInsertBatchSize$"/>

    <OverrideableParameter ID="MaxBatchesToProcessBeforeMaintenanceCount" ParameterType="int" Selector="$Config/MaxBatchesToProcessBeforeMaintenanceCount$"/>

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <WriteAction ID="WA" TypeID="Microsoft.SystemCenter.DataWarehouse.AlertDataWriterInternal">

          <ManagementGroupId>$Target/ManagementGroup/Id$</ManagementGroupId>

          <DataSetId>$MPElement[Name="Microsoft.SystemCenter.DataWarehouse.DataSet.Alert"]$</DataSetId>

          <DataRoutingKey>$Config/DataRoutingKey$</DataRoutingKey>

          <TableName>Alert.AlertStage</TableName>

          <BulkInsertBatchSize>$Config/BulkInsertBatchSize$</BulkInsertBatchSize>

          <MaxBatchesToProcessBeforeMaintenanceCount>$Config/MaxBatchesToProcessBeforeMaintenanceCount$</MaxBatchesToProcessBeforeMaintenanceCount>

          <MaxExecutionAttemptCount>$Config/MaxExecutionAttemptCount$</MaxExecutionAttemptCount>

          <ExecutionAttemptTimeoutIntervalSeconds>$Config/ExecutionAttemptTimeoutIntervalSeconds$</ExecutionAttemptTimeoutIntervalSeconds>

          <SqlAuthentication>

            <Login>$RunAs[Name="Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount"]/UserName$</Login>

            <Password>$RunAs[Name="Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount"]/Password$</Password>

          </SqlAuthentication>

        </WriteAction>

      </MemberModules>

      <Composition>

        <Node ID="WA"/>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <InputType>SystemCenter!Microsoft.SystemCenter.DataItemAlertSubscription</InputType>

</WriteActionModuleType>