Skip to Content
Menu

300.08

v 18.0 Third Party
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 743
Technical Name eb_obq_integration
LicenseOPL-1
Websitehttps://www.echobitzit.com/
Versions 15.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 743
Technical Name eb_obq_integration
LicenseOPL-1
Websitehttps://www.echobitzit.com/
Versions 15.0 16.0 17.0 18.0

Odoo BigQuery Integration

The Odoo BigQuery Integration seamlessly connects your Odoo database with Google BigQuery, enabling businesses to centralize, analyze, and visualize their data in real-time. With this integration, you can automatically sync data from any Odoo model into BigQuery tables, ensuring your business operations, sales, finance, inventory, and customer insights are always up to date in your data warehouse. The integration is designed to support one-way synchronization, offering flexibility in managing data flow between Odoo and BigQuery.

Built with scalability in mind, this integration supports multiple sync modes including manual and scheduled operations. You can define custom field mappings, apply domain filters, and choose from various write modes like replace, append, or merge. Whether you want to generate advanced analytics, or simply ensure data consistency between systems, the Odoo BigQuery Integration provides a reliable, automated solution to bridge the gap between your ERP and your data warehouse.



Seamless Data Synchronization - Automatically sync records between Odoo and Google BigQuery.
Multi-Model Support - Connect and sync data from any Odoo model (Contacts, Sales, Invoices, Products, etc.).
Flexible Sync Modes - Supports Manual and Scheduled synchronization.
Custom Field Mapping - Define and manage field mappings between Odoo fields and BigQuery columns.
Write Modes - Choose from Replace, Append, Empty Only, or Merge (Upsert) to control how data is handled.
Domain Filters - Apply filters to sync only relevant records (e.g., active customers, confirmed sales orders).
Scheduler Integration - Automate periodic syncs with Odoo's built-in cron jobs.
Scalable & Reliable - Designed to handle large datasets efficiently for enterprise-grade use.

📦 Version 1.0.0 – Initial Release

  • First stable release of Odoo BigQuery Integration – Odoo 15, 16, 17, 18 Version.

Setup

Click the 'Select a Project' button.


Click the 'New Project' button.


Enter the project name, then click the 'Create' button.


Click 'IAM & Admin,' then click 'Service Accounts.'


Click the '+ Create Service Account' button.


Enter the service account name, then click the 'Create and Continue' button.


Select 'Owner' as the role, then click the 'Continue' button, and finally click the 'Done' button.


Click the 'Email' link.


Click the 'Keys' menu, then click the 'Add Key' button, and finally click the 'Create New Key' button.


Select 'JSON,' then click the 'Create' button.


Copy the key and paste it into the 'Service Account JSON' field.


Click the 'BigQuery' menu.


Click the three dots, then click the 'Create Dataset' button.


Enter the Dataset ID, then click the 'Create Dataset' button.


Click 'odoo,' then copy the Dataset ID.


Copy 'lithe-willow-469806-e8.odoo' and paste it into the 'BigQuery Project ID' and 'Dataset ID' fields.


Enter the Odoo model name, then click the 'Execute Sync' button.


The Odoo Contact fields and contact records should be synced in BigQuery.


Demo & Support

We're here to help! Whether you need assistance with Odoo app installation, customization, or have any technical or functional questions, our support team is just a call or click away. Choose your preferred method to connect with us - phone, email, or schedule a meeting. You can also explore our detailed video playlist for step-by-step guidance.

Schedule Meeting

Need Odoo Support?

(+91) 98700 62925
Schedule a Meeting

FAQS

What is Odoo BigQuery Integration?

Odoo BigQuery Integration is a module that allows you to connect your Odoo database with Google BigQuery, enabling seamless one-way data synchronization for reporting, analytics, and business intelligence.

What are the available write modes in Odoo BigQuery Integration?

Odoo BigQuery Integration supports four write modes when inserting or updating data: WRITE_TRUNCATE (overwrites the table with new data), WRITE_APPEND (adds new rows without affecting existing data), WRITE_EMPTY (only writes if the table is empty), and USING_MERGE (performs upserts by updating existing rows or inserting new ones). This flexibility allows you to choose the best strategy based on your business requirements.

Can I sync any Odoo model with BigQuery?

Yes, you can sync data from any Odoo model (standard or custom) such as Contacts, Sales, Invoices, Products, or custom modules.

Does it support custom field mappings?

Absolutely! You can map Odoo fields with corresponding BigQuery columns, including custom fields.

What data sync modes are available?

The integration supports Manual Sync and Scheduled Sync options.

Can I filter which records to sync?

Yes, you can define domain filters in Odoo to sync only specific records (e.g., confirmed orders, active customers).

What happens if I update or delete records in Odoo?

Updates are reflected in BigQuery during the next sync. For deletions, you can configure whether to remove them from BigQuery or keep them archived.

Can I schedule automatic syncs?

Yes, you can use Odoo's cron jobs to run periodic syncs automatically without manual intervention.

Free Support for 365 Days

We believe that great apps deserve great support. That's why every purchase of our Odoo apps comes with 365 days of free expert support-no hidden fees, no hassle. Whether you need help with installation, customization, or troubleshooting, our team is here to guide you every step of the way. We're committed to ensuring your Odoo experience is smooth, efficient, and worry-free. With fast response times and professional assistance, you can focus on growing your business while we handle the tech. Start strong with support you can count on-for free, for the first 365 days.

Demo & Video

Schedule Meeting for Any Query

watch video playlist

Our Services

Odoo Integration

Seamlessly integrate Odoo with third-party apps, platforms, and tools for better workflow.

Odoo Implementation

We plan, configure, and deploy Odoo tailored to your business processes.

Customization

Get modules and workflows customized to meet your exact needs in Odoo.

Community Apps

Access or develop robust community apps to enhance your Odoo functionality.

Development Outsourcing

Hire dedicated Odoo developers to build solutions efficiently and cost-effectively.

Support & Maintenance

Enjoy peace of mind with our reliable support, updates, and bug fixing services.

A Powerful Integration App for Odoo and BigQuery

Odoo BigQuery Integration is an innovative integration app that bridges the gap between two industry-leading platforms, Odoo and BigQuery. With its advanced features and intuitive design, it empowers businesses to automate facilitate real-time updates, streamline workflows, and eliminate the need for manual synchronization. By Odoo BigQuery Integration integrating these two powerful systems, Odoo BigQuery Integration offers unparalleled efficiency and productivity, allowing businesses to focus on what matters most—growing their customer base and driving revenue.

Installation

  1. Prerequisites
    • Python 3.7 or later
    • Odoo 15.0 or later
    • Install Dependencies
      • pip install google-cloud-bigquery google-auth

Credits

Contributors

Author & Maintainer

This module is maintained by the echoBitz IT Solutions Pvt. Ltd.

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.