Odoo BigQuery Connector

Odoo BigQuery Connector: Real-Time Sync, Automated

Data Export & Advanced Analytics

Why Connect Odoo to Google BigQuery?

Odoo is excellent at capturing operational data every sale, purchase, inventory movement, customer interaction, and financial transaction flows through it daily. But when it comes to running complex analytics, building cross-departmental reports, or handling large-scale data queries, Odoo's built-in reporting tools have their limits. That's where Google BigQuery comes in.

BigQuery is Google's fully managed, serverless data warehouse built to run fast SQL queries across billions of rows in seconds. Connecting it to Odoo means you can take your operational data out of the ERP and into a purpose-built analytics environment, where it can be joined with data from other sources, visualized in tools like Looker or Data Studio, and queried at a scale that Odoo alone can't match.

The Odoo BigQuery Connector by Creyox makes this connection automated, bidirectional, and fully configurable without requiring a data engineering team or custom API work. You define which Odoo models and fields to sync, how often, and in which direction. The connector handles the rest.

Overview

The Creyox BigQuery Connector for Odoo enables seamless, automated data synchronization between your Odoo ERP and Google BigQuery. It supports both directions: you can export specific Odoo data such as sales records, customer information, and inventory details directly into BigQuery for analytics and reporting, and you can import data from BigQuery back into Odoo to keep your ERP records current.

What makes this connector particularly flexible is the level of control it gives you over the sync process. Rather than forcing a full-table dump every time, you can select exactly which fields to include in each operation and apply filter domains to restrict which records get processed. This means you're only moving the data you actually need keeping operations lean and BigQuery costs predictable.

The connector fully supports multi-company Odoo setups, letting each company maintain its own BigQuery configuration and manage data operations independently. Every import and export is logged inside BigQuery, giving you a detailed, timestamped history of all data transfers for auditing and troubleshooting. Scheduled tasks can be configured to run automatically at predefined intervals, ensuring data stays synchronized without any manual intervention.

Hot Features

◆ Real-Time Data Sync.

◆ Data Import & Update.

◆ Data Transformation Options.

◆ Easy-to-Configure Settings.

◆ Smart Data Availability Check.

◆ Continuous Synchronization.

◆ Seamless Communication.

◆ User-Friendly Notifications.

◆ Scheduled Data Import.

◆ Powerful Analytics.

◆ Dynamic Table Selection.

◆ Seamless Data Export Automation.

Features

◆ Real-Time Response Capture.

◆ Effortless Data Transfer.

◆ Automated workflows for periodic data syncing.

◆ Automatic Mapping.

◆ Comprehensive Logging in BigQuery.

◆ Scheduled Data Import/Export.

◆ Two-way sync between Odoo and BigQuery, enabling seamless data exchange in both directions.

◆ User-Friendly Setup and Configuration.

Navigate to the BigQuery Connector. There you will find the menu for BigQuery Settings. Click on New to create a new configuration.

Here you can configure BigQuery with your credentials.
Select the appropriate company for your configuration, then click the Verify settings button to test the connection. Upon successful verification, the configuration status will change to Verified.

Navigate to BigQuery Operation >> New to create a new data operation.

Select the configuration you want to use for this operation.
Choose the target model/table for the operation .
Select the type of operation: Import Data or Export Data.

To work with specific columns: Select Model columns to choose which fields to include in the operation , If no columns are specified, all columns will be processed by default.
To work with specific records: Add conditions in the Filter Domain to restrict which data is processed, If no domain filter is added, all records will be processed by default.

If you want to perform this operation immediately, then click run manually .
Upon successful completion, a notification will appear confirming that the operation is complete.
imported data can be found in Odoo, while exported data will be available in BigQuery.

if you want to perform this operation occasionally then specify time in scheduler time and units then Click Create Scheduler to save the automated task.

To modify an existing scheduler: Click Edit Scheduler to update the timing, configuration, or other settings.
To remove a scheduler: Click Delete Scheduler to permanently remove the automated task.

For Setting up Operations for Multiple Models Simultaneously , Navigate to BigQuery Scheduler .
Click New to create a multi-model operation This allows you to configure data operations across multiple models in a single scheduler

Specify the configuration you want to use for this multi-model operation

Navigate to Settings , There you can find section for Models to Export
Enter the Time in which You want to Automatically Export data from odoo to BIgQuery.
Select The tables that you want to export >> click on button Create Scheduler

If you want to perform this operation immediately, then click run manually .
To modify an existing scheduler: Click Edit Scheduler to update the timing, configuration, or other settings.
To remove a scheduler: Click Delete Scheduler to permanently remove the automated task.

Navigate to Settings , There you can find section for Models to Import
Enter the Time in which You want to Automatically Import data from BIgQuery to odoo .
Select The tables that you want to Import >> click on button Create Scheduler

If you want to perform this operation immediately, then click run manually .
To modify an existing scheduler: Click Edit Scheduler to update the timing, configuration, or other settings.
To remove a scheduler: Click Delete Scheduler to permanently remove the automated task.