Google BigQuery

SAP Cloud Integration for data services supports using a Google BigQuery connection with an ODBC driver.

Note

If you plan to use a Google BigQuery datastore as a source, the target must be an SAP Integrated Business Planning (IBP) WebSocketRFC datastore.

Prerequisite: You must install the Simba ODBC driver on the agent machine. For more information, see Download and install the Simba ODBC driver.

To access tables from your Google BigQuery projects, create a Google BigQuery ODBC datastore using either a data source name (DSN) or a server name (DSN-less) connection.

Google BigQuery datastore options
Option	Description
Name	The name of the object. Alphanumeric characters and underscores. This name appears in the datastores tab and in tasks that use the datastore.
Description	The description of the datastore.
Type	Select Google BigQuery.
Agent	The list of agents that have been defined in the Agents tab. Specifies the agent that should be used to access this data source.
Database Type	Select Google BigQuery ODBC.
Use Data Source (ODBC)	Select `Yes` or No to indicate whether you configured the driver with ODBC. Note Before you configure this datastore, configure a DSN for the Simba ODBC driver for Google BigQuery using the ODBC Data Source Administrator for Windows or the SAP Data Services (DS) Connection Manager for Linux.
ODBC data source name	Enter the desired DSN name. Required when Use Data Source (ODBC) is set to `Yes`. Note Before you configure this datastore, configure a DSN for the Simba ODBC driver for Google BigQuery using the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
OAuth Mechanism	Specify how the ODBC driver authenticates access to Google BigQuery. Required when Use Data Source (ODBC) is set to `No`. Select one of the following options: User Authentication: Authenticates as a user through a Google user account. Also populate Refresh Token. Service Authentication: Authenticates as a service through a Google service account. Also complete the following options: Email Key File Path Note Appears only for DSN-less connections. For DSN connections, you select the OAuth mechanism and complete the additional options in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Refresh Token	Enter the refresh token obtained from your Google BigQuery account. Required when OAuth Mechanism is set to `User Authentication`. Note Appears only for DSN-less connections. For DSN connections, you enter the Refresh Token in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Email	Enter your Google Cloud Platform e-mail ID accessed from your Google BigQuery account. Required when OAuth Mechanism is set to `Service Authentication`. Note Appears only for DSN-less connections. For DSN connections, you enter Email in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Key File Path	Browse to and select the location of the P12 or JSON file you generated from Google Cloud Platform and saved locally. Required when OAuth Mechanism is set to `Service Authentication`. Note Appears only for DSN-less connections. For DSN connections, you enter the Private Key information in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Catalog	Enter the Google BigQuery project name. Required when Use Data Source (ODBC) is set to `No`. Note Appears only for DSN-less connections. For DSN connections, you enter the Catalog in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Advanced group
Use SSL encryption	Configurable when Use Data Source (ODBC) is set to `No`. Note Applicable only for DSN-less connections. For DSN connections, you select TLS by completing the Trust Store information in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Encryption parameters	Configurable when Use Data Source (ODBC) is set to `No`. Select in the text box to open the Encryption Parameters popup dialog box. Complete one of the following two options: Use System Trust Store Trusted Certificate Note Applicable only for DSN-less connections. For DSN connections, you enter the Trust Store information in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.
Use System Trust Store	Select to use the system trust store instead of the Google BigQuery trusted certificate.
Trusted Certificate	Select the location for the Google BigQuery trusted certificate PEM file from the Browse dialog box, or you can enter the location for your PEM trust store file.
Proxy host Proxy port Proxy user name Proxy password	Optional. Complete the proxy options when you use a proxy server. Note Applicable only for DSN-less connections. For DSN connections, you enter the Proxy options in the ODBC Data Source Administrator for Windows or the DS Connection Manager for Linux.