$ 300.28
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 743 |
| Technical Name |
eb_obq_integration |
| License | OPL-1 |
| Website | https://www.echobitzit.com/ |
| Versions | 15.0 16.0 17.0 18.0 19.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.
📦 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.
Need Odoo Support?
FAQS
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.
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.
Yes, you can sync data from any Odoo model (standard or custom) such as Contacts, Sales, Invoices, Products, or custom modules.
Absolutely! You can map Odoo fields with corresponding BigQuery columns, including custom fields.
The integration supports Manual Sync and Scheduled Sync options.
Yes, you can define domain filters in Odoo to sync only specific records (e.g., confirmed orders, active customers).
Updates are reflected in BigQuery during the next sync. For deletions, you can configure whether to remove them from BigQuery or keep them archived.
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
- Prerequisites
- Python 3.7 or later
- Odoo 15.0 or later
- Install Dependencies
- pip install google-cloud-bigquery google-auth
Credits
Contributors
- echoBitz IT Solutions Pvt. Ltd. <info@echobitzit.com>
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