• 2 Minutes to read
  • Dark


  • Dark

Article Summary

Odoo is an open-source enterprise resource planning (ERP) software suite that encompasses various business management applications. It offers modules for functions like accounting, inventory management, sales, CRM, human resources, and more, providing a comprehensive and customizable solution for businesses to streamline their operations and improve efficiency.

Authorize Connection to Odoo

  1. In the Authorizers tab, click on Authorize New Service and select Odoo.
  2. You will be asked to provide the following information
    1. Host: Your database's URL, it will be in the yourdatabase1.odoo.com format. Please make sure you DON'T include the https:// part.
    2. Username: Email address used to log into your Odoo account.
    3. Password: Password associated with your email to log into your Odoo account. In case you don't have a password set up, please refer to Odoo's official documentation.
    4. Database: Name of your database, same as used in the Host URL, in this example, it will be yourdatabase1.
  3. Click on Save.

How to Create an Odoo Data Source

  1. On the Sources page, click on the Create Source button and select the connector from the list.
  2. From the drop-down menu, choose your account.
    Didn't find your account?

    Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

  3. Name your data source and select your metrics and attributes.
  4. [Optional] Configure your advanced settings (for more information please refer to the section on Advanced Settings). If you are unsure about how to proceed, we recommend skipping this step.
  5. Configure your snapshotting preferences. Choose your sync frequency or the exact synchronization time under Show advanced settings.

    If you need to load historical data, please refer to the Data Backfilling article.

  6. Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
  7. Click on Save and congratulations, your new data source is ready!


Data Preview Unavailable

If there is no data preview after clicking on Test Data, there might be a problem with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward through our manual data load function.
  • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Incompatible combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same source.

Error During Source Creation

Make sure you are inputting the host name correctly when you are authorizing the connection to Odoo. Your database's URL it will be in the yourdatabase1.odoo.com format. Please note that you are NOT supposed to include https:// here.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources

Was this article helpful?

What's Next