BizTalk Adapter for Dataflex

Build 20.0.7587

Bulk Updategrams

You can generate updategrams to take advantage of the batch processing capabilities of the Dataflex 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/CDSProvider/2020">
  <ns0:sync>
    <ns0:before></ns0:before>
    <ns0:after>
      <ns0:Accounts Name="Name_1" AnnualRevenue="10" /> 
    </ns0:after>
    <ns0:after>
      <ns0:Accounts 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/CDSProvider/2020">
  <ns0:sync>
  <ns0:before>
    <ns0:Accounts AccountId="AccountId_1" Name="Name_x" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Accounts AccountId="AccountId_1" Name="Name_y" AnnualRevenue="20" /> 
  </ns0:after>
  <ns0:before>
    <ns0:Accounts AccountId="AccountId_2" Name="Name_x" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Accounts AccountId="AccountId_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/CDSProvider/2020">
  <ns0:sync>
    <ns0:before>
      <ns0:Accounts AccountId="AccountId_1"></ns0:Accounts>
    </ns0:before>
    <ns0:before>
      <ns0:Accounts AccountId="AccountId_2"></ns0:Accounts>
    </ns0:before>
    <ns0:after></ns0:after>
  </ns0:sync>
</ns0:parameters>

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