openerp-community team mailing list archive

[Florent THOMAS <mailinglist@xxxxxxxxxxxxxxx>]

Hy Folks,

I'm using all the pentaho stuff with openerp :
- Pentaho Reports for OpenERP
- Pentaho Kettle for data integration

I've recently merged 4 companies coming from 4 different databases with 
no id export into a single openerp database with multi company environment.
I precise also that Kettle could also be launch through CLI. I design 
with the UI and deploy it on my server and launch it with cron.
I also precise that Kettle could launch any script even python, access 
to the openerp API thanks to the awesome project : 
https://github.com/DeBortoliWines/openerp-java-api

Frequently my coworkers are wanting to create kettle export instead of 
coding python. I always refuse this for many reasons :
- The closer you are from the core the better you are to debug
- The lower number of tools your working with the mighter your are when 
you're working on it
- The lower number of workflows you have to manage, the easier to 
disgest is your spaghetti dish !
- The "new fun" tool is not always the answer
- A UI oftently hide the complexity of a task

So maybe kettle could be a great help for cleaning datas before 
upgrading but I don't think that would be a great idea to use it for 
OpenUpgrade as a single answer.

Regards



Le 30/05/2014 10:45, Peter Langenberg a écrit :
> +1 Daniel
>
>
> 2014-05-30 10:00 GMT+02:00 Daniel Reis <dgreis@xxxxxxx 
> <mailto:dgreis@xxxxxxx>>:
>
>     David,
>
>     I've been using Pentaho Kettle with OpenERP for a few years now,
>     so I'm
>     quite comfortable with what you can do with it.
>
>         About Pentaho Kettle, I read HERE[1] that it has a GRAPHICAL
>         TOOL FOR ETL and can be used to update a database. This sounds
>         for me like a hot canditate for OpenUpgrade, especially to
>         improve usability and stuff
>
>
>     Since it's a graphical tool you can get the impression that it's
>     "easier".
>     But as soon as you get to do more complex or extensive data
>     handling, a GUI
>     starts being more a hurdle than a help.
>     And the transformations you design are not simpler nor more readable
>     compared to scripted code.
>
>
>         I imagine a VM (probably even using vagrant boxes or docker)
>         that has a ready configured data migration server, where you
>         can easily manipulate ETL and stuff WITH A KIND OF INTEGRATION
>         OF PANTAHO KETTLE AND OPENUPGRADE-LOGIC, maintained and
>         alimented with best practices from github, making it easy easy
>         easy to set up and share migration pipelines for modules.
>
>
>     I think Kettle is an excellent tool than can aid you in a lot of data
>     integration tasks.
>     But I honestly don't think it would do a good task at OpenERP
>     version upgrade.
>
>     For a "black box" upgrade you want to run a command on your server
>     and let it do the magic for you.
>     That's a perfect job for scripts. And that's what OpenUpgrade is
>     all about:
>     provide migration scripts for OpenERP modules.
>
>
>
>         My general mission, I feel myself dedicated to within the
>         community, is usability and tearing down hurdles and
>         inconveniences. Such proposal would perfectly fit. I think
>         people are just inherently lazy, so if we could maximze
>         convenience we could maximize contribution and therefore
>         probably momentum and quality of the whole project.
>
>
>     As I mentioned before, I don't think Kettle would be a good choice
>     here.
>     My suggestions on how you could contribute are:
>
>     * Write a good tutorial text to help people start with OpenUpgrade.
>     * Eventually, write a GUI program to wrap around the OpenUpgrade
>     scripts, like what some programs do for bzr or git.
>
>
>     Keep up the enthusiasm and hope to see nice things from you soon :)
>
>     /DR
>
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~openerp-community
>     <https://launchpad.net/%7Eopenerp-community>
>     Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
>     <mailto:openerp-community@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~openerp-community
>     <https://launchpad.net/%7Eopenerp-community>
>     More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp