What end point in the Openbravo ERP side

<<

Adrian Romero

Posts: 3083

Joined: Wed Mar 18, 2009 1:55 pm

Post Tue Jun 16, 2009 12:50 pm

What end point in the Openbravo ERP side

What will be the end point for the data load in the Openbravo ERP side?


 


Two possible options:


* REST web services developed as a module on top on DAL 


* Direct access to the database tables.



Post Edited by adrianromero at 06/24/2009 09:15
<<

Adrian Romero

Posts: 3083

Joined: Wed Mar 18, 2009 1:55 pm

Post Wed Jun 24, 2009 10:14 am

RE:What end point in the Openbravo ERP side

Another option is to use the Data Access Layer (DAL) classes directly and executing the endpoing of the ETL inside the Openbravo ERP execution context.



<<

Dmitry Mezentsev

Posts: 309

Joined: Wed Mar 18, 2009 7:25 pm

Post Thu Jun 25, 2009 10:22 am

RE:What end point in the Openbravo ERP side

I would say that with using DAL (which looks the best choice in this task) we also have two options:


1. DAL API.


2. DAL XML convertion tool.


 


Here is the point where we need to get feedback from Martin and Ismael.

<<

Adrian Romero

Posts: 3083

Joined: Wed Mar 18, 2009 1:55 pm

Post Tue Jun 30, 2009 3:48 pm

RE:What end point in the Openbravo ERP side

Hello all.


 


The current status of this question is the following:


 



  • The option of direct access to the Openbravo ERP database has been rejected. The idea is to create the initial data load process more friendly with the current data interfaces proposed by Openbravo ERP and do not replicate functionality in the initial data load process that is already implemented in the current data interfaces, like execution of process, management of audit fields, management of primary key, ...


 



  • This question is closely related to other technical question: The posibility to integrate the initial load execution in the context of Openbravo ERP forum thread. ETL tools like Pentaho PDI and Talend make it possible to execute integration jobs embedded in the context of other applications like Openbravo ERP. From the implementor point of view is a good improvement because this way he will not need to deal with ETL. From an Openbravo ERP window he will have access to parametrize, execute and monitorize the ETL integration jobs without having to deal with another external tool. In the other side the ETL integration job will be tightly integrated with Openbravo ERP code and probably will not be possible to run in an isolated context, that is the usual execution mode of ETL integration jobs. For example, embedding ETL integration jobs in the Openbravo ERP context will problably prevent us to develop a connector for the ETL tool selected of the style of existing connectors for other applications like Sugar CRM, Salesforce, ...


 



  • To develop some functional requirements  like the defaulting mechanism and also access to data using DAL, can be too complex to implement in the context of an ETL job.  These kind of requirements will be easier to develop in plain java code.


 



  • The current REST web services interface contains all functionality needed by the Initial Data Load project? Load / save data, execution of Openbravo process, etc.? This question is important if we decide to go with REST web services and end point in the Openbravo ERP side.


 



  • Openbravo ERP entities structure evolves every version. This means that if entities used by the Initial Data Load change, the Initial Data Load code needs to be modified. This is important to keep in mind in order to find a solution that allows to inspect entities structure to validate the Initial Data Load process and to keep the block of code of the Initial Data Load process that depends on Openbravo ERP entities structure as small as possible.


 


To summarize, at this point the important question, depending of the data end point in the Openbravo ERP side, is if we are going to develop the initial data load project based on an ETL tool or in java, from scratch without any ETL  tool.


 


I would like all people with authority in these areas to give their opinion to help us to take the right direction in the Initial data load project


 


Thanks


 


Adrián Romero.


Return to Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

Website Terms


Designed by ST Software for PTF.