Microsoft Fabric Connector
by Yugma Tech🔗 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.
