Search

Odoo

Version 25.3.9396

Odoo

You can use the Odoo connector from the CData Sync application to capture data from Odoo and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Prerequisite

To allow Sync to determine which models your user can access in Odoo, the connected user must have read permissions for ir.model.access (an internal Odoo model that manages access rights). While this permission is reserved typically for administrators, you can grant it to any user by creating a service group, as explained below:

  1. As an administrator, open the Odoo settings page and enable developer mode. If this mode is not available, you might need to login as the superuser instead.

  2. Navigate to the Groups page (available below the Users drop-down list) and create a new group.

  3. Set Application to Administration and Name to Service Access.

  4. On the Users tab, add users who need service access.

  5. On the Access Rights tab, enter the model (ir.model.access), select the Read Access checkbox, and name your service group Inspect Models.

  6. Save the new group.

If you cannot grant access by creating a new group, then you should set Check Permissions to False. This action displays all models in Odoo as tables, regardless of your user’s actual permissions for those models.

Add the Odoo Connector

To enable Sync to use data from Odoo, you first must add the connector, as follows:

  1. Open the Connections page of the Sync dashboard.

  2. Click Add Connection to open the Select Connectors page.

  3. Click the Sources tab and locate the Odoo row.

  4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the Odoo connector. For more information about installing new connectors, see Connections.

Authenticate to Odoo

After you add the connector, you need to set the required properties.

  • Connection Name - Enter a connection name of your choice.

  • URL - Enter the base URL for your Odoo database (for example, https://MyCompany.odoo.com).

  • User - Enter the username that you use to authenticate to Odoo.

  • API Token - Enter the API token (or password) that you use to authenticate to Odoo.

  • Odoo Edition - Select the edition of Odoo that you want to use.

    • Odoo Online (default)

    • Odoo OnPremise - With this edition, you must also enter the name of the Odoo database to which you want to connect. Enter the name in the Database text box.

Complete Your Connection

To complete your connection:

  1. For Check Permissions - Select whether you want to use Odoo user permissions to determine which tables and lists to view. The default setting is True.

  2. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

  3. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and Odoo, see Odoo Connector for CData Sync.