Real-time Odoo to Azure Synapse Pipeline.
The ADLS-backed data pipeline for Odoo. Incremental sync, auto-deduplication, and enterprise-grade schema mapping built for the Microsoft Data Stack.
Problem / Solution
Stop building fragile Python scripts.
Manual exports break. Generic ETL tools are slow and expensive. Our connector installs inside Odoo, stages data securely in Azure Data Lake (ADLS Gen2) or Blob Storage, and triggers Synapse's native COPY INTO command. Zero middleware. Zero maintenance required.
Azure Staging + COPY INTO. Maximum Speed.
Direct JDBC inserts cripple Odoo. We stream your Odoo data to a private Azure Blob/ADLS container and trigger Synapse Analytics' native COPY INTO command for blazing-fast parallel ingestion.
- ?Uses Synapse's optimized COPY INTO command.
- ?Handles millions of records via Azure staging.
- ?Zero impact on Odoo production performance.
Auto-Deduplication (MERGE Logic).
Synapse Dedicated SQL Pools require precise upsert logic. Our connector handles the complex MERGE and staging table logic to ensure you update existing rows and insert new ones without creating duplicates.
- ?Upserts data automatically (Update + Insert).
- ?Prevents duplicate records in your Warehouse.
- ?Maintains data consistency via ID tracking.
One-Click connection to PowerBI & Microsoft Fabric.
Once data is in Azure Synapse, your Microsoft BI ecosystem works instantly. No CSV exports, no manual refresh, no API rate limits blocking your dashboards.
- ?Native PowerBI DirectQuery integration.
- ?Ready for Microsoft Fabric & Analysis Services.
- ?Supports multi-company/multi-currency reporting.
Privacy by Design. You control the Schema.
Don't leak PII to your data warehouse. Select exactly which tables and columns to export using native Odoo domain filtering, and let us flatten the JSON automatically.
- ?Filter specific records (e.g., 'Confirmed' Orders only).
- ?Exclude sensitive columns (Salaries, Passwords).
- ?Auto-maps Odoo 'Selection' and 'Many2one' fields to clean VARCHARs.
Technical Specs
The Engineer View
Built for security, performance, and long-term reliability in the Microsoft Data Stack.
Authentication & Security
- ✓Service Principal (Entra ID): Uses Azure App Registrations (Client ID / Secret) for secure, token-based authentication.
- ✓Azure Blob / ADLS Gen2: Acts as the secure staging layer for your CSV/Parquet payloads.
Performance
- ✓Incremental Sync: Tracks write_date to sync only changed rows, drastically saving Synapse compute costs (DWUs).
- ✓Auto-Retry: Handles network drops or Azure API limits without breaking the pipeline.
Compatibility
- ✓Odoo.sh Ready: Fully compatible with Odoo.sh, On-Premise, and Azure VM hosting.
- ✓Odoo Versions: v12 to v19 (Community & Enterprise).
Use Cases
Social Proof From Microsoft Stack Teams
We migrated to the Microsoft stack and needed Odoo data in Synapse. Niyu's connector using Blob staging and COPY INTO ingested our 5-year historical data (12M rows) in under an hour.
The Data Architect
Finally, a connector that handles Odoo's Many2many fields correctly. The schema mapping flattened everything into clean SQL tables. I built the Executive Dashboard the same afternoon.
The PowerBI Developer
We couldn't use third-party ETL SaaS tools because of data residency laws. Niyu installs directly on our Odoo server and pushes to our private Azure tenant using a Service Principal. 100% compliant.
The InfoSec Manager
Deploy Architecture.
Start your Azure Data Warehouse journey today. Buy direct for the best price, or book a call for custom architecture.