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.