Odoo connector

Use your Odoo data for reporting, automation and AI.

Data Panda brings your Odoo data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
Odoo logo
About Odoo

The ERP that ties your whole business together.

Odoo started in Belgium in 2005 as TinyERP and grew into a modular ERP covering CRM, sales, purchasing, inventory, accounting, HR, projects and manufacturing. It is one of the most widely deployed ERPs in European SMEs, with a large open-source core and an Enterprise edition on top.

The point of pulling Odoo into a warehouse is not that Odoo lacks reports. It is that the questions worth asking usually cross modules: sales versus purchasing versus stock, or Odoo versus a webshop, or Odoo versus a standalone CRM. Those questions end up in spreadsheets, and spreadsheets rot.

What your Odoo data is for

What you get once Odoo is connected.

Cross-module reporting

One view of sales, stock, purchasing and accounting instead of four Odoo dashboards.

  • Margin per product, customer and region
  • Stock turnover and slow-moving items
  • Open AR and AP aging next to cash position

External-system automation

Sync Odoo with the systems that live outside it, without the bi-weekly export dance.

  • Webshop orders into Odoo sales + stock
  • CRM wins into Odoo sales orders
  • Accounting exports into your group consolidation

AI workflows

Turn Odoo history into forecasts and scoring that guide the next order or the next cash call.

  • Demand forecasting on stock movements
  • Credit-risk scoring on payment history
  • AI assist on document classification and coding

Custom apps on your data

Small tools on top of Odoo data for people who should not be learning Odoo.

  • Sales rep dashboards with stock availability
  • Supplier portals with open POs and receipts
  • Project managers' profitability views
Use cases

Use cases we deliver with Odoo data.

A list of concrete reports, automations and AI features we have built on Odoo data. Pick the one that matches your situation.

Margin by productAfter purchase cost, freight and discounts.
Stock turnoverWeeks of cover per SKU, by warehouse.
AR agingOpen receivables per customer, by bucket.
Sales to delivery leadOrder date to shipment date, per product line.
Purchase-to-pay cyclePO to receipt to payment, average per supplier.
CRM win rate by repStage velocity and close rate from Odoo CRM.
Customer lifetime valueRevenue and margin across the whole history.
Multi-company consolidationCross-entity P&L without the monthly export.
Production throughputMRP work orders per hour, per workstation.
Project profitabilityHours, materials and invoiced revenue per project.
Real business questions

Answers you will finally get.

Why is working capital creeping up?

AR aging, inventory days and AP aging side by side, with trend lines over twelve months. Flags the account, SKU group or supplier cohort that is driving the shift.

Which products are quietly killing margin?

Gross margin per product over time, after purchase cost, freight and discount. Ranks slow-moving SKUs with a full margin picture before you reorder.

How long between winning a deal and delivering it?

Sales order date to shipment date, per product line and customer. Exposes where the handoff between sales and warehouse lengthens the cycle.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Working capital under control. AR, AP and inventory aging next to cash position, with group consolidation that does not wait for the month-end export.

For sales leaders

Win rate by rep and region, plus pipeline-to-order velocity. See stock availability at quote time instead of after the customer already said yes.

For operations

Stock turnover and purchase-to-pay cycle in one picture. The handoffs between sales, purchasing and warehouse show up as data, not as friction.

Ideas

What you can automate with Odoo.

Pair with Salesforce

Hand customers off from Salesforce to Odoo

Closed-won Salesforce opportunities flow into Odoo as quotations or sales orders, with customer and contact records reconciled. Sales stops re-keying into the ERP and finance sees Salesforce-side forecast next to Odoo-side backlog.

Pair with HubSpot

Turn HubSpot deals into Odoo sales orders

Marketing-sourced HubSpot deals create draft sales orders in Odoo when they reach closed-won. Order status, shipment and invoice state flow back to the HubSpot deal, so sales always knows where a customer is in the fulfilment cycle.

Pair with Exact Online

Consolidate Odoo with a Benelux entity on Exact Online

For groups running Odoo in the operational entity and Exact Online at the accounting or holding level, we align chart of accounts, sync customer masters and push Odoo journal totals into Exact Online. One consolidated P&L, no monthly reconciliation.

Pair with Shopify

Sync webshop orders into Odoo stock and accounting

Shopify orders land in Odoo as sales orders with the right products, stock moves and invoices. Inventory stays in one place, and the ecommerce side of the business shows up in the same P&L as the rest of the group.

Data model

Tables we make available.

These are the 38 tables we currently pull from Odoo into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Account Move
  • Account Move Line
  • Accounts
  • Contacts
  • Crm Lead
  • Invoice Lines
  • Invoice Lines All Move Types
  • Invoices
  • Journal
  • Journal Lines
  • Journals
  • Models
  • Partner Categories
  • Partners
  • Payment Method Lines
  • Payments
  • Pos Order Lines
  • Pos Orders
  • Pos Payments
  • Product Categories
  • Product Variants
  • Products
  • Project Stages
  • Projects
  • Purchase Order Lines
  • Purchase Orders
  • Sales Order Lines
  • Sales Orders
  • Statements
  • Stock Locations
  • Stock Move Lines
  • Stock Moves
  • Stock Picking Types
  • Stock Pickings
  • Stock Quantities
  • Stock Valuation Layers
  • Tasks
  • Users

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Odoo data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Odoo to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Odoo connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Does the sync cover multi-company Odoo instances?

Yes. We scope access by company, respect the record-rules set up in Odoo, and can fan out or consolidate at warehouse level. Common setup is one warehouse schema per Odoo company, with a consolidated view on top.

Which Odoo versions do you connect to?

Odoo 14 and later, both Community and Enterprise, on Odoo.sh and on self-hosted PostgreSQL. For older versions we work via the standard XML-RPC interface where the newer JSON-RPC is not available.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Odoo setup and the systems around it. Together we pick the first thing worth building.