Pro BigQuery Connector - Filtering, Batching & Schedule Export
by Niyu Labs https://niyulabs.com$ 399.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 653 |
| Technical Name |
odoo-bigquery |
| License | OPL-1 |
| Website | https://niyulabs.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 |
The Smartest Way to Sync Odoo with BigQuery.
Stop dumping data. Start saving money. Intelligently export filtered Odoo data and specific columns directly to Google BigQuery.
What's New & What's Next
You Get 50 USD discount on your next purchase
Precise Record Filtering
Use standard Odoo domain filters to select exactly which records to export. Sync only confirmed sales orders, invoices from the last quarter, or partners from a specific country.Flexible Filtering: Leverage Odoo’s powerful domain syntax to build complex conditionsâcombine multiple fields, operators, and logical groupings to target just the data you need.
Real-World Examples:
- Export only paid invoices from the last 12 months for financial analysis.
- Sync products with stock above a certain threshold for inventory optimization.
- Filter CRM leads by stage, region, or assigned salesperson for targeted reporting.
- Include or exclude records based on custom fields or tags—no coding required.
Targeted Column Selection
Choose exactly which fields to send. This targeted approach accelerates exports and directly reduces your BigQuery storage and query costs.Fine-Grained Control: Select only the columns you need for your analytics—skip unnecessary fields, attachments, or sensitive data.
Customizable for Any Model: Works with all Odoo models, including custom fields and modules. Pick from standard and custom columns with a simple interface.
Real—World Examples:
- Export only invoice number, date, amount, and customer for finance dashboards.
- Sync product name, SKU, and stock for inventory analysis—skip images and descriptions.
- Send only relevant CRM fields for sales reporting, omitting internal notes or attachments.
- Include or exclude columns based on compliance or privacy requirements.
Incremental & Automated Exports
Keep your BigQuery tables always up to date—without manual effort. Our connector supports incremental exports and full automation, so you only sync new or changed records on a schedule you control.
How Incremental Export Works
- Choose a date, status, or custom field to track changes (e.g.,
write_dateorlast_update). - On each sync, only records created or updated since the last export are sent to BigQuery.
- Avoids re-uploading unchanged data, saving time and bandwidth.
Automate Your Data Pipeline
- Set up scheduled exports (hourly, daily, weekly, or custom intervals) directly in Odoo.
- No manual triggers needed—your BigQuery tables stay current automatically.
- Ideal for dashboards, reporting, and real-time analytics.
Effortless Column Selection
Choose exactly which fields to export from Odoo to BigQuery. No more bloated tables—just the data you need for analytics, compliance, and reporting.
Why Column Selection Matters
- Reduce BigQuery storage and query costs by sending only relevant fields.
- Protect sensitive or internal data by excluding unnecessary columns.
- Accelerate exports and analytics with smaller, cleaner tables.
How It Works
- Select any standard or custom field from your chosen Odoo model.
- Preview your column selection before exporting.
- Easily adjust your selection at any timeâno coding required.
Solve Your Biggest Data Challenges
Our connector is engineered to overcome the most common frustrations with large-scale data exports and analytics.
Eliminate data bloat: Export only what you need, not your entire database.
Save time and money: Reduce BigQuery costs by syncing filtered records and selected columns.
Accelerate analytics: Get clean, ready-to-use datasets in BigQuery for faster reporting and insights.
Stay secure: All transfers use official Google Cloud authentication for maximum data safety.
Works with custom modules: Sync any Odoo model, including custom fields and tables.
Easy setup: Configure everything directly inside Odoo—no coding required.
Lower BigQuery Costs
Export only the records and columns you need to drastically cut storage and query expenses.
By filtering out unnecessary data and syncing just the essentials, you avoid paying for excess rows and unused fields in BigQuery.
This targeted approach means faster exports, smaller tables, and significant savings on both storage and query processing costsâespecially as your Odoo database grows.
Optimize your analytics budget while keeping your data pipeline lean and efficient.
Faster, Cleaner Data
Get cleaner datasets in BigQuery faster by being selective about what you send from Odoo.
By exporting only relevant records and columns, you avoid clutter and ensure your analytics are always based on up-to-date, high-quality data.
No more sifting through unnecessary fields or outdated informationâjust the data you need, ready for immediate analysis.
This streamlined approach means less time spent cleaning data and more time generating insights that drive your business forward.
Unlock Advanced Analytics
Leverage the full power of BigQuery for BI, AI, and deep machine learning insights.
With your Odoo data structured and filtered in BigQuery, you can:
- Build advanced dashboards in Looker Studio, Tableau, or Power BI.
- Run complex SQL queries and join Odoo data with other sources.
- Feed your data into machine learning models for forecasting and automation.
- Enable real-time analytics and reporting for faster business decisions.
- Easily share insights across teams without exposing your Odoo database.
Secure & Direct: How It Works
1. Connect Securely
Set up your Google Cloud Service Account credentials directly in Odoo. Just paste your JSON key into a secure fieldâno manual uploads or risky copy-pasting.
2. Choose Your Data
Select the Odoo model you want to export, apply advanced filters, and pick only the columns you need. Instantly preview records and fields before syncing.
3. Configure BigQuery
Enter your BigQuery project, dataset, and table names. The connector automatically creates the table if it doesnât exist, matching your selected columns.
4. One-Click Sync
Start the export with a single click. Data is securely transferred using Googleâs official APIs, with full support for large datasets and custom fields.
5. Automated & Repeatable
Schedule recurring syncs or trigger exports on demand. Your BigQuery table is always up to date, reflecting the latest filtered data from Odoo.
Looking for More Information?
This guide covers the key features of our Google BigQuery Connector. For our complete documentation portal, including detailed setup guides, advanced examples, and information on all Niyu Labs products, please visit our main hub.
Open Niyu Labs Documentation HubFrequently Asked Questions
What do I need to use this module?
An Odoo instance, a Google Cloud account with BigQuery enabled, and a Service Account with "BigQuery Data Editor" and "Job User" roles.
Can it sync data from custom Odoo modules?
Yes. The connector can access and export data from any standard or custom model within your Odoo database, including any custom fields.
Does the sync overwrite the BigQuery table, or can I append data instead? What happens to existing records in BigQuery?
By default, yes. The connector uses WRITE_TRUNCATE to replace the table on each sync, ensuring it's a perfect replica of the source Odoo data. This means all existing records in the BigQuery table are deleted and replaced with the latest export. If you need append or merge functionality, please contact us to discuss your requirements.
Is my data secure during the sync process?
Yes. All data transfers use official Google Cloud authentication and encrypted connections. No third-party servers are involvedâyour data flows directly from Odoo to your BigQuery project.
Can I schedule automatic exports?
Yes. You can schedule recurring syncs directly from Odoo, ensuring your BigQuery tables are always up to date with the latest filtered data.
Does it support large datasets?
Yes. The connector is designed to handle large Odoo tables and will efficiently export even hundreds of thousands of records to BigQuery.
Ready to Unlock Your Odoo Data?
Stop managing data and start using it. Get the Odoo to BigQuery Connector today.
Contact Us: info@niyulabs.comOdoo 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