high level design help: how to plugin external webservices to get/store data

[neel blues]

Hi OFbiz group members,
 
I am fairly newly to OFBiz and wanted to find out if a design solution we are thinking is possible or not. Please let us know your thoughts. We want to develop an ecommerce website using OFBiz. All data related to the website is stored in a third party warehouse and will be accessible using webservices. So the new ecommerce site is acting more as a broker to this warehouse and all data is taken and sent to the warehouse (including submitted orders).
First option we are thinking is to plugin webservices client to the UI layer and rather than getting and storing data in OFBiz database, UI is communicating with webservice client. Would it be possible and advisable to bypass OFBiz database and retrieve data directly from webservices?
second option could be to have a module update OFBiz database daily using webservice calls. But this will require a thread checking at least Orders table frequently to transfer data from OFBiz to warehouse. However, based on my experience, threads on DB tends to cause performance issues.
So please let me know if you have any thoughts. I appreciate your time.
 
Regards,
Neel

[BJ Freeman]

simple answer it it is doable.
You will have a lot of duplication.
I think ofbiz overkill for what you want to do.


neel blues sent the following on 7/26/2009 11:48 AM:

> Hi OFbiz group members,
>  
> I am fairly newly to OFBiz and wanted to find out if a design solution we are thinking is possible or not. Please let us know your thoughts. We want to develop an ecommerce website using OFBiz. All data related to the website is stored in a third party warehouse and will be accessible using webservices. So the new ecommerce site is acting more as a broker to this warehouse and all data is taken and sent to the warehouse (including submitted orders).
> First option we are thinking is to plugin webservices client to the UI layer and rather than getting and storing data in OFBiz database, UI is communicating with webservice client. Would it be possible and advisable to bypass OFBiz database and retrieve data directly from webservices?
> second option could be to have a module update OFBiz database daily using webservice calls. But this will require a thread checking at least Orders table frequently to transfer data from OFBiz to warehouse. However, based on my experience, threads on DB tends to cause performance issues.
> So please let me know if you have any thoughts. I appreciate your time.
>  
> Regards,
> Neel
>
>
>      

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.