Pro BigQuery Connector - Filtering, Batching & Schedule Export
by Niyu Labs https://niyulabs.com$ 447.40
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 681 |
| Technical Name |
odoo-bigquery |
| License | OPL-1 |
| Website | https://niyulabs.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 19.0 |
Your BI, Supercharged.
One click to sync Odoo data directly to Google BigQuery. Instantly connect to Power BI, Looker Studio, and Tableau to build **enterprise-grade dashboards** that empower your team and drive critical business decisions.
Activate Your Analytics Stack
Your BigQuery data is the fuel. These are the engines. Connect your clean, structured Odoo data to the platform of your choice and start building **powerful, interactive dashboards** that drive decisions and reveal hidden insights.
Build a Production-Ready Model
The definitive path for building scalable, high-performance BI on an Odoo + BigQuery stack. Connect with confidence and unlock advanced analytics.
Leverage the native BigQuery Connector, enable **Incremental Refresh** for cost savings, and centralize complex business logic using **DAX Measures** to guarantee a single, high-performance source of truth.
Read the Integration Guide
Ship Insights at High Velocity
Create beautiful, shareable dashboards that are fast, intuitive, and accessible to your entire team, fostering a data-driven culture.
Connect directly with Viewer's Credentials, leverage BigQuery **Views** for pre-aggregation, and utilize **Data Extracts** to ensure near-instant load times while minimizing query costs.
Read the Integration GuideVisual Storytelling & Deep Dives
Connect Tableau's powerful analytics engine to your BigQuery data for unparalleled data exploration and insight, empowering business users to ask and answer their own questions.
Choose between **Live Connections** for real-time data or **Extracts** for high-speed performance, leveraging Tableauâs relationship model for complex joins and seamlessly publishing compelling dashboards.
Read the Integration Guide
Unmatched Control Over Your Data Pipeline
Go beyond simple data dumps. Our connector gives you the tools to build an efficient, cost-effective, and automated data sync solution, tailored precisely to your business needs.
Precise Record Filtering
Gain granular control by using standard Odoo domain filters to select exactly which records to export. Sync only active customers, completed orders, posted invoices, or specific product lines, keeping your BigQuery dataset lean, relevant, and optimized for analysis.
Targeted Column Selection
Why export everything? Choose exactly which fields (columns) to send to BigQuery. This targeted approach accelerates export times, simplifies your BigQuery data models, and directly reduces your storage and processing costs, ensuring data privacy by design.
Incremental & Automated Syncs
Set it and forget it! Configure a schedule and sync only new or changed records since the last run. This intelligent incremental loading keeps your BI dashboards updated automatically in near real-time without costly full-table reloads, saving time, bandwidth, and significant processing costs.
Intelligent Schema Handling for BigQuery
Our connector intelligently translates complex Odoo field types into clean, BigQuery-compatible columns, saving you countless hours of manual data wrangling and ensuring **data integrity** from source to insight.
Field Type Translation Details
Automatically exports both the related record's `ID` (e.g., `partner_id`) and its human-readable `Name` (e.g., `partner_name`) for easy joining and reporting.
Converts internal Odoo keys (e.g., `'draft'`) to their user-friendly labels (e.g., `'Draft'`), making your BigQuery data instantly understandable for business users.
Ensures all date and datetime fields are correctly formatted to ISO 8601 standards, enabling seamless time-series analysis and filtering in your BI tools.
Automatically maps Odoo numeric types to BigQuery `INTEGER`/`FLOAT` and boolean fields to `BOOL`, preserving data accuracy and integrity.
Your Data, Your Control. Absolutely Secure.
Security is the foundational pillar of our connector. Your sensitive Odoo data flows **directly and securely** from your Odoo instance to *your own* Google Cloud project using a dedicated Service Account. This means no middlemen, no third-party servers, and complete ownership and auditability of your data's journey.
Connector in Action
A closer look at the features and interface.
Fig 1: Effortless Export Profile Configuration
Fig 2: Real-time Sync Status & Detailed Logging
Fig 3: Advanced Field Mapping Interface
Fig 4: Automated Scheduling for Incremental Syncs
Installation & Effortless Configuration
From initial installation to your first successful data sync, get up and running in just a few straightforward steps, designed for both technical and business users.
Quick Start Guide:
- Acquire the Module: Purchase and download the "Odoo to BigQuery Connector" from the Odoo App Store.
- Install in Odoo: Add the module to your custom addons directory and install it via Odoo's Apps menu (or deploy via Odoo.sh/your hosting provider).
- Google Cloud Setup: In your Google Cloud Platform project, create a dedicated Service Account and grant it "BigQuery Data Editor" and "BigQuery Job User" roles for necessary permissions.
- Secure Key Upload: Navigate to Settings â BigQuery Connector in Odoo and securely upload the JSON key file generated for your Google Cloud Service Account.
- Configure Your First Export: Create a new export profile, select your desired Odoo model (e.g., `Sales Order`), choose the specific columns you need, set up any required filters, and **initiate your first automated data sync!**
Compatibility & Core Requirements
- Odoo Version: Compatible with Odoo 14, 15, 16, and newer versions.
- Google Cloud: An active Google Cloud Platform Account with BigQuery API enabled.
- Connectivity: Reliable internet access from your Odoo server for API calls to Google Cloud.
- Deployment: Fully functional with both On-premise Odoo installations and Odoo Cloud hosting environments.
- Security Best Practice: We recommend using a dedicated Service Account with least-privilege permissions.
Frequently Asked Questions
Find quick answers to common questions about our Odoo to BigQuery Connector.
What do I need to use this module?
You will need an active Odoo instance (v14 or later), a Google Cloud account with BigQuery enabled, and a Service Account from that project with "BigQuery Data Editor" and "BigQuery Job User" permissions. This ensures secure and authenticated access to your BigQuery datasets.
How is my data kept secure during transfer?
Data security is paramount. The connector establishes a direct, encrypted connection (via HTTPS) between your Odoo server and Google's BigQuery API. Your data is never routed through or stored on any third-party servers. Access is controlled entirely by the Google Cloud Service Account key that you securely provide and manage within your Odoo instance.
Does it work with my custom Odoo modules and fields?
Absolutely. The connector is designed to dynamically read your entire Odoo database schema. This includes any custom modules you have installed, custom fields you have added to standard models, and completely new custom models. You can easily select these custom fields and models for export just like standard Odoo fields.
What are the costs involved in using this solution?
You purchase the "Odoo to BigQuery Connector" module license one-time from the Odoo App Store. There are no additional recurring subscription fees from us. The only ongoing operational costs are for your usage of Google BigQuery (for data storage, streaming inserts, and querying), which is billed directly by Google Cloud based on your consumption.
Can I schedule automatic exports and incremental updates?
Yes, absolutely. The module fully leverages Odoo's powerful built-in automation server (Scheduled Actions). You can configure any data export profile to run on a schedule you define â whether that's hourly, daily, weekly, or monthly â enabling fully automated, incremental data synchronization to BigQuery without any manual intervention.
Where can I find documentation or get support if I need help?
Detailed documentation, including step-by-step setup guides and best practices, is available on this product page and on our official website at https://niyulabs.com. For technical support, bug reports, or any questions, please do not hesitate to contact our dedicated support team directly at info@niyulabs.com. We're here to help!
Transforming Odoo Data Integration Starts Here.
Stop struggling with manual data exports and start leveraging your Odoo data strategically. Empower your business analysts, build powerful, real-time dashboards, and accelerate data-driven business growth with our seamless, secure, and highly efficient data pipeline solution.
Contact Us for a Demo: info@niyulabs.com. Click here to get a live demoOdoo 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 team helped connect odoo to power bi via big query without complex setup. Apparently power bi has inbuilt integration with bigquery, appreciate it. would reccomend
There are no comments yet!