BizTalk Adapter for Google BigQuery

Build 20.0.7654

Bulk Updategrams

You can generate updategrams to take advantage of the batch processing capabilities of the Google BigQuery 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/GoogleBigQueryProvider/2020">
  <ns0:sync>
    <ns0:before></ns0:before>
    <ns0:after>
      <ns0:publicdata.samples.github_nested repository.name="repository.name_1" repository.watchers="10" /> 
    </ns0:after>
    <ns0:after>
      <ns0:publicdata.samples.github_nested repository.name="repository.name_2" repository.watchers="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/GoogleBigQueryProvider/2020">
  <ns0:sync>
  <ns0:before>
    <ns0:publicdata.samples.github_nested Id="Id_1" repository.name="repository.name_x" repository.watchers="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:publicdata.samples.github_nested Id="Id_1" repository.name="repository.name_y" repository.watchers="20" /> 
  </ns0:after>
  <ns0:before>
    <ns0:publicdata.samples.github_nested Id="Id_2" repository.name="repository.name_x" repository.watchers="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:publicdata.samples.github_nested Id="Id_2" repository.name="repository.name_y" repository.watchers="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/GoogleBigQueryProvider/2020">
  <ns0:sync>
    <ns0:before>
      <ns0:publicdata.samples.github_nested Id="Id_1"></ns0:publicdata.samples.github_nested>
    </ns0:before>
    <ns0:before>
      <ns0:publicdata.samples.github_nested Id="Id_2"></ns0:publicdata.samples.github_nested>
    </ns0:before>
    <ns0:after></ns0:after>
  </ns0:sync>
</ns0:parameters>

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