Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.
This article provides an overview to get started with the Odoo connector in Peliqan. Please contact support if you have any additional questions or remarks.
In Peliqan, go to Connections > Add Connection > Select Odoo in the list > Enter the details of your Odoo instance.
You can choose to authenticate with your username and password or with your username and an API key.
If 2FA (2-factor authentication) is enabled on your Odoo instance, you have to use an API key.
To create an API key in Odoo go to > My profile > Account Security > API keys.
If you don’t know your database name, you can make an unauthenticated API call, e.g. in Postman, to list your database names:
GET https://{domain}/web/database/list
GET https://{sub_domain}.odoo.com/web/database/list (for Odoo.sh)
Headers:
Accept: application/json
Content-Type: application/json
Body:
{}
The body must contain an empty JSON object !
Or you can reach out to Peliqan Support ([email protected]) to retrieve the name of your Odoo database.
You can include additional modules in the ETL pipeline, by adding a comma-separated list with the names of your standard and/or custom models, in the field “Additional models”. These models will now also be synced to the data warehouse as tables.