BizTalk Adapter for Google BigQuery

Build 20.0.7654

Getting Started

Connecting to Google BigQuery

Establishing a Connection shows how to authenticate to Google BigQuery and set any necessary connection properties. You can also configure adapter capabilities through the available Connection properties, from data modeling to firewall traversal. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors.

Connecting from BizTalk

Overview of BizTalk Orchestrations

See BizTalk Orchestrations for information on creating and configuring an orchestration within BizTalk.

Manual Installation Fallback Procedure

See Adapter Installation for detailed instructions for manually completing adapter installation in the event that the setup is unable to complete the installation process.

BizTalk Version Support

The supported versions of BizTalk are 2006, 2006R2, 2010, 2012R2, 2013, 2016, and 2020. See Supported Macros for the macros the adapter supports in the adapter properties.

Google BigQuery Version Support

The adapter enables read/write SQL-92 access to the BigQuery tables in your Google account or Google Apps domain. The complete aggregate and join syntax in BigQuery is supported. Additionally, statements in the BigQuery syntax can be passed through. The adapter uses version 2.0 of the BigQuery Web services API: You must enable this API by creating a project in the Google Developers Console. See Connecting to Google for a guide to creating a project and authenticating to this API.

See Also

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