Database to Odoo Data Migration – N-Hub

Data Migration Tool

Introduction

The Data Migration Tool is a powerful utility for Odoo developers and administrators. With this tool, you can effortlessly pull data from any Database (supports only PostgreSQL database, soon: MySQL) and migrate it to your Odoo instance. Whether you’re transitioning from a legacy system, merging databases, or just need to import data periodically, this tool will save you countless hours of manual data manipulation and scripting.

Features

• Data Source Management: Define and manage multiple PostgreSQL data sources with connection parameters.
• Flexible Data Mapping: Define target models in Odoo and map source columns to Odoo fields. Supports various data types including integers, floats, Many2Many relations, and more. You can even define fixed values or derive values from formulas.
• SQL Query Execution: Directly run SQL queries against your source database, giving you granular control over the data you want to migrate.
• Data Transformation: The tool can automatically map and transform your source data to fit into your Odoo models. This means less manual data cleanup and transformation.
• Preview Capability: Before you commit to migrating data, you can preview it in a neat table format.
• Error Handling: Errors during migration are clearly reported, and you can opt for partial transactions if you don’t want to halt the entire operation due to a few problematic records.