Skip to main content

Prerequisite

To allow to determine which models your user can access in , the connected user must have read permissions for ir.model.access (an internal 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 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 as tables, regardless of your user’s actual permissions for those models.

Add the Odoo Connector

Authenticate to Odoo

After you add the connector, you need to set the required properties.
  • URL: Enter the base URL for your database (for example, https://MyCompany.odoo.com).
  • User: Enter the username that you use to authenticate to .
  • API Token: Enter the API token (or password) that you use to authenticate to .
  • Edition: Select the edition of that you want to use.
    • Online (default)
    • OnPremise: With this edition, you must also enter the name of the 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 user permissions to determine which tables and lists to view. By default, the Enable checkbox is already selected.
  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