Summary

This module facilitates the integration of Odoo with various SQL databases, allowing seamless data synchronization and automation between Odoo and external SQL systems

Releases

• 27-June-2024 Version 16.0.1.0.1 - Initial release

Features

• Server Connection Management: Connect to different types of SQL servers (MS SQL, PostgreSQL, MySQL). Expanded database support is forthcoming.
• Model Mapping: Map Odoo models to SQL tables with field-level configuration.
• Automation: Automate data integration based on various triggers.
• Flexible Integration Types: Choose from multiple integration types like create, update, create if not exist, and update & create if not exist.
• Field Mapping:Configure field mappings between Odoo and SQL with support for related fields and ID-only integration.
• Integration Types
  • Create:Create record forcefully
  • Create if not exist:Create a record if it does not exist in SQL
  • Update:Update a record
  • Update & Create if not exist:Update the record if it already exists in SQL, otherwise create a new record.

Supported in

Odoo Enterprise (on-premise)

Odoo Community

Installation

• 1. Python libraries required:

  pip install SQLAlchemy

  pip install pyodbc #for mssql

  pip install mysql-connector-python #for mysql

• 2. Extra dependencies required:
  Install the ODBC Driver for MSSQL, preferably version 17
• 3. Install the module from the Odoo Apps menu.

Configuration

• 
• 1. Create a new SQL Integration Record
  • Navigate to Odoo to SQL under the Settings menu.
  • Click on Create to add a new SQL integration configuration.
  • Fill in the required fields:
    • Name: A descriptive name for the integration.
    • Server Type: Select the type of SQL server (MS SQL, PostgreSQL, MySQL).
    • Host: The host address of the SQL server.
    • Port: The port number (auto-filled based on the server type).
    • Database: The name of the SQL database.
    • SQL User: The username for SQL authentication.
    • SQL User Password: The password for SQL authentication.
• 2. Test SQL Connection

  Click the Test Connection button to verify the connection settings.

• 3. Configure Model and Fields
  • Model: Select the Odoo model to be integrated.
  • Before Integration Domain: Integration Domain to filter the records of the model.
  • SQL Table Name: Specify the SQL table name.
  • Integration Fields: Map the Odoo fields to SQL columns
• 4. Confirm Configuration

  Press the Confirm button to finalize the integration setup. Once everything is ready, a green badge will appear as shown in the image below. Then, press RUN MANUALLY to manually run the integration

• 
• 5. Set Automation Rules (Optional)
  • Enable Automation: Toggle to enable automated data integration.
  • Trigger: Select the trigger type (e.g., On save, On deletion, On time).
  • Trigger Fields: Choose fields that will trigger the automation (if applicable).
  • Trigger Date: Configure time-based triggers with delay settings.
• 

Usage

• Once configured, the module will automatically handle data synchronization based on the defined rules and triggers. Manual execution is also available for immediate integration.

Troubleshooting

• Connection Issues: Ensure that the SQL server details are correct and the server is accessible.

  Field Mapping Errors: Verify that the Odoo fields and SQL columns are correctly mapped.

  Automation Failures Check the Odoo logs for error messages and ensure the automation rules are correctly configured.

Author

• Fasil: fasil@bytesraw.com