ETL - Move data between Odoo databases easily
1. ETL Move data between Odoo databases easily Juan José Scarafia ADHOC
11. ETL - Move data between Odoo db’s easily Sample Video
13. Thank you! https://github.com/ingadhoc/odoo - etl www.adhoc.com.ar
4. How to use it? ETL - Move data between Odoo db’s easily On Odoo 8.0 empty db → Install ETL Module 1
6. How to use it? ETL - Move data between Odoo db’s easily ● Read → Models and fields 3
8. How to use it? ETL - Move data between Odoo db’s easily ● Test actions and apply minor adjustments 5
9. How to use it? ETL - Move data between Odoo db’s easily ● The migration model is Ready!! → You can run it as many times as you want (even with db’s data changing over time) 6
7. How to use it? ETL - Move data between Odoo db’s easily ● Build actions: Automatic matching of models and fields between db’s ● Order actions for relational fields 4
5. How to use it? ETL - Move data between Odoo db’s easily ● Configure Odoo Databases Data (Origin and Destiny) ● Parametrize → Select Models to include 2
2. What is it for? 1. Migrating Odoo db’s between different Versions (ex:7.0 to 8.0) 2. Joining Odoo db’s 3. Synchronization of Odoo db’s 4. Cleaning data from Odoo db’s ETL - Move data between Odoo db’s easily
3. What is it? 1. It is an ETL tool (Extract, transform and load) 2. It is developed as an Odoo Module ETL - Move data between Odoo db’s easily db A db B Odoo with ETL db Odoo version X Odoo version Y
12. Project: https://github.com/ingadhoc/odoo - etl Sample video: https://youtu.be/ZfcPan3XDGI ADHOC Repositories: https://github.com/ingadhoc ADHOC Website: www.adhoc.com.ar Twitter: @jjscarafia ETL - Move data between Odoo db’s easily Useful Links
10. Advantages 1. Can be use by functional consultants 2. Simple development, native odoo methods 3. Odoo Module 4. Works in any odoo version (tested from v6 to v8) 5. Multiple Uses Improvement opportunities 1. Multi language support (only one language for translatable fields) 2. Improve speed, kind of slow for big databases due to xmlrpc export and load methods 3. It requires odoo server adaptation to simplify migration process for selection fields ETL - Move data between Odoo db’s easily
- 1176 Total Views
- 493 Website Views
- 683 Embeded Views
- Social Shares
- 0 Likes
- 0 Dislikes
- 1 Comments
- 0 Facebook
- 0 Twitter
- 0 Google+
- 2 www.odoo.com
- 1 www.google.com
- 1 onlinesync.odoo.com
Keynote: Odoo 9 New Features41054 Views .
Odoo Mobile Development Framework & App build with it11552 Views .
Odoo 9 New Design- The rationales behind it11403 Views .
Open Source Licenses9425 Views .
How A/B testing can help you optimize your website8585 Views .
Shipper integration - UPS, DHL, FedEx7533 Views .
Import and export data - Tips & Tricks6177 Views .
UX best practices to create your module6096 Views .
Keynote: Odoo Strategy 20155958 Views .
How to use Odoo in a Restaurant5545 Views .
Odoo 9: New Business Model5411 Views .
Contributing to the Odoo Community Association (OCA)4825 Views .
Odoo cms Performance Comparison and Optimisation4757 Views .
VOIP: One-click Button to Automate Calls4273 Views .
First steps in Odoo dev3968 Views .
Odoo 9 New Design- Usability Methodology3812 Views .
How to use Odoo in a service company3767 Views .
Advanced Features of the API3747 Views .
State of the Odoo JS framework3687 Views .