Odoo
Implementation
BigQuery Odoo Integration | Odoo BigQuery Integration | Odoo BigQuery Connector | BigQueryOdoo Connector
by Creyox Technologies https://www.creyox.com
Odoo
$ 425.01
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 699 |
| Technical Name |
cr_bigquery_connector |
| License | OPL-1 |
| Website | https://www.creyox.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 699 |
| Technical Name |
cr_bigquery_connector |
| License | OPL-1 |
| Website | https://www.creyox.com |
| Versions | 16.0 17.0 18.0 19.0 |
Community
Enterprise
Odoo.sh
Odoo BigQuery Connector
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
Partial Field Sync
Easy-to-Configure Settings
Targeted Data Selection
Smart Data Availability Check
Continuous Synchronization
Seamless Communication
User-Friendly Notifications
Scheduled Data Import
Powerful Analytics
Dynamic Table Selection
Seamless Data Export Automation
Multi-Company Support
Custom Field Selection
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.
Scheduled Data Backups.
Advanced Data Filters.
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.
- Transaction logs for syncing tables between Odoo and BigQuery are available in BigQuery as shown below.
Our Services
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & On-Premise) as well as Community.
- Yes, the connector supports real-time synchronization for both import and export operations, ensuring your data is always up-to-date.
- Absolutely. You can choose which fields to include in both export and import operations. If no fields are selected, all fields will be processed by default.
- Yes, the connector fully supports multi-company setups. Each company can have its own BigQuery configuration and manage operations independently.
- Yes. If you don't want to set up a recurring sync, you can simply use the Run Manually button to perform a one-time import or export.
- No, this app will not work for Odoo Online.
- Please contact us on support@creyox.com
- Yes, we give free support when you buy these app for 60 Days.
- Yes, you need to pay different prices of app version wise.
- You can raise a Ticket on support@creyox.com we'll get back to you with fixes.
Our Services
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