BigQuery Connector - Powerful Analytics for Instant Insights
by Softhealer Technologies https://www.softhealer.com$ 161.56
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1726 |
| Technical Name |
sh_bigquery_connector |
| License | OPL-1 |
| Website | https://www.softhealer.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1726 |
| Technical Name |
sh_bigquery_connector |
| License | OPL-1 |
| Website | https://www.softhealer.com |
| Versions | 18.0 19.0 |
BigQuery Connector - Powerful Analytics for Instant Insights
The Odoo BigQuery Connector allows you to transfer your Odoo data into Google BigQuery for reporting, analytics and data warehousing. It provides a simple setup where you can connect your Google service account, select your dataset and move key business records from Odoo to BigQuery. This helps users analyse large volumes of Odoo data using BigQuerys powerful cloud-based processing.
Related Modules
Features
Connect Odoo with Google BigQuery
Easily configure your Google project, dataset and service account JSON key inside Odoo.
One Click Sync - One Click Data Transfer
A simple button lets you perform immediate data transfer without extra configuration.
Real-Time Data Sync
Instantly pushes updated Odoo data to keep all connected systems always up to date.
Select Odoo Models to Export
Choose which Odoo models (like Sales Orders, Products, Invoices, Customers etc.) you want to send to BigQuery.
Powerful Analytics Dashboard
Visualize your BigQuery data within Odoo using a dedicated, interactive dashboard.
Comprehensive Synchronization Logs
Track every data transfer with detailed logs, including success status and error messages.
Multi-Company Support
Manage and synchronize BigQuery integration separately for multiple companies within a single Odoo environment.
Export Odoo Data to BigQuery
Send data from Odoo into BigQuery for reporting and analytics, map them into BigQuery table columns.
Safe Data Transfer Using Google APIs
Communication with BigQuery uses trusted Google API endpoints for secure and reliable transfers.
User-Friendly Notifications
Shows clear alerts and messages to keep users informed without disrupting workflow.
Google Cloud Security
Uses Google-approved authentication through service account JSON for secure access.
Automated Data Synchronization
Schedule regular data transfers from Odoo to BigQuery using automated cron jobs.
Import BigQuery Data into Odoo

You can now import data directely from the BigQuery to Odoo and you can also create schedueled actions for the same.
Test Connection Functionality
You can now also test the connection in the BigQuery Configuration by entering the required credentials.
Sync Log History list view.
Click View button to view the list of records synced.
Sync Log History of the Account Records which were synced in the previous sync.
In the Import Data list view.
Viewing an import data record with scheduled import time.
Click Run Manually to run Import data schedueled actions.
Click Run Manually in the Import Data to manually import the data.
Message displaying the successful imports of the data.
Creating a record for the Contacts imports whose record is already being created previously.
Now click to Create Schedueler.
A pop-up of Invalid Operation indicated that an active schedueled import already exists for the same model, so update the configuration instead of creating a new one.
Activating the Automations for Journal model in the configuration .
Click run manually to run the automation scheduled actions.
Click the Sync Now to sync the records.
Message in the sync log history defines that the records were successfully synced.
We can see that in the Sync Log History Journal Records list view.
BigQuery Dashboard view.
Highlighted the Connection & Configurations tab on the dashboard.
BigQuery configuration list view.
Highlighted the Export Automations tab on the dashboard to Sync records.
Select the model to Export Records.
Successfully exported records.
Highlighted the Import Schedulers tab on the dashboard.
BigQuery dashboard import data list view.
Highlighted the Manual Operations tab on the dashboard.
Click on the Export Now button.
Select the model to Export Data and click Export button.
Click on the Import Now button to import records.
Imported data list view.
Highlighted the successful Syncs tab on the dashboard.
List view of the successful sync logs.
Highlighted the Failed Syncs tab on the dashboard.
Failed Sync logs list view.
You can also select the date range and company to filter records on the sync dashboard.
BigQuery Configurations for a specific company.
BigQuery Configuration for the multi-company.
Goto BigQuery Connector.
BigQuery Configurations.
Select a BigQuery configuration.
Enter the required credentials and click Test Connection to test the BigQuery connection.
Message of successful connection.
Go to the 'Settings'.
Go to the 'Big Query Connector'.
Fill the 'BigQuery Configuration' data.
Click on the "BigQuery" from the Navigation menu.
Click on the "Create Project" button to create a new project.
Click on the "Create dataset" from the three dot.
Here, you can see the created dataset ID. Copy it and paste it into the Odoo module's 'BigQuery Configuration'.
Copy the project ID and paste it into the Odoo module's 'BigQuery Configuration'.
Go to the 'IAM and admin' ==> 'Service accounts'.
Click on the "Create Service Account" button to set up a new service account.
Click on the "Manage Keys" from the three dot.
Under "Add Key", click on the "Create new Key".
Choose the "JSON" key type and click on the "Create" button.
Here, you'll find the JSON file. Copy the JSON credentials from the link and add them to the Odoo module's 'BigQuery Configuration'.
Go to the Export Data menu.
Select the model and click on the "Export" button.
After the data is successfully exported, a "Success" pop-up will appear.
You can find the exported model in the project dataset.
Version 19.0.2.0.0 | Released on : 04th June 2026
Version 19.0.1.0.0 | Released on : 2nd January 2026
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
- No, this application is not compatible with odoo.com(odoo saas/Odoo Online)
- Yes, to test this module, please contact us at sales@softhealer.com.
- Please contact us at sales@softhealer.comto request customization.
- Yes, we provide free support for 365 days from the date of purchase.
- Yes, you will receive lifetime free updates for the version of the module you purchased.
- No, there is no need to install any additional libraries.
- Yes, for version 12 and above, you need to purchase the module separately for each version you intend to use.
- No, exchanges or refunds are not allowed. Please make sure to select the correct version before purchasing.
- You can contact us at support@softhealer.com for language translation support. We use Google Translator tools to provide translations in multiple languages, so the accuracy may vary. We welcome your suggestions to help improve translations.
Discover Our Latest Apps
Odoo Direct Print
AI Insight Assistant
- Dedicated AI Chat Interface
- Instant Response Engine
- Intelligent Data Understanding
Knowledge Base System
Multi-Languages
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