Integrating with Odoo

Prerequisites

To connect Odoo to Drivetrain, you need:

• An active Odoo account with admin permissions

Step 1: Create a Dedicated User for Drivetrain in Odoo

• Log in to Odoo as an Admin

• Go to Settings → Users → Manage Users

• Click New

• Fill in the required user details

  • Email: Use the email ID shared by your Drivetrain implementation team

• Go to the Access Rights tab

  • Assign appropriate access based on the data Drivetrain needs

• Click Save

• An invitation email is sent automatically

  • The user must accept the invite and set a password to activate the account

Use Internal User (required for API access)

User Type can be chosen on the Manage Users page by clicking on the search bar, and then setting a filter for either Internal User or Portal User.

Step 2: Generate Consumer Key and Consumer Secret (OAuth)

• Ensure your Odoo instance is configured for a single database (database filter enabled)

• Log in as an Admin

• Go to Settings → Users → Users

• Open the Drivetrain user created in Step 1

• Click OAuth Applications

• Click Register an Application

  • Use the following Redirect URI: https://fivetran.com/integrations/odoo/oauth2/return

• Click Save

• Copy the generated:

  • Consumer Key

  • Consumer Secret

Step 3: Share Details with Drivetrain

Share the following with your Drivetrain team via a secure document:

• Odoo subdomain (from your login URL)

• Consumer Key

• Consumer Secret