Odoo Extractor for Seamless ERP Data Integration

What It Does

The Odoo Extractor pulls data from your Odoo instance using either XML-RPC (all versions) or the newer JSON-2 protocol (Odoo 19+, 2-3x faster). It handles the tricky parts automatically — discovering databases, models, and fields, plus normalizing many2many relationships into proper join tables.

Key capabilities:

• Dual protocol support — XML-RPC for universal compatibility, JSON-2 for better performance on Odoo 19+
• Dynamic discovery — auto-discover databases, models, and fields directly in the UI
• Configuration rows — one row per model, each with independent state and execution
• Smart relationship handling — many2one fields are flattened, many2many/one2many are split into normalized bridge tables
• Cursor-based incremental loading — efficient id > last_id pagination for large datasets

Supported Data

Compatible with any Odoo model, including partners, sales orders, invoices, products, CRM leads, inventory moves, and more.

Getting Started

Simply add the Odoo Extractor to your project, enter your credentials, and use the Test Connection button to verify. Then select your models and fields from the dropdowns — no need to memorize internal model names.

Documentation and source code: github.com/keboola/component-odoo-extractor