Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi everyone :)
does anyone know a simple ready made ETL that works well with Odoo? I'd need a way to extract product data from Odoo, transform them to certain csv files and provide customers with them. I also would need to import their orders and load those to Odoo... and some other stuff, too, fully automated of cause.
Does anyone know an ETL or maybe at least a basis, framework or something to make that a reality?
Hi there, reporting back after a while. So I did solve it, but not with any of the recommended solutions. In the end I developed my own (kinda) ETL. Just a Debian server with a MySQL database, some scripts and an FTP server. The data is exchanged via CSV files. Super easy to use with my other systems.
I then asked an Odoo partner to arrange for the im- and export in Odoo and they just use the native im- and export feature of Odoo via CSV. So I can test any format of data by simply importing a CSV file by hand or arranging my own export template.
The trick is not my little server shoving data around but using the native functionality of Odoo. I therefore could have used any other ready-made system as long as someone arranges the automatic im- and export in Odoo.
The disadvantage of not having a fully integrated ETL is that the Odoo partner has to arrange for the automated im- and export over the FTP server. But I can live with that, as my demands do not change very often.
Hopefully that helps someone and maybe we get a fully fletched ETL making use of the Odoo API one day 😀
see this module in version 9 :
https://github.com/ingadhoc/odoo-etl/tree/9.0
Thx, Ibrahim, but unfortunately I have to guess that too much has changed since v. 9 to adopt an unknown project like that. But thank you anyway :)
Hello,
We are working on this etl https://github.com/cyberwave-odoo/odoo-etl.git it is written with odoo. It compares the input data and the new data with a hash function.
Kind regards,
Jérôme Dewandre
See what you can do with Talend Open Studio https://www.talend.com/products/talend-open-studio/ and this module https://github.com/Smile-SA/odoo_addons/tree/13.0/smile_talend_job
Try also to take a look at Talend Community Discussions and see what you can find https://community.talend.com/s/ct-p?language=en_US&CategoryId=tld_discussions .As an example https://community.talend.com/s/question/0D53p00007vCnnaCAC/data-integration-for-odoo?language=en_US
At last Google for Talend and ODOO, and also Pentaho data Integration.
There is a no-code Odoo ETL connector available in Nexla.com that helps you create a data fabric on top of your Odoo data or push the data to the destination of your choice.
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Inscribirse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
1
jun 23
|
2844 | ||
|
1
may 15
|
4594 | ||
|
0
mar 15
|
4949 | ||
|
1
mar 15
|
7732 | ||
|
2
mar 15
|
7516 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
