Skip to Content
Menu

ETL - Extract Tranform and Load Data

by
Odoo
v 7.0 Third Party 1268
Download for v 7.0
Availability
Odoo Online
Odoo.sh
On Premise
Technical Name etl
LicenseAGPL-3
Websitehttp://cubicERP.com
You bought this module and need support? Click here!

Manage and Perform ETL Operations in OpenERP

Add ETL funcionality to OpenERP to extract, transform and load data from any source like to an ODBC, other PostgreSQL or other OpenERP

Main Features

  • Support ODBC, PostgreSQL and XMLRPC as source or destinity server
  • Support dinamic mapping of fields and values
  • Support equivalent table to transform the values
  • Execute Jobs from a shell script or a OpenERP Task
  • Detailed log with errors, warnings and information
  • Jobs by batch or per call

Main Libraries

  • OpenERP ETL Client https://pypi.python.org/pypi/openerp-client-etl

Installation

First you need installa the pyodbc library on your system, use the next commands for Ubuntu:

$ sudo apt-get install g++ $ sudo apt-get install unixodbc unixodbc-dev $ sudo apt-get install python-pyodbc

ETL Module need the OpenERP ETL Client Library installed on your system, in order to install this library use the cross platform easy_install:

$ easy_install openerp-client-lib $ easy_install openerp-client-etl

About the Author

Cubic ERP has started projects with OpenERP from 2009, and initiated as OpenERP CTP Partner from 2011. We are expert consultors with certification FEC-V7 of OpenERP, and top contributors on apps.openerp.com with more than 75 modules published and 5 modules included on ofiicial release of OpenERP.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.