Build management dashboards from BigQuery instead of slowing down live Odoo.

Analyze sales, inventory, accounting and custom module data in Tableau.

Create shareable reports for teams, managers and clients using BigQuery data.

Store Odoo data in a warehouse built for SQL, BI, AI and large analytics workloads.

No repeated full-table exports

After the first load, the connector can continue from the last sync point and send only records that are new or changed. This saves time, reduces unnecessary load, and makes frequent reporting realistic.

Dashboards stay close to live

Run scheduled exports as often as every 1 minute. Sales, inventory, accounting, and operations dashboards can stay close to current Odoo activity without manual CSV work.

Real update logic in BigQuery

Sync cursors, batching, and BigQuery MERGE logic help update existing rows and insert new rows properly. BigQuery receives updated business data instead of duplicate table dumps.

Export exact business slices

Create focused exports for posted invoices, confirmed sales, active products, selected companies, specific warehouses, or any custom Odoo condition your reporting team needs.

Cleaner tables from the start

Keep cancelled, archived, draft, test, or irrelevant records out of BigQuery when the dashboard does not need them. Less noise means faster analysis and fewer report mistakes.

Reporting logic stays visible

The export definition itself shows the business rule used to build the BigQuery table. Teams can understand why a dataset contains certain records instead of guessing later.

Google Cloud project

Point the connector to the correct project and dataset before exports begin.

Service account JSON

Authenticate Odoo with BigQuery using a service account key.

Admin-friendly setup

No separate script is needed. The connector is managed from Odoo UI.

Column control

Export only the fields the report needs, not every column from Odoo.

Domain filter

Restrict records before they reach BigQuery using Odoo domain logic.

Incremental sync

Track timestamp and ID cursors so updates can continue without full rebuilds.

Scheduled export

Run exports automatically at configured intervals, including near real-time 1-minute export cycles.

Red error state

If a query fails, the error state is clearly visible in red so admins know it needs attention.

Reset Stuck State

If a query is stuck because a previous run was interrupted, the Reset Stuck State button appears.

Clear Error

When an export error exists, Clear Error appears so the admin can clean the visible state after fixing the cause.

Hard Refresh

Hard Refresh can resend the whole table again when a clean rebuild is required.

Date filters

Filter logs by Today, Last 7 Days, Last 30 Days, Last Month or custom ranges.

Event filters

Review starts, batches, cron runs, successes, warnings, errors and stuck events.

Rows exported

Track moved rows, last batch activity and current run progress.

Debug details

Use messages, severity and run tokens to understand exactly what happened.

Time filters

Review recent edits with filters like Last 30 Days, Last Month and custom date ranges.

Configuration history

See changes to table, fields, domain filters and incremental settings.

Before and after

Understand what changed instead of guessing why an export behaves differently.

User visibility

Track who changed important export configuration when reviewing issues.

Batch processing

Large tables are processed in controlled batches instead of one fragile all-at-once export.

Cursor based export

Last sync timestamp and last synced ID help incremental exports continue safely.

Lock protection

Export locks and stuck-state detection reduce duplicate run confusion.

Staging tables

Each batch can land in temporary BigQuery staging before final table update.

BigQuery MERGE

Existing rows are updated and new rows are inserted using record keys.

Type conversion

Odoo values are transformed for BigQuery types such as string, integer, float, boolean, timestamp and date.

Connector user group

Allow controlled access to connector menus and safe review actions.

Connector manager group

Limit setup, query creation and recovery actions to trusted users.

Safer workflow

Separate export administration from regular Odoo usage.

Any Odoo table

Create separate export definitions from Odoo source tables and custom models.

Column selection

Choose only the fields required by reporting teams.

Odoo domain filtering

Export only records that match the business reporting condition.

Incremental sync

Repeated exports can focus on new and changed rows instead of rebuilding the full table every time.

Scheduled export

Set automatic export intervals per query, including a 1-minute cycle for near real-time reporting.

Manual run

Run an export immediately when data is needed now.

Hard Refresh

Resend the whole table again when a clean rebuild is required.

Clear Error

Clear visible error state after fixing the root cause.

Reset Stuck State

Recover a query when an interrupted run left the lock active.

Query logs

Audit run events, row counts, errors, warnings and progress.

Change logs

Review what changed in export configuration and when.

BI ready

Feed BigQuery into Power BI, Looker Studio, Tableau, SQL and AI tools.

Sales dashboards

Move orders, order lines, invoices, customers and sales team data to BigQuery.

Inventory reporting

Analyze product movement, quantities, warehouses and operational history.

Finance analytics

Export accounting data for revenue, margin, payment and compliance reporting.

AI analysis

Use warehouse data for AI analysis without giving tools direct load on Odoo.

Custom module reporting

Export custom module data when the model and selected fields are available.

Executive reporting

Create fast reporting layers for founders, managers and department heads.

Can I filter what gets exported?

Yes. Use Odoo domain filters to restrict records before they reach BigQuery.

Can I choose only required fields?

Yes. Select exact columns per query instead of exporting every field by default.

Does it support incremental sync?

Yes. Enable incremental auto export per query, then use the sync cursor so future runs focus on new and changed rows.

What happens if an export fails?

The query shows an error state. Admins can inspect logs, fix the issue and use Clear Error when appropriate.

What if a query gets stuck?

Reset Stuck State appears when a stuck lock state needs recovery after an interrupted export.

Can I rebuild a table?

Yes. Hard Refresh can resend the whole table again when a full rebuild is required.