Odoo BigQuery Connector: Real-Time Sync, Automated Data Export & Advanced Analytics

Overview

The BigQuery Odoo Connector enhances data management by enabling seamless data synchronization between Odoo and Google BigQuery, with support for multi-company configurations. This integration allows businesses to export specific fields from Odoo, such as sales records, customer information, and inventory details, directly into BigQuery for advanced analytics and reporting, with custom data filters to selectively sync relevant data. Similarly, selected fields from BigQuery can be imported back into Odoo using custom filters, ensuring critical business information remains up-to-date across multiple companies.

With this connector, Odoo records are mapped to BigQuery tables, with the ability to select specific fields for export and import operations. Real-time syncing options are available for live data requirements, and multi-company setups are fully supported, allowing each company to manage its data independently. Each data export and import operation is logged within BigQuery, providing a detailed history and status of data transfers. By reducing manual data handling and centralizing analytics within BigQuery, this connector empowers teams to make data-driven decisions, improve operational visibility, and streamline reporting, ultimately enhancing business efficiency.

The BigQuery Odoo Connector supports automated workflows for importing and exporting data, with customizable field selection for both operations. Businesses can configure scheduled tasks to automatically sync data between Odoo and BigQuery at predefined intervals, ensuring that data for each company is always up-to-date without 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.

Odoo BigQuery Connector

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.