Complete AI Automation Suite
FLAT 30% OFF
AI Insight Assistant
Talk to your data. Get instant answers
AI Live Chatbot
24/7 customer support, always on
AI Dashboard Studio
 Beautiful dashboards, zero effort
MCP Integration
Seamless multi-channel connections
And Many More Features
Complete AI Automation Suite — FLAT 30% OFF

BigQuery Connector - Powerful Analytics for Instant Insights v18

  • Home
  • Blogs
  • BigQuery Connector - Powerful Analytics for Instant Insights v18
logo
Free Support
Life Time
Counter box img
Custom Apps
1500+
counter box img
top seller of odoo marketplace
counter box img
Happy Customer
10K+
counter box img
Year Of Experience
11+
counter box img
countries
100+
counter box img
Talented healers
150+
counter box img
Industries Served
45+
counter box img
Odoo Community Implementation
350+
counter box img
Odoo Enterprise Implementation
150+
counter box img
Best partner Nominee
2024
counter box img
Global Presence
counter box img

Free Demo
Email: sales@softhealer.com
Lifetime Free Support
Contact: support@softhealer.com
Customization
Sales: sales@softhealer.com
logo
Community Enterprise Odoo.sh

BigQuery Connector - Powerful Analytics for Instant Insights

heading

The Odoo BigQuery Connector allows you to transfer your Odoo data into Google BigQuery for reporting, analytics and data warehousing. It provides a simple setup where you can connect your Google service account, select your dataset and move key business records from Odoo to BigQuery. This helps users analyse large volumes of Odoo data using BigQuerys powerful cloud-based processing.

Features

heading
Connect Odoo with Google BigQuery

Easily configure your Google project, dataset and service account JSON key inside Odoo.

One Click Sync - One Click Data Transfer

A simple button lets you perform immediate data transfer without extra configuration.

Real-Time Data Sync

Instantly pushes updated Odoo data to keep all connected systems always up to date.

Select Odoo Models to Export

Choose which Odoo models (like Sales Orders, Products, Invoices, Customers etc.) you want to send to BigQuery.

Powerful Analytics Dashboard

Visualize your BigQuery data within Odoo using a dedicated, interactive dashboard.

Comprehensive Synchronization Logs

Track every data transfer with detailed logs, including success status and error messages.

Multi-Company Support

Manage and synchronize BigQuery integration separately for multiple companies within a single Odoo environment.

Export Odoo Data to BigQuery

Send data from Odoo into BigQuery for reporting and analytics, map them into BigQuery table columns.

Safe Data Transfer Using Google APIs

Communication with BigQuery uses trusted Google API endpoints for secure and reliable transfers.

User-Friendly Notifications

Shows clear alerts and messages to keep users informed without disrupting workflow.

Google Cloud Security

Uses Google-approved authentication through service account JSON for secure access.

Automated Data Synchronization

Schedule regular data transfers from Odoo to BigQuery using automated cron jobs.

Import BigQuery Data into Odoo

You can now import data directely from the BigQuery to Odoo and you can also create schedueled actions for the same.

Test Connection Functionality

You can now also test the connection in the BigQuery Configuration by entering the required credentials.

Setup Help Alerts new_tag

Follow contextual setup guidance directly in BigQuery configuration to complete connection requirements with fewer setup errors.

Log Auto-Delete new_tag

Automatically remove older sync logs based on the configured retention period for cleaner, manageable synchronization history.

Retry Sync Logs new_tag

Retry failed or warning synchronization logs directly from Sync Log History to rerun the affected model export.

Sync Log History list view.


Click View button to view the list of records synced.


Sync Log History of the Account Records which were synced in the previous sync.

In the Import Data list view.


Viewing an import data record with scheduled import time.


Click Run Manually to run Import data schedueled actions.


Click Run Manually in the Import Data to manually import the data.


Message displaying the successful imports of the data.


Creating a record for the Contacts imports whose record is already being created previously.


Now click to Create Schedueler.


A pop-up of Invalid Operation indicated that an active schedueled import already exists for the same model, so update the configuration instead of creating a new one.

Activating the Automations for Journal model in the configuration .


Click run manually to run the automation scheduled actions.


Click the Sync Now to sync the records.


Message in the sync log history defines that the records were successfully synced.


We can see that in the Sync Log History Journal Records list view.

BigQuery Dashboard view.


Highlighted the Connection & Configurations tab on the dashboard.


BigQuery configuration list view.


Highlighted the Export Automations tab on the dashboard to Sync records.


Select the model to Export Records.


Successfully exported records.


Highlighted the Import Schedulers tab on the dashboard.


BigQuery dashboard import data list view.


Highlighted the Manual Operations tab on the dashboard.


Click on the Export Now button.


Select the model to Export Data and click Export button.


Click on the Import Now button to import records.


Imported data list view.


Highlighted the successful Syncs tab on the dashboard.


List view of the successful sync logs.


Highlighted the Failed Syncs tab on the dashboard.


Failed Sync logs list view.


You can also select the date range and company to filter records on the sync dashboard.

