Get Odoo analytics in plain language. Connect Odoo to Ronja over its external API in four steps, whether you run Odoo Online, Odoo.sh, or on-premise. Once connected, Ronja maps your sales orders, invoices, inventory, manufacturing orders, and CRM pipeline into a governed analytics layer. Then anyone, including AI agents, can ask questions and get answers traced back to the underlying Odoo records. No CSV exports, no custom BI project, no data engineering.
How to analyze Odoo data with Ronja
Setup is two parts: a one-time step in Odoo (generate an API key, and for self-managed installs confirm the instance is reachable), then the actual connection inside Ronja which takes minutes.
Step 1: Connect Odoo to Ronja
Just ask Ronja to connect to Odoo. Ronja surfaces a form for your Odoo URL, database name, login, and an API key. Ronja authenticates against your instance over Odoo's external API and starts analyzing the data.
Step 2: Let Ronja map your Odoo data
Ronja's agents map your customers and vendors, sales orders and order lines, purchase orders, invoices, bills and journal entries, inventory and stock moves, manufacturing orders, CRM leads, products, and point-of-sale orders into structured tables. You don't define a schema. The platform recognizes Odoo's data model and organizes it for analysis.
Step 3: Ask your first question in plain language
With your data mapped, ask anything. "What was our gross margin by product category last quarter?" "Which customer invoices are overdue, and by how many days?" Ronja runs the query against the mapped tables and shows exactly which Odoo records the answer came from. Every number traces to source.
Step 4: Combine Odoo with the rest of your stack
Odoo alone gives you sales, finance, and operations analytics. Combined with HubSpot CRM, Fortnox or other accounting, or your ad platforms, it's transformative. Ronja unifies all your sources into a single governed layer, so you can answer questions like "which marketing campaigns drove the orders we actually fulfilled" or "how does manufacturing lead time affect on-time invoicing" in a single query.
Just ask
Questions you can answer with Odoo data
Ask in plain language. Get answers traced to source. No analysts, no dashboards, no waiting.
What Odoo data Ronja maps
When you connect Odoo, Ronja's agents map the following data into its governed analytics layer:
- Customers and vendors (res.partner): master data, contacts, payment terms
- Sales orders (sale.order): order lines, status, pricing, delivery
- Purchase orders (purchase.order): supplier orders, receipts, lead times
- Invoices, bills and journal entries (account.move): AR, AP, GL
- Inventory (stock.quant, stock.move): stock on hand, transfers, valuation
- Manufacturing orders (mrp.production): work orders, BoMs, planned vs actual
- CRM pipeline (crm.lead): leads, opportunities, stages, expected revenue
- Products (product.template, product.product): catalog, costing, attributes
- Point of sale (pos.order): retail transactions, sessions
Key takeaways
- The Odoo connector works with Odoo Online, Odoo.sh, and on-premise Community and Enterprise installs
- Connection uses Odoo's external API with an API key, no database credentials or custom export needed
- Ronja maps your sales, finance, inventory, manufacturing, and CRM data automatically. No schema definition needed
- AI agents reach Odoo through Ronja's governed layer, not raw API access, so answers stay accurate and access stays enforced
- Combines with HubSpot, Fortnox, and 100+ other sources for cross-system analytics
- Read-only for analytics. Ronja does not write to your Odoo records
Frequently asked questions
How do I connect Odoo to Ronja?
Before you start: generate an API key in Odoo under Preferences, Account Security (Odoo 14 and later), and for on-premise installs confirm the instance is reachable from Ronja. Then just ask Ronja to connect to Odoo and provide your Odoo URL, database name, login, and API key. Ronja authenticates over Odoo's external API and starts mapping data. Most teams complete the connection in 10 to 15 minutes.
Does it work with Odoo Online, Odoo.sh, and on-premise?
Yes. Odoo's external API (XML-RPC and JSON-RPC) is available on all three. Odoo Online (SaaS) does not expose the underlying PostgreSQL database, so the API is the universal path; on self-hosted and Odoo.sh instances the API works the same way. You do not need to change your Odoo hosting to connect.
What Odoo data does Ronja have access to?
Customers and vendors, sales and purchase orders, invoices, bills and journal entries, inventory and stock moves, manufacturing orders, CRM leads and opportunities, products, and point-of-sale orders. Access is scoped to the records the API user has rights to under Odoo's own access rules.
Can I connect Odoo to ChatGPT, Claude, or an AI agent?
Yes, through Ronja rather than directly. Wiring Odoo straight into an LLM or MCP client gives the model raw API access with no governance and no guarantee the numbers are right. With Ronja as the control plane, agents reach Odoo through a governed layer: access rules are enforced in software, and every answer traces back to the source Odoo record. You get the same plain-language access without handing an agent the keys to your ERP.
Do I need a developer or data engineer to use this?
For day-to-day analysis, no. Business users ask sales, finance, inventory, and manufacturing questions in plain language and get answers in seconds. The one-time setup (generating an API key, and for self-managed installs confirming network access) is something an Odoo administrator handles once.
Does Ronja modify any data in Odoo?
No. Ronja reads from Odoo for analytics and does not write back to your records.