Connect Talend To Odoo database

[et123]

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!

[Anonymous]

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

[gjeremy1617088143]

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

[et123]

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.

[gjeremy1617088143 · Accepted solution]

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

[ledgerlabs]

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.