Odoo
A guide on how to integrate Odoo with Plecto.
Last updated: June 3, 2022
Data types
There are no predetermined data types to choose from. Odoo can be used in many different ways, and since Plecto integrates with everything, we cannot provide you with a complete list of data types – that depends on your Odoo account.
You will see your list of data types when you create an Odoo data source in Plecto. For each data type you import, Plecto will create one data source and store it under Data management > Data sources.
Odoo docs
If you want to learn more about how Odoo works, read their user documentation or developer documentation.
Step 1: Get your Odoo credentials
To integrate Odoo with Plecto, you need to find the following credentials in your Odoo account: username, API key, Server URL, and database name.
Username
Username is the name of the Odoo user. You can find it on the Change Password page in Odoo.
- Open Odoo, then go to Settings > Users & Companies > Users.
- Choose a user, then click Action > Change Password.
How to generate an API key in Odoo
- Click on your profile in the top-right corner, then click Preferences.
- Open the Account Security tab.
- Click New API Key under Developer API Keys.
- Enter a key description, for example, Plecto.
- Click Generate Key. Make sure you store the key securely – you won't be able to access it again.
Find the complete guide in Odoo's developer documentation.
Server URL
The server URL is your domain. For the cloud version of Odoo, it could look something like mycompany.odoo.com
Database name
For the cloud version, the database name is the subdomain. In the example mycompany.odoo.com
, the subdomain is mycompany
.
Step 2: Create Odoo data sources in Plecto
- Go to Data management > Data sources > + New data source > Odoo.
- Fill out the details, then click Next.
- Choose the data types you want to import.
- Click Next to continue and import your data.
You have now integrated Odoo with Plecto. You can use the same credentials is you want to add more data sources later on.
Looking for KPI inspiration?
Read our blog, visit our KPI library, or go to Plecto Store and see if there's something you like!
Was this article helpful?
Please leave a comment to help us improve.