Microsoft.SystemCenter.DataProtectionManager.2011.Discovery.BackupEventDataWriter (WriteActionModuleType)

Element properties:

Member Modules:

Source Code:

<WriteActionModuleType ID="Microsoft.SystemCenter.DataProtectionManager.2011.Discovery.BackupEventDataWriter" Accessibility="Public" Batching="false">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DataRoutingKey" type="xsd:string" minOccurs="1" maxOccurs="1"/>

  </Configuration>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <WriteAction ID="WA" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.BulkInsertBulkDataWriter">

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

          <DataSetId>$MPElement[Name="Microsoft.SystemCenter.DataProtectionManager.2011.Discovery.DPMEventDataset"]$</DataSetId>

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

          <BulkInsertBatchSize>5000</BulkInsertBatchSize>

          <MaxBatchesToProcessBeforeMaintenanceCount>50</MaxBatchesToProcessBeforeMaintenanceCount>

          <TableName>DPMBackup.tbl_DPM_BackupEvents_Stage</TableName>

          <MaxExecutionAttemptCount>0</MaxExecutionAttemptCount>

          <ExecutionAttemptTimeoutIntervalSeconds>0</ExecutionAttemptTimeoutIntervalSeconds>

          <DataItemXPathIteratorExpression>DataItem/Params</DataItemXPathIteratorExpression>

          <TableColumns>

            <Column>

              <Name>DatasourceId</Name>

              <Type>Guid</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[3]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>ReferentialDatasourceId</Name>

              <Type>Guid</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[4]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TaskId</Name>

              <Type>Guid</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[5]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>BackupTime</Name>

              <Type>DateTime</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[7]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>BackupResult</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[8]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>BackupType</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[9]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>FailureErrorCode</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Params/Param[10]</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

          </TableColumns>

          <SqlAuthentication>

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

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

          </SqlAuthentication>

        </WriteAction>

      </MemberModules>

      <Composition>

        <Node ID="WA"/>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <InputType>System!System.BaseData</InputType>

</WriteActionModuleType>