Odoo Source Connector

The Odoo source connector lets DataSync retrieve data from your Odoo instance and load it into your data warehouse. Before setting up the connection, make sure your Odoo environment is correctly configured. The time zone in Odoo must match the time zone you specify in DataSync, otherwise synchronization issues can occur.

Once your source connection is ready, configure your destination connection to finish the setup.

note

Only Odoo Online is supported at this time.

Step 1: Set up your Odoo environment

Create an API key

1. In Odoo, select your user profile icon in the upper right.
2. Under My Preferences, select the Security tab.
3. Select Add API Key.
4. Enter your current password.
5. In What's this key for, enter a description so you can identify the key later.
6. Under Give a duration for the key's validity, select a duration.
7. Click Generate key.
8. Copy the key and store it securely. You cannot view it again after closing this dialog.
9. Click Done.

Find your database name

You can find your database name in two ways, depending on your account type and deployment.

From your user profile (admin accounts)

From your user profile

1. In Odoo, select your user profile icon in the upper right.
2. Select My Databases.
3. Sign in with your email and password.
4. Under Databases, locate the database you want to use and copy its name. You will need this name when configuring the connection in DataSync.

From the URL

From the URL

Use this option if you do not have admin access. Note that the URL does not always match the actual database name, so verify it before using it in DataSync.

• Odoo Online: The database name typically matches your Odoo subdomain. For example, if your URL is https://contoso.odoo.com, the database name is contoso. DataSync detects this value automatically in most cases. If it cannot, enter the name manually.
• Odoo On-Premises: Sign out of Odoo, and then select Manage Databases on the login screen to find your database name.

Step 2: Create the source connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Source Connections, click New.
4. Select Odoo.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any extra parameters you need.
7. Configure the advanced settings to match your environment, including Tracking Type.
8. Click Save.

Connection properties

Property	What to enter
Description	Unique name for this connection. Example: Odoo.
Odoo URL	Base URL of the Odoo instance. Example: https://company.odoo.com/odoo.
Database	Name of the Odoo database. Example: company.
User	Odoo account used to authenticate. Typically your username or email address. Example: admin@company.com.
API key	API key used to authenticate. For Odoo 14 and later, use an API key. For Odoo 13 and earlier, enter your Odoo account password instead. Example: a1b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6.
Edition	Odoo edition you are connecting to: Odoo Online or Odoo On-Premises.
Timeout	Time in seconds to wait before a connection attempt or query execution times out.
Verbosity	Controls how much detail the connector writes to the log. Each level includes everything from the level below it, plus additional detail. 1 logs queries, row counts, execution start and end times, and errors. 2 adds cache queries and HTTP headers. 3 adds request and response bodies. 4 adds transport-level communication. 5 adds all interface commands.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
Property	Connection string property that defines the action or behavior. Example: ReadOnly
Value	Value for the property. Example: True
Type	Visibility settings: Visible or Encrypted.

Advanced settings

These settings control how the connector tracks data changes, handles time and regional configuration, and processes records during extraction. Configure them to match your Odoo environment so that results stay accurate and consistent.

Setting	What to select
Tracking Type	Method for tracking data changes: None or Date.
Region	Region setting for the connector, if required by your setup.
Time Zone	Time zone matching your Odoo environment.
Time Offset	Refresh offset in seconds to compensate for timing issues in record selection. Minimum 0, maximum 3600.
Batch Size	Number of records processed per batch during extraction. Larger batches can improve performance but use more memory. Default is 2000, maximum is 10000. Adjust based on your network speed and disk performance. The default works well in most cases.

Example setup

Completed Odoo source connection in DataSync, with all properties and settings filled in.