This module allows you to: * Configure BigQuery connections * Export data to BigQuery tables * Schedule data synchronization
Key features
Enable BigQuery API - Go to Google Cloud Console . - Navigate to Enabled APIs & services . - Enable BigQuery API. Create Dataset in BigQuery - Go to the BigQuery menu. - Click on Create Dataset . Create Service Account - Go to IAM & Admin -> Service Accounts . - Click on Create Service Account . Generate Service Account JSON File - Go to Service Account -> Keys . - Click on Add Keys -> Create New Key (choose JSON type). Odoo BigQuery Connection - Go to Connections in Odoo. - Enter the Project ID and upload the JSON file . Export Data Using Model or Query & Schedule Export Data. - Two ways to fetch the data: through Model and through Query . - Also, generate queries through AI from normal language. - Also, Schedule export data. BigQuery Table View Exported Data in BigQuery - Also, you can download data or open in google sheet. Veracious solutions to grow your business.
Available for Odoo 16, 17, 18.