topic Connect Talend To Odoo database in Talend Studio

Connect Talend To Odoo database

et123 — Mon, 28 Mar 2022 17:38:18 GMT

Hi,

I tried to connect to Odoo through JDBC API, but I just got a trial version for the jdbc driver odoo, and later it becomes paid.

Is there any other solution to make the connection ? someone told me to make it with RESTFUL, do anyone have an idea about it? thank you so much in advance!

Re: Connect Talend To Odoo database

Anonymous — Mon, 28 Mar 2022 23:57:21 GMT

I don't know Odoo database, however, If the Odoo database provides RESTFUL API, you can use tRest component to call the API in Talend job.

Regards

Shong

Re: Connect Talend To Odoo database

gjeremy1617088143 — Tue, 29 Mar 2022 07:19:49 GMT

Hi @eya tounsy , on many forum i've seen that the Odoo jdbc driver have a lot of issue so don't use it , as @Shicong Hong says and i'm following him on it, use rest component , by experience i've worked with other ERP and the most efficient way to acces data was by api. Odoo have surely a complete documentation on how to use their api like other ERP.

Send me love and kudos

Re: Connect Talend To Odoo database

et123 — Tue, 29 Mar 2022 17:05:33 GMT

Hi, thank you for your answers, but can you just explain more how to do it?

I don't need to set firstly a connection in Talend with odoo? (In Metadata section)

I just need to create a job and add tRest component and set the odoo URL, that's all ?

Thank you.

Re: Connect Talend To Odoo database

gjeremy1617088143 — Tue, 29 Mar 2022 18:04:55 GMT

it’s more than just put a tRestClient you have to understand how api works in general

https://www.odoo.com/documentation/15.0/developer/misc/api/extract_api.html

https://help.talend.com/r/en-US/7.3/esb-rest/trestclient

Re: Connect Talend To Odoo database

ledgerlabs — Fri, 22 Aug 2025 13:15:40 GMT

You don’t need a paid JDBC driver to connect to Odoo. Instead, you can use Odoo’s official XML-RPC or JSON-RPC APIs, which are free and well-documented. If you prefer a RESTful approach, you can either use community-built REST APIs for Odoo or create a custom REST API module to expose the data you need. This is usually a better and more cost-effective solution than relying on third-party JDBC drivers. For expert help with Odoo integration, you can check out The Ledger Labs.