BizTalk Adapter for EnterpriseDB

Build 21.0.7930

Bulk Updategrams

You can generate updategrams to take advantage of the batch processing capabilities of the EnterpriseDB 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/EnterpriseDBProvider/2021">
  <ns0:sync>
    <ns0:before></ns0:before>
    <ns0:after>      
	  <ns0:table name="Orders" schema="public" catalog="postgres">
		<ns0:ShipCity>ShipCity_1</ns0:ShipCity>
		<ns0:Freight>10</ns0:Freight>
	  </ns0:table> 
    </ns0:after>
    <ns0:after>
      <ns0:table name="Orders" schema="public" catalog="postgres">
		<ns0:ShipCity>ShipCity_2</ns0:ShipCity>
		<ns0:Freight>20</ns0:Freight>
	  </ns0:table>
    </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/EnterpriseDBProvider/2021">
  <ns0:sync>
  <ns0:before>
    <ns0:table name="Orders" schema="public" catalog="postgres">
	  <ns0:Id>Id_1</ns0:Id>
	  <ns0:ShipCity>ShipCity_x</ns0:ShipCity>
      <ns0:Freight>10</ns0:Freight>
	</ns0:table> 
  </ns0:before>
  <ns0:after>
    <ns0:table name="Orders" schema="public" catalog="postgres">
	  <ns0:Id>Id_1</ns0:Id>
	  <ns0:ShipCity>ShipCity_y</ns0:ShipCity>
      <ns0:Freight>20</ns0:Freight>
	</ns0:table> 
  </ns0:after>
  <ns0:before>
    <ns0:table name="Orders" schema="public" catalog="postgres">
	  <ns0:Id>Id_2</ns0:Id>
	  <ns0:ShipCity>ShipCity_x</ns0:ShipCity>
      <ns0:Freight>10</ns0:Freight>
	</ns0:table> 
  </ns0:before>
  <ns0:after>
    <ns0:table name="Orders" schema="public" catalog="postgres">
	  <ns0:Id>Id_2</ns0:Id>
	  <ns0:ShipCity>ShipCity_y</ns0:ShipCity>
      <ns0:Freight>20</ns0:Freight>
	</ns0:table> 
  </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/EnterpriseDBProvider/2021">
  <ns0:sync>
    <ns0:before>
	  <ns0:table name="Orders" schema="public" catalog="postgres">
		<ns0:Id>10261_1</ns0:Id>
	  </ns0:table> 
    </ns0:before>
    <ns0:before>
	  <ns0:table name="Orders" schema="public" catalog="postgres">
		<ns0:Id>10261_2</ns0:Id>
	  </ns0:table> 
    </ns0:before>
    <ns0:after></ns0:after>
  </ns0:sync>
</ns0:parameters>

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930