Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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
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.
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