BizTalk Adapter for Amazon DynamoDB

Build 20.0.7654

Bulk Updategrams

You can generate updategrams to take advantage of the batch processing capabilities of the Amazon DynamoDB API in BizTalk.

Bulk Insert Schema

A bulk insert updategram has multiple after blocks, which specify how the data will change, in the sync block. Below is an example of a bulk insert request.

<ns0:parameters xmlns:ns0="http://www.cdata.com/AmazonDynamoDBProvider/2020">
  <ns0:sync>
    <ns0:before></ns0:before>
    <ns0:after>
      <ns0:Account Name="Name_1" AnnualRevenue="10" /> 
    </ns0:after>
    <ns0:after>
      <ns0:Account Name="Name_2" AnnualRevenue="20" /> 
    </ns0:after>
  </ns0:sync>
</ns0:parameters>

Bulk Update Schema

A bulk update updategram has multiple before and blocks in the sync block. A before block specifies which columns to update. An after block specifies how the data will change. Below is an example of a bulk update request.
<ns0:parameters xmlns:ns0="http://www.cdata.com/AmazonDynamoDBProvider/2020">
  <ns0:sync>
  <ns0:before>
    <ns0:Account Id="Id_1" Name="Name_x" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Account Id="Id_1" Name="Name_y" AnnualRevenue="20" /> 
  </ns0:after>
  <ns0:before>
    <ns0:Account Id="Id_2" Name="Name_x" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Account Id="Id_2" Name="Name_y" AnnualRevenue="20" /> 
  </ns0:after>
  </ns0:sync>
</ns0:parameters>

Bulk Delete Schema

A bulk delete updategram has multiple before blocks, which identify the items to be deleted, and empty after blocks. Below is an example of a bulk delete request.
<ns0:parameters xmlns:ns0="http://www.cdata.com/AmazonDynamoDBProvider/2020">
  <ns0:sync>
    <ns0:before>
      <ns0:Account Id="Id_1"></ns0:Account>
    </ns0:before>
    <ns0:before>
      <ns0:Account Id="Id_2"></ns0:Account>
    </ns0:before>
    <ns0:after></ns0:after>
  </ns0:sync>
</ns0:parameters>

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654