BigQuery Configurations for a specific company.


BigQuery Configuration for the multi-company.

Goto BigQuery Connector.


BigQuery Configurations.


Select a BigQuery configuration.


Enter the required credentials and click Test Connection to test the BigQuery connection.


Message of successful connection.

Go to the 'Settings'.


Go to the 'Big Query Connector'.
Fill the 'BigQuery Configuration' data.


Click on the "BigQuery" from the Navigation menu.




Click on the "Create Project" button to create a new project.


Click on the "Create dataset" from the three dot.


Here, you can see the created dataset ID. Copy it and paste it into the Odoo module's 'BigQuery Configuration'.


Copy the project ID and paste it into the Odoo module's 'BigQuery Configuration'.


Go to the 'IAM and admin' ==> 'Service accounts'.


Click on the "Create Service Account" button to set up a new service account.


Click on the "Manage Keys" from the three dot.


Under "Add Key", click on the "Create new Key".


Choose the "JSON" key type and click on the "Create" button.


Here, you'll find the JSON file. Copy the JSON credentials from the link and add them to the Odoo module's 'BigQuery Configuration'.


Go to the Export Data menu.


Select the model and click on the "Export" button.


After the data is successfully exported, a "Success" pop-up will appear.


You can find the exported model in the project dataset.

Go to BigQuery Connector Settings options like Sync on Create, Sync on Update, and Sync on Delete, and add the relevant models.
Note: Only data from the selected models is automatically synced from Odoo to BigQuery.


Create a new product (Bag).


In BigQuery, you can see that the newly created product is automatically synced.


Add the sales price and taxes in Odoo.


You can see that the sales price and taxes are automatically synced in BigQuery.


Delete the 'Bag' product from Odoo.


You can see that the 'Bag' product is automatically deleted from BigQuery.


Centralized dashboard to manage and monitor all connectors from one place. Quickly access sync summary, activity logs, and configuration controls with improved visibility.


BigQuery Config form with the Log Auto-Delete Days field set to remove old sync logs.

log_auto_delete_configuration

Scheduled Action "BigQuery: Auto-Delete Sync Logs" runs daily to delete outdated log records automatically.

log_auto_delete_scheduler

Sync Log History tab appears empty after old records were automatically deleted by the scheduler.

log_auto_delete_history

Sync Log History showing a failed record with the Retry button highlighted for manual resync.

retry_sync_log_history

Multiple failed res.partner sync entries each display an individual Retry button in the log list.

retry_sync_log_action

Version 18.0.4.0.0 | Released on : 24th August 2026

New Integration with integration base module.

New Added Retry Functionality.

New Added Configuration Guides (Help Alerts) for setup.

New Added Log Auto-delete log-history.

Update Refactored Import process to use Batched Commits (every 100 records).

Version 18.0.3.0.0 | Released on : 4th May 2026

New Added Import Data feature.
New Added Automated Schedulers.
New Added Integration Configuration.
New Added Sync Log History.
New Added Test Connection feature.
New Added Dashboard.
New Added Multi-Company Support.

Version 18.0.2.0.0 | Released on : 10th January 2026

New Added Automatic Sync Real-time Data To BigQuery From Odoo Functionality.

Version 18.0.1.0.0 | Released on : 8th December 2025

Initial Initial Release.
  • Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
  • No, this application is not compatible with odoo.com(odoo saas/Odoo Online)
  • Yes, we provide free support for 365 days from the date of purchase.
  • Yes, you will receive lifetime free updates for the version of the module you purchased.
  • Yes, need to add a 'google-cloud-bigquery' library.
  • Yes, for version 12 and above, you need to purchase the module separately for each version you intend to use.
  • No, exchanges or refunds are not allowed. Please make sure to select the correct version before purchasing.
  • You can contact us at support@softhealer.com for language translation support. We use Google Translator tools to provide translations in multiple languages, so the accuracy may vary. We welcome your suggestions to help improve translations.

Discover Our Latest Apps

heading
NEW

Odoo Direct Print

  • Print Any Odoo PDF
  • Access From Anywhere
  • No IoT Required
And many more powerful features..

NEW

AI Insight Assistant

  • Dedicated AI Chat Interface
  • Instant Response Engine
  • Intelligent Data Understanding
And many more powerful features..

NEW

Knowledge Base System

  • Smart Dashboard
  • User & Manager Roles
  • Portal View
And many more powerful features..

All in One Dynamic Approval - Enterprise Edition v19

Transforming Businesses with Next-Gen Solutions

Our next-generation solutions are built to transform businesses and drive growth in the digital era.

Find Us

530, West Gate 2,
Ayodhya Chowk, 150 Feet Ring Road Rajkot, Gujarat 360006.

Find Us

131 South End, Croydon CRO 1BJ,
United Kingdom

Contact No.

HR : +91 90232 46069
Sales : +91 93288 25451
Support : +91 63571 93747

Contact No.

Sales : +44 7562 893296

Reach Us Read Blog Contact Us Submit Support Ticket Watch Video Tutorial
whatsapp-support-store whatsapp-support-store
Click to Chat