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 …

THE main advantage for using the OpenERP API instead of the direct access to the database tables is the requests go through the ORM, so you get data consistency and take advantage of the ORM’s create() and write() logic, and model default values.

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…