| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1585 |
| Technical Name |
yt_fabric_connector |
| License | OPL-1 |
| Website | https://yugmatech.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1585 |
| Technical Name |
yt_fabric_connector |
| License | OPL-1 |
| Website | https://yugmatech.com |
🔗 Microsoft Fabric Connector
Sync Odoo ERP Data to Microsoft Fabric Lakehouse
Sync your Odoo ERP data to Microsoft Fabric Lakehouse for advanced analytics, reporting, and AI insights.
⚡ Simple REST API • No Coding Required✅ Why Choose Our Connector?
🌐 What is Microsoft Fabric?
Microsoft Fabric is an all-in-one analytics platform that unifies data engineering, data science, real-time analytics, and business intelligence. Connect your Odoo data to unlock powerful insights.
Lakehouse
Store Odoo data in a modern data lake format
Power BI
Create stunning dashboards from your ERP data
AI/ML
Train models on your business data
💼 Real-World Use Cases
Transform your Odoo data into actionable insights
Sales Analytics
Analyze sales trends, customer behavior, and revenue forecasts with Power BI dashboards.
Inventory Insights
Track stock levels, predict demand, and optimize warehouse operations.
Financial Reporting
Consolidate accounting data for real-time financial dashboards and compliance.
⭐ Exclusive Feature: Expand Relations
No more complex joins in Fabric - get display names alongside IDs automatically!
❌ Without Expand Relations
{
"partner_id": 42,
"tag_ids": "1,2,3"
}Need to join with res.partner to get customer name!
✅ With Expand Relations
{
"partner_id": 42,
"partner_id_name": "Acme Corp",
"tag_ids": "1,2,3",
"tag_ids_names": "VIP,Enterprise,USA"
}Names included - ready for Power BI!
✨ Premium Features
Simple REST API
Just enter model name like sale.order as the relative URL.
No complex configuration needed.
Allow All Models
One checkbox to enable API access for all Odoo models. Quick setup for rapid deployment.
Exclude Fields
Choose which fields to exclude from sync. Hide sensitive data or reduce payload size.
GZIP Compression
Reduce bandwidth by 60-80% with automatic GZIP compression. Faster transfers, lower costs.
Rate Limiting
Configurable request limits per minute. Protect your Odoo server from overload.
Request Logging
Track every API call with detailed logs. Monitor usage, debug issues, and analyze patterns.
🚀 Quick Setup Guide
Get data flowing in just 4 steps
Install Module
Download and install from Odoo Apps
Create Connection
Generate API key and configure models
Fabric Copy Job
Create REST connector in Microsoft Fabric
Analyze!
Data flows to Lakehouse - build dashboards
⚙️ Fabric Copy Job Configuration
Simple setup - no coding required
📡 Connection Settings
| Setting | Value |
|---|---|
| Base URL | https://your-odoo.com/api/fabric/v1 |
| Relative URL | sale.order (just the model name!) |
🔐 Authentication Headers
| Header | Required | Description |
|---|---|---|
X-Api-Key |
Required | Your API Key from Odoo connection |
X-Api-Secret |
Optional | Extra security layer (if configured) |
💡 Tip: API Secret adds extra security. If configured in Odoo, requests without it will be rejected.
Why Choose Our Connector?
More features. Better security. Built for production.
❌ Other Solutions
- ✗ Basic REST only
- ✗ No relation expansion
- ✗ Limited configuration
- ✗ No field exclusion
- ✗ No request logging
- ✗ No rate limiting
✅ YT Fabric Connector
- ✓ Expand Relations (unique!)
- ✓ Allow All Models toggle
- ✓ Exclude Fields per model
- ✓ GZIP Compression
- ✓ Request Logging & Analytics
- ✓ Configurable Rate Limiting
❓ Frequently Asked Questions
Does it work with Fabric Copy Jobs?
Yes! The connector is designed specifically for Microsoft Fabric Copy Jobs. Just enter the model name as relative URL and you're ready.
What destinations are supported?
Fabric Lakehouse, Fabric Data Warehouse, and Azure SQL Database. Configure directly in Fabric Copy Job.
Can I sync custom modules?
Yes! Any Odoo model can be synced - standard and custom. Just enter the technical model name.
Is the extraction incremental?
Currently performs full dataset extracts. Fabric Copy Jobs with REST don't support native incremental - use scheduled full refreshes.
Is this a subscription?
No! One-time purchase. No recurring fees.
Does it work with Power BI?
Yes! Data in Fabric Lakehouse can be connected to Power BI for dashboards. Also works with Power BI's Web connector directly.
How frequently can I schedule syncs?
Microsoft Fabric supports scheduling Copy Jobs from every few minutes to daily or weekly. Configure directly in Fabric's scheduling UI.
Can I connect multiple Odoo instances?
Yes! Create multiple connections with different API keys. Each can point to a different Odoo instance for multi-database setups.
Is my data secure?
Yes! API key authentication, IP whitelisting, rate limiting, and HTTPS encryption. Data never passes through third-party servers.
How does it handle large datasets?
Built-in pagination with configurable page sizes (1,000-10,000 records). GZIP compression reduces transfer time by 60-80%.
Does it work with Odoo Enterprise?
Yes! Works with both Odoo Community and Enterprise editions. All standard and custom models are supported.
What support do you offer?
Free email support included. We help with installation, configuration, and troubleshooting. Custom development available on request.
What format does the API return?
JSON array of records. Each record contains field names as keys with properly typed values (strings, integers, dates in ISO format).
Can I filter which records are synced?
Yes! Add domain filters per model to sync only specific records (e.g., only confirmed orders, active customers, last 30 days).
How do I test the API?
Use the built-in "Test Connection" button in Odoo, or call
the health endpoint: GET /api/fabric/v1/health
Does it include archived records?
Configurable per model. Toggle "Include Archived" to include records marked as inactive (active=False) in the sync.
💬 Need Help?
Questions, customization requests, or support?
Email: hello@yugmatech.com
Website: www.yugmatech.com
Microsoft Fabric Connector by Yugma Tech
© 2025 Yugma Tech. All rights reserved.
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