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.
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.
One view of sales, stock, purchasing and accounting instead of four Odoo dashboards.
Sync Odoo with the systems that live outside it, without the bi-weekly export dance.
Turn Odoo history into forecasts and scoring that guide the next order or the next cash call.
Small tools on top of Odoo data for people who should not be learning Odoo.
A list of concrete reports, automations and AI features we have built on Odoo data. Pick the one that matches your situation.
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.
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.
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.
Stock turnover and purchase-to-pay cycle in one picture. The handoffs between sales, purchasing and warehouse show up as data, not as friction.
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.
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.
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.
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.
Odoo data covers 83 available tables across the supported connection options. The exact selection depends on your connection and access rights. Use the data in reports, combine it with the rest of your stack, or query it directly in your warehouse.
The tables at the top of the list open up to show their columns and data types.
Alongside reading data, these actions let you create, update or manage information in Odoo. The exact actions depend on your connection and permissions; some require a separate write-back connection.
33 more write-back actions are available for Odoo. We show a representative selection here to keep the overview useful.
Need another table, field or write-back action? Tell us what you need. We can check the available options or help extend the connector.
You keep the reporting tool you already have. We connect it to the warehouse where your Odoo data lives.
OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys. Read our DPA
Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.
We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.
We set up the foundation. Your team builds on top.
Best fit Teams that already have a BI analyst or data engineer and want to own the build.
We build the whole thing, end to end.
Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.
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.
Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.
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.
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.
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.
We review your Odoo setup and the systems around it. Together we pick the first thing worth building.