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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Jun 23
|
2844 | ||
|
1
May 15
|
4593 | ||
|
0
Mar 15
|
4948 | ||
|
1
Mar 15
|
7732 | ||
|
2
Mar 15
|
7515 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
