Hi Nicholas and Michael, Thank you for your response! The basic requirement is to push the values from a real estate application necessary for OFBiz accounting.So obviously this requires web services triggered in client remote app(real estate property manager) controller action(per payment) or in it's schedule jobs(passing payment data by bulk). Then I checked some tutorial of OFBiz about web services: It includes this example of legacy db as datasource; the next one is using Axis to access via rpc wsdl to access the OFBiz webservice. I was also trying to do the REST where in I would create a resource POJOs in a OFBiz customize component, but it was not clear yet for me.
Lately, I was able to make the Axis2 web service via creating a client program to insert record to OFBiz accounting tables. I followed this tutorial https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=9798255. So at first, I was just trying out how to make a simple connection via web service following OFBiz Documentation to trace how creating a payment transaction works. I am still have to check deeper in using ECA and JMS. But as of now, I already tested inserting record for payment, person, fixed asset via Axis2 web service client. Regards, On Sat, Aug 12, 2017 at 5:08 AM, Michael Brohl <michael.br...@ecomify.de> wrote: > Hi Allan, > > to find the best solution, it would be helpful to know your requirements > for the interface between your system and OFBiz. > > In some cases, it might be a good solution to have an asynchronous > interface like a file import (e.g. if you have thousands of payment infos > in a short amount of time, or if you want to be able to preserve and > reimport your data in case of failure, etc.). > > In other cases, a web service interface like REST or a messaging solution > like JMS can be helpful. It depends on your requirements and environment > parameters... > > It's easy to provide your own services as REST services taking JSON data > from a specific URL, read, parse and convert it and call the standard > services to write data to the OFBiz database. You don't necessarily need a > REST framework for this (although it would be great if we have a standard > OFBiz way to deal with REST). > > I think connecting to a legacy db (which should be read only if updated > from other applications than OFBiz) is uncommon in your case. You would > have to monitor the legacy db or put some ECA's/triggers on it to be > noticed about the changes and write the data to the OFBiz database on these > events. For my taste it would tie the systems together instead of having > them loosely coupled. > > Best regards, > > Michael Brohl > ecomify GmbH > www.ecomify.de > > > Am 10.08.17 um 08:12 schrieb Allan Zarsuela: > > Hi OFBiz Dev/Admin Team, >> >> Good day! Currently, most of my concern is to integrate our company system >> to >> OFBiz Accounting module. I am following the tutorial but I am currently >> experiencing bugs/bottlenecks such as in connecting to a legacy db and the >> the SOAP RPC example integration with LifeRay(https://cwiki.apache. >> org/confluence/display/OFBIZ/Calling+OFBiz+services+from+Lif >> eray+using+SOAP). >> I am missing the correct jars. As I see there are deprecated tutorials, I >> don't know which one will fit the release 16.11 svn release. For this, I >> created an issue in stackoverflow.com which is >> https://stackoverflow.com/questions/45569501/how-to-pass-dat >> a-from-a-remote-database-into-ofbiz-database >> >> Now, I am trying the REST approach in https://cwiki.apache.org/confl >> uence/display/OFBIZ/REST+Service+Implementation >> >> >> As a summary, I am passing payment info from a separate JSF application >> towards OFBiz Accounting module. So as I look in the OFBiz documentation, >> there are several ways... 1. By reading XML file 2. Via connecting to a >> legacy db 3. By SOAP RPC 4. Via REST. So the tutorials from 2,3,4 methods >> are very limited and missing details. And I don't know even it works in >> the >> latest version of 16.11 updated svn link. >> >> Platform Summary: >> >> Eclipse Oxygen(OFBiz) >> Netbeans IDE(Remote Application/Our PrimeFace-JSF application) >> Ubuntu 16.04 >> For SOAP RPC client : >> -jaxrpc-api-1.1.jar >> -wsdl4j.jar >> -axis-1.4.jar >> -commons-discovery-0.5.jar >> >> I hope you can help me find the necessary tutorial for the integration. >> Thanks a lot! >> >> Regards, >> >> > > -- *Allan L. Zarsuela* *Software Developer*
