Skip to Content

Azure Synapse Connector | MS Fabric (Bulk via ADLS Gen2)

by
Odoo

$ 599.01

v 17.0 Third Party
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 686
Technical Name odoo_synapse
LicenseOPL-1
Websitehttps://niyulabs.com
Versions 15.0 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 686
Technical Name odoo_synapse
LicenseOPL-1
Websitehttps://niyulabs.com
Versions 15.0 16.0 17.0 18.0 19.0
⚡ Odoo Connector · Microsoft Intelligent Data Platform

Azure Synapse Connector

Bring your Odoo data into the Microsoft Intelligent Data Platform. Scale from simple tracking to Enterprise-grade Analytics with Azure Synapse. Odoo handles the daily grind—Azure Synapse builds the big picture for your executive team.

ADLS Gen2 Support Incremental Sync Dedicated SQL Pools Power BI Native
✨ The Modern Data Pipeline

Export Odoo Records → Land in Azure Data Lake → Sync to Dedicated SQL Pool → Visualize in Power BI

📍 Where to Find Everything in Odoo

Install App

Apps → Update Apps List → Search "Azure Synapse" → Install

Connection Settings

Settings → left sidebar → Microsoft Azure Synapse

Export Profiles

Main menu → Azure Synapse Connector → Export Profiles

Run / Schedule Sync

Export Profile form → Run Export / Cron Schedule

Enterprise Data Capabilities

Scale your Odoo analytics using Microsoft's most powerful data warehouse.

🚀
Unlimited Model Export

Transfer any Odoo data point to Azure:

  • CRM Leads, Sales Pipelines
  • Accounting Ledgers, Invoices
  • Inventory & Manufacturing BoMs
🔀
Delta Sync Technology

Only pushes changes (Update/Insert). Minimizes storage costs and speeds up sync cycles.

⏱
Automated Pipelines

Schedule exports every 15 min or hourly. Power BI stays fresh without manual clicks.

📋
Schema Auto-Mapping

Auto-creates tables in Dedicated SQL Pool with Odoo-to-Synapse type conversion.

Why use Azure Synapse?

Azure Synapse combines data warehousing and big data analytics. Query Odoo data with SQL, Python, or Spark and connect natively to Power BI for boardroom-ready visuals.

High-Level Workflow

A seamless 4-step journey from Odoo to your Dashboard.

☁
1) Azure Setup

Configure Synapse & ADLS Gen2

🔒
2) Authentication

Secure Odoo with SAS Tokens

📤
3) Mapping

Pick Odoo models & fields

📊
4) Visualization

Query SQL in Synapse Studio

How we ensure data integrity?
  • Odoo Python objects converted to Parquet/CSV.
  • Files staged in your private Azure Data Lake.
  • PolyBase/COPY moves data into SQL Pools.
  • Row-level comparison prevents duplicates.
Ideal for these scenarios

Merge Odoo data with External Sales, IoT streams, or legacy SQL in one Azure Workspace.

Power BI Desktop ↔ Azure Synapse ↔ Odoo
Step 01 · Azure Configuration

Find Workspace Endpoints

Open your Azure Portal and navigate to your Synapse Workspace.

Details to capture in Azure Portal:
  • · SQL Endpoint: Copy "Workspace SQL endpoint" (ends in .sql.azuresynapse.net)
  • · SQL Pool Name: Your Dedicated Pool name (e.g. SalesDW)
  • · SQL Auth: SQL Admin username and password

📷 Synapse workspace overview — Essentials (Dedicated SQL endpoint, odoo_dedicated pool)

Azure Synapse Overview Essentials

📷 Synapse Analytics workspace dashboard — Ingest, Explore, Visualize

Synapse Workspace Dashboard
Step 02 · ADLS Gen2 Storage

Secure Landing Zone

The SAS Token Checklist

Azure Synapse requires ADLS Gen2 storage for data transfers.

  • Storage Account → Shared access signature
  • Allowed services: Blob · Resource types: Service, Container, Object
  • Permissions: Read, Write, List, Create, Delete
  • Generate SAS and copy the token string

📷 Create storage account — Basics (Resource group: rg-odoo-synapse)

Create Storage Account

📷 Storage center — Find your ADLS accounts (niyuadlscentral, niyusynapseadls)

Storage Center Blob Storage

📷 Storage account properties — Verify Hierarchical namespace: Enabled (ADLS Gen2)

Storage Account Properties

📷 Generate SAS — Containers → right‑click container → Generate SAS

