Pentaho Kettle / PDI is a powerful tool to transfer data between systems.
A lot of SME Malaysia or Local business are still using various sub system which , to migrate to openERP can be a pain in the butt ! And here the possible solutions , perhaps can be consider one of the most flexible way yet do not compromise the data integrity is using Pentaho openERP connector .
OpenERP kettle connector can be used for Data to be extracted using "input steps", and transform and then load into a new targeted object using "output steps".
Kettle is using a few library files
- ws-commons-util-1.0.2.jar
- xmlrpc-client-3.1.3.jar, and
- xmlrpc-common-3.1.3.jar.
- openerp-java-api-1.3.0.jar
We got it working with the 5.0.0-trunk version. Here's the steps :
Download the trunk version :
- make sure downloaded has the kettle-openerp-plugin in the /plugins folder.
- Now (re)start Spoon and a "OpenERP" will be available at Design tab in among many others containing three new steps: Delete, Input and Output.
after you connected , then you can proceed to design the transformation ...
On the downside, these steps don't handle XML Ids, only database (integer) ids, so you need to set your own strategy to identify records, such as using "reference" or "code" fields.
if you need help in setting up or manage migration process , you can contact us for a quote of our migration services , we work with various type of databases , Oracle , Microsoft SQL , Access , DBF , Paradox , Firebird , Interbase SQL , Excel file , CSV , text file and any form of databases.
if this article is useful to you , then please consider subscribe to us , so you can be informed when there is more information will be updating soon...
cheers!
Update Contact :
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email : Fajarudinsidik@gmail.com
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email: Fajarudinsidik@gmail.com
atau Kirimkan Private messanger melalui email dengan klik tombol order dibawah ini :
