Contents x
    Odoo as a Destination
    • 2 Minutes to read
    • Dark
      Light
    Contents

    Odoo as a Destination

    • 2 Minutes to read
    • Dark
      Light
    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.

    Prerequisites

    • For on-premises deployment of Odoo, ensure you have configured your network firewall to allow incoming connection from Dataddo IPs.

    Authorize the Connection to Odoo

    In Odoo

    For this destination, whitelisting IP addresses is not available in the database system. Instead, you can configure the network access at the firewall level. Here are the general steps:

    1. Identify the firewall that's protecting your service. This could be a Windows or Linux firewall running on the server itself, or it could be a network firewall.
    2. Open the firewall's configuration settings. The settings location will vary depending on your firewall type.
    3. Look for the setting that allows the definition of inbound rules or policies.
    4. Create a new rule or policy that allows inbound traffic on the port that the service is using (the default is 1433) from the Dataddo IP addresses.
    5. Save your changes and test the connection from Dataddo to make sure everything is working as intended.

    In Dataddo

    1. On the Authorizers page, click on Authorize New Service and select Odoo.
    2. Fill in the following fields:
      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, 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. Rename your authorizer for easier identification and click on Save.

    Create a New Odoo Destination

    1. On the Destinations page, click on the Create Destination button and select the destination from the list.
    2. Select your authorizer from the drop-down menu.
    3. Name your destination and click on Save.
    Need to authorize another connection?

    Click on Add new Account in drop-down menu during authorizer selection and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

    Create a Flow to Odoo

    1. Navigate to Flows and click on Create Flow.
    2. Click on Connect Your Data to add your source(s).
    3. Click on Connect Your Data Destination to add the destination.
    4. Choose the write mode and fill in the other required information.
    5. Check the Data Preview to see if your configuration is correct.
    6. Name your flow and click on Create Flow to finish the setup.

    Troubleshooting

    Was this article helpful?
    What's Next