Microsoft Fabric Odoo Connector | Odoo Fabric Integration
by echoBitz IT Solutions Pvt. Ltd. https://www.echobitzit.com$ 199.33
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1898 |
| Technical Name |
eb_odoo_fabric_connector |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1898 |
| Technical Name |
eb_odoo_fabric_connector |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 18.0 19.0 |
Microsoft Fabric Odoo Connector
Expose Odoo database models securely via REST API to pull data into Microsoft Fabric Lakehouse or Warehouse tables. Adheres to Odoo 19 native configuration standards with robust model access rules, token lifecycles, and request logs.
Key Features
Everything required to extract Odoo data into Microsoft Fabric Copy Jobs securely.
Expose a secure REST endpoint `/fabric/data/` authenticated using custom bearer tokens. Generate, monitor, and rotate tokens directly from the Odoo backend dashboard.
Control exactly which models are exposed to Microsoft Fabric. For each active model, restrict the synchronization to specific fields, define query limits, and enforce domains.
Configure Odoo Python domain list syntax (e.g. `[('state', '=', 'sale')]`) to filter synchronization datasets. Keep your analytical warehouse clean and noise-free.
Expose only the fields you need (e.g. `id,name,email`). Automatically skips non-stored computed fields and binary columns to minimize bandwidth and query execution time.
Simulate the Fabric endpoint data extraction process from inside Odoo. Validate records count, response time, and preview output payloads before going live.
Monitor endpoint usage with real-time audit logs detailing client IP, HTTP responses, record count, execution duration, offset, limit, and exception logs.
Configure token validity parameters. An automated hourly background cron job verifies token states and posts expiry alerts to the administrator chatter.
Prevent database bloat. An automated daily cron job runs to clean up old request logs automatically after 30 days, keeping system resource usage lightweight.
See it in Action
Watch a step-by-step walk-through of the Microsoft Fabric synchronization.
Comprehensive Enterprise Data Sync
Expose native and custom Odoo models directly to your corporate intelligence platform. Designed to manage tokens securely, limit sync limits, run dry-run diagnostic tests, and keep transaction trace logs with zero ERP service deterioration.
Visual Workflow
Explore the step-by-step visual workflow and connection panels.
Odoo & Microsoft Fabric Connection Process
Review the exact visual panels showing Odoo security configuration, model access filters, Microsoft Fabric copy jobs, and lakehouse query previews.
Set the security access level for Odoo users under Settings, configuring them as a Fabric User, Fabric Manager, or Fabric Administrator.
Configure Odoo models to expose, setup relative URLs, select specific fields, and apply python domains and record limits for each model.
Navigate to the Microsoft Fabric workspace dashboard and select the option to add new analytical and pipeline components.
Choose "Copy job" from the list of workspace items to instantiate a new REST integration pipeline to Odoo.
Set the Copy Job properties, naming it clearly to represent the analytical synchronization target (e.g. My Orders).
Select REST connection as the data source to pull from the dynamic Odoo endpoints.
Setup your Odoo REST API URL inside the REST Connection panel and choose Anonymous Authentication.
Define the relative model route URL (e.g. sale.order) and add the secure Bearer Authorization token in the HTTP headers.
Select a Microsoft Fabric Lakehouse database as the endpoint target to store the query result data.
Instantiate a fresh analytical lakehouse database named sale_order_data to catalog the imported files.
Confirm the REST copy options, specifying a Full Copy read method and routing the mapping into Destination Tables.
Choose the Overwrite update option inside settings to replace destination database files with fresh Odoo content on each sync run.
Verify mapping columns from the REST source endpoint objects directly to the destination Lakehouse fields.
Review the summary of configuration settings, checkboxing options to trigger the initial sync run immediately upon saving.
Verify pipeline completion status showing a Succeeded result that pulled 25 sales orders from Odoo in 19 seconds.
Check assets on the My workspace panel, verifying listing of the imported Lakehouse database and SQL analytics endpoint.
Open Lakehouse database to verify imported sales tables detailing amount totals, record status, order names, and customer ids.
Version 19.0.1.0.0
Stable Odoo 19 release of the Microsoft Fabric Odoo Connector. Exposes select data models securely via token-authenticated REST API endpoints for seamless ingestion by Microsoft Fabric Copy Jobs.
Key Enhancements
- Secure bear token generation and validation.
- Expose native or custom models (res.partner, sale.order, etc.).
- Custom field selections to minimize network payload sizes.
- Query optimization through Odoo Python domains.
- Comprehensive tracing logs detailing execution duration.
Release History
Expose Odoo Business Intelligence Easily,
While Protecting Database Assets
Synchronize enterprise transaction histories and CRM datasets with Microsoft Fabric Copy pipelines. Safeguard operations with tokens, customized model routes, and detailed trace logs.
Talk to echoBitz About Your Data Strategy
If you want help integrating with Microsoft Fabric, designing complex analytical data pipelines, optimizing PostgreSQL query indexes, or building custom warehouse structures, our engineering team is here to help.
Our Services
Fabric Integration
We configure active Odoo endpoints, API tokens, model routes, and credentials so your intelligence sync runs smoothly.
Data Engineering
Setup tables, write mapping relationships, configure scheduled runs, and integrate with Power BI analytics layers.
Customization
Add dynamic computed column synchronization, structure automated email warning updates, or design custom endpoints.
Community Apps
Deploy fully reusable modules to upgrade your company's ERP functionality without starting development from zero.
Development Outsourcing
Dedicated Odoo developers for data extraction setups, API integrations, custom views, and long-term support.
Support & Maintenance
Ongoing support for analytical connections, security revisions, and new Odoo releases so pipelines stay robust.
Discover More Solutions by echoBitz IT
Explore our other Odoo integration apps
Accept secure hosted checkout payments in Odoo eCommerce, invoices, and portal using CAWL gateway.
Connect Odoo with Canada's leading Moneris payment gateway for secure credit/debit card transactions.
Design, build, and export custom Excel reports natively from any Odoo model.
Seamless bidirectional sync for products, orders, customers, and inventory.
Automate your accounting with bidirectional sync for invoices, bills, and payments.
Bidirectional sync of products, orders, customers, inventory, and payments.
Ready to integrate Odoo with Microsoft Fabric?
Install Microsoft Fabric Odoo Connector and start building your enterprise analytical data pipeline with secure token-authenticated REST endpoints today.
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