BigQuery Pro : Filtering, Batching & More

$ 607.42

v 18.0 Third Party

Availability	Odoo Online Odoo.sh On Premise
Lines of code	521
Technical Name	`odoo-bigquery`
License	OPL-1
Website	https://niyulabs.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
Lines of code	521
Technical Name	`odoo-bigquery`
License	OPL-1
Website	https://niyulabs.com
Versions	15.0 16.0 17.0 18.0

Description
License

Tired of slow, costly data dumps from Odoo? This connector lets you intelligently export exactly the Odoo data you need to BigQuery. Use standard Odoo filters and pick specific columns for faster, cheaper analytics.

Export filtered Odoo data and selected columns directly to Google BigQuery. Stop dumping everything, start saving time and money.

What You Feel While Using?

Lower BigQuery Bills

Export only needed records using Odoo domains to drastically cut BQ storage & query costs.

Faster, Cleaner Data

Select specific columns for quicker exports and cleaner datasets in BigQuery, saving more costs.

Export Large Tables Reliably

Batch processing ensures even million-record tables export smoothly without crashing Odoo.

Unlock Advanced Analytics

Move beyond basic Odoo reports; leverage BigQuery for deep insights, BI tools, and AI/ML.

Features

Export Any Odoo Table

Select any standard Odoo table (like Sales Orders, Invoices, Products, Contacts) and push its data to BigQuery effortlessly. Works with all native and custom modules, giving you complete access to your business data for analytics.

Screenshot showing the table selection dropdown in the module's configuration for selecting Odoo tables to export

Precise Record Filtering

Use standard Odoo domain filters [('field', 'operator', 'value')] to select exactly which records to export. Only send the data you actually need, reducing transfer volumes and keeping your BigQuery instance lean and efficient.

Close-up screenshot of the domain filter field where users enter standard Odoo filters

Specific Column Selection

Choose exactly which fields to send to BigQuery instead of exporting entire tables. This targeted approach accelerates exports and directly reduces your BigQuery storage and query costs.

Screenshot highlighting the easy selection of specific table columns for export to BigQuery

Handles Large Tables

Our intelligent batching system exports data in manageable chunks, reliably handling tables with 1M+ records. Prevents timeouts and keeps your Odoo system stable even during massive exports.

Screenshot showing export log for extra large dataset

Incremental (CDC) Exports (Pro Plus Only)

Incremental Change Data Capture (CDC) exports ensure that only new or updated records are sent to BigQuery after the initial full export. This minimizes data transfer, reduces costs, and keeps your BigQuery dataset up-to-date with the latest changes in Odoo. Ideal for businesses requiring frequent updates without re-exporting entire tables.

Screenshot showing successful large export log with batch processing details

💡 Tips, Tricks & Positive Insights

💡

Filter Aggressively: The more specific your Domain Filter, the faster the export and the lower your BQ costs. Don't pull data you don't need today.
📊

Select Columns Wisely: Every extra column adds time and cost. Only select columns required for your specific BigQuery analysis or reports.
💸

Understand BigQuery Pricing: Remember BigQuery charges for storage and compute (queries). This connector helps minimize both by sending less data.

Choose Your BigQuery Connector Plan

Pricing Plans

Select the perfect plan for your Odoo to BigQuery integration needs

BigQuery Connector Pro

$599

Best for Small to Moderate Data

*Sold on Odoo App Store only

✅

Odoo Data Export

Export Odoo tables to BigQuery
✅

Domain Filtering

Filter records using standard Odoo domains
✅

Column Selection

Choose specific columns to export
✅

Batch Export

Handles around 1M records reliably in chunks
❌

Incremental (CDC)

Exports whole table in each sync
❌

Scheduled Refresh

Manual run only (no automation)
❌

Real-time Refresh

Not available
❌

Free Odoo Upgrades

Purchase per version required
✅

Support

21 Days Free
❌

Code Obfuscation

Standard OPL-1

Get Pro on Odoo App Store

BigQuery Connector Pro Plus

$999

Best for Large Data / Frequent Updates

Sold exclusively on our website

✅

Odoo Data Export

Export Odoo tables to BigQuery
✅

Domain Filtering

Filter records using standard Odoo domains
✅

Column Selection

Choose specific columns to export
✅

Enhanced Batch Export

Works well and Tested on 8M+ records.
✅

Incremental (CDC)

Exports only new/changed records after initial run
✅

Scheduled Refresh

Set automatic refresh intervals (based on data-size and need)
✅

Real-time Refresh

Near real-time sync (down to 1 min intervals)
✅

Free Odoo Upgrades

Get connector updates for new Odoo versions at no extra cost
✅

Extended Support

3 Months of support included
✅

Code Obfuscation

Enhanced protection for your investment (prevents piracy)

Get Pro Plus at niyulabs.com

Not sure which plan is right for you? Contact our team for personalized guidance.

Frequently Asked Questions

↠ How easy is setup? ♥

Standard Odoo module install. Enter your BQ Project ID, Dataset ID, and Service Account JSON in Settings. Done.

↠ What support is included? ♥

21 days of free email support for installation and configuration issues for the Pro version.

↠ Which Odoo versions are supported? ♥

Check the compatible versions listed on this page (currently supports Odoo 15.0, 16.0, 17.0, 18.0). Newer Odoo versions require a separate purchase for the Pro license.

↠ How does it handle millions of records? ♥

It exports in batches (configurable size) to avoid timeouts and memory issues. For very large data, consider the Pro Plus variant.

↠ Does Pro handle new records? ♥

Yes. The Pro version exports based on your filters each time. The full filtered table is exported on each run. True incremental export (CDC) is a Pro Plus feature after the initial full export, only new or updated records are synced.

↠ When do I need Pro Plus? ♥

If you work with very large, frequently changing datasets and need only changes synced automatically, or require scheduled/near real-time updates, or want free upgrades for future Odoo versions.

↠ What are your pricing models? ♥

We work exclusively on a project-based pricing model to ensure predictable costs and comprehensive solutions. Contact us for a customized quote tailored to your specific requirements.

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.