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 <dgr...@sapo.pt
<mailto:dgr...@sapo.pt>>:
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@lists.launchpad.net
<mailto:openerp-community@lists.launchpad.net>
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openerp-community
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to : openerp-community@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openerp-community
More help : https://help.launchpad.net/ListHelp
