Google BigQuery Connector for Odoo Installation and Setup Guide

Requirements:

• Odoo Versions Supported: 12, 13, 14, 15, 16, 17 (Enterprise or Community)
• Google Cloud Account with BigQuery enabled
• Necessary permissions in Odoo and Google Cloud (follow along for more details)
• The module depends on these python libraries 'google-cloud-bigquery', 'pandas','pyarrow'.
• If you are on Odoo Sh, add these in your addons repository level requirements.txt.
• If you are on on-premises server, install these manually in your Odoo python environment manually and restart the server.

Installation:

• Download the BigQuery Connector module from
https://apps.odoo.com/apps/modules/17.0/bigquery_techfinna/

• In your Odoo, navigate to Apps and click on 'Update Apps List' and Update

• Search for 'BigQuery Connector', then click 'Install'

Configuration:

3.1. Obtaining BigQuery Project ID and Dataset ID:

• Log in to your Google Cloud Console
console.cloud.google.com
• Navigate to the BigQuery section.
• Create a new project (if not already done). Note: Ensure the Project ID does not contain dots (".") as this may cause issues with certain integrations.
• Note down the Project ID.

• In the BigQuery dashboard, create a new dataset. Remember: The Dataset ID should not contain dots (".") as well.

• Note down the Dataset ID.

3.2. Creating a Google Cloud Service Account and Generating Credentials JSON:

• Navigate to ‘IAM & Admin’ → ‘Service Accounts’ in the Google Cloud Console.

• Create a new service account and assign the ‘BigQuery Admin’ role for full BigQuery access. (if you do not want to give admin access provide “BigQueryData Editor” and “BigQuery Job User” role)

• Generate a new JSON key for this service account and download it. (Select your Service account and in “Keys” tab click “ADD KEY”)

Connecting to Google BigQuery:

After configuring the BigQuery Connector in your Odoo settings, the next step is to ensure that it is properly connected and can communicate with Google BigQuery. Here’s how you can verify the connection:

• Fill in the Required Information: In the Odoo settings menu, input the necessary details:
• In Odoo, enter the BigQuery Project ID and Dataset ID in the connector settings.

• Paste the contents of the JSON file (download after key creation) into the ‘BigQuery Credentials JSON’ field. Click “SAVE” after filling information.

• Export Data to Verify Connection:
• Navigate to the top menu in the settings and select a table to export from the dropdown list.

• Click the ‘Export’ button to initiate data export to BigQuery.

• This action will attempt to export the selected table's data to your BigQuery dataset.
• Check BigQuery for Exported Data:
• Log into your Google Cloud Console and go to the BigQuery section.
• Navigate to the dataset you provided in the settings.
• Check for the presence of the exported table and its data. (You might need to refresh the content to see the table(s) )

• Successful data (schema and records) visibility in the BigQuery dataset confirms that the connection between Odoo and BigQuery is functioning correctly.