Generate SAS Token
Common settings
Hierarchical Namespace: Must be ENABLED (ADLS Gen2)
Container: Create a container named "synapse"
Step 03 · Security & Firewall

Allow Odoo Access

Firewall exceptions

Azure is secure by default. Allow connections from Odoo to Synapse.

  • Synapse Workspace → Networking
  • Toggle "Allow Azure services and resources to access this workspace" to ON
  • Click + Add client IP for your Odoo server IP

Synapse Workspace → Networking → Add client IP for your Odoo server

Step 04 · Odoo Configuration

Connection Settings

Required configuration for ADLS Gen2 → Synapse COPY INTO.

📍 Where to find in Odoo

Settings

→ Left sidebar under Connectors → Microsoft Azure Synapse

(Sits alongside Redshift, Snowflake, BigQuery connectors)

🔌
Synapse SQL

Dedicated Pool

  • Server Name
    <workspace>.sql.azuresynapse.net
  • Admin Username
    Your SQL pool admin (e.g. synapseadmin)
  • Password
    SQL admin password (masked)
📦
ADLS Gen2 Staging

Data Lake Storage

  • Account Name
    Your ADLS Gen2 storage account
  • Container Name
    e.g. synapse
  • Shared Access Signature (SAS) Token
    Full SAS token from Azure (sv=...&ss=b&srt=co...)

📷 Microsoft Azure Synapse settings in Odoo

Odoo Microsoft Azure Synapse Settings

Selecting Data & Domains

Choose what to sync. You don't need the entire database—only the tables you need for analytics.

📍 Where to find

Export Profile form → Model / Fields / Domain filter tabs

Filter logic examples

Sync only Invoices from 2024:

[('invoice_date','>=','2024-01-01')]

Sync only "Done" Stock Moves:

[('state','=','done')]
Best practices
  • Select only required fields to minimize IO
  • Test connection before full sync
  • Use Domain filters to exclude test/archived data

Query Your Odoo Data in Synapse Studio

Once data is synced, open Synapse Studio → Data → SQL database (odoo_dedicated) → New SQL script. Run queries like SELECT * FROM dbo.res_partner.

⚠ Ensure your Dedicated SQL pool is Online — if paused, Odoo cannot write and queries will fail. Resume from Azure Portal.

📷 Synapse Studio SQL script — Connect to odoo_dedicated, query Odoo tables

Synapse Studio SQL Query

The Power of Incremental Sync

Keep Azure Synapse updated without overloading your server.

1. Full Export (First Time)

On first run, Odoo sends all records matching your filter to Azure. Establishes the baseline table.

2. Delta / Incremental Sync

Later runs use a watermark. Odoo checks write_date and exports only rows modified since last sync.

The Merge Process

When data arrives in Synapse:

  • Matching ID: Update existing row
  • New ID: Insert new record
  • Result: Mirrored table ready for Power BI
Sync Process
📍 Where to configure sync schedule

Export Profile → Schedule / Cron field, or use Odoo Scheduled Actions

Troubleshooting Guide

Quick fixes for common Azure connectivity issues.

Final sanity check
  • SQL Pool Status: Is your Dedicated Pool "Online"? (If paused, Odoo can't write)
  • Networking: Is the Odoo server IP in the firewall whitelist?
  • SAS Permissions: Does the SAS include 'Write' and 'Create'?
  • SQL Credentials: Verify SQL Admin password recently?

⚠ Pro tip: Use the "Test Connection" button in Odoo before a large export. It validates storage and SQL in seconds.

📍 Where to test connection

Settings → Microsoft Azure Synapse (sidebar) → Test Connection or Save

Synapse Connector FAQ

Does it work with Serverless Pools?

Optimized for Dedicated SQL Pools for consistent Power BI performance.

What version of Odoo?

Odoo Community, Enterprise & Odoo.sh — Versions 16, 17, 18.

Is there a row limit?

No. Azure Synapse scales to Petabytes. Limit is Odoo server memory for large batches.

Can I sync binary files?

Structured data (text, numbers, dates) only. Attachments via ADLS links, not SQL pools.

Does it support Power BI?

Yes! Use the native Azure Synapse connector in Power BI Desktop once data is in the SQL pool.

Is my data safe?

100%. Data stays in your infrastructure—Odoo to your Azure account directly.

Need Help?

Our team can assist with setup, mapping, and troubleshooting.

📧 info@niyulabs.com 🌐 niyulabs.com

Last updated: December 2025 | Version: 18.0.2.1.0 | Odoo 16 · 17 · 18

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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.