2 ways come quickly to mind both with their pros and cons of course. 1) Keep in mind that OFBiz doesn't have complete control over the database, it is only connecting to it via JDBC. So you can use any tool that connects directly to the database and manipulate the tables/entities that way (generally through SQL statements).
2) Expose OFBiz services via SOAP and call those services from your external application. #1 is very simple to do, but you lose the benefit of the checks (referential integrity, etc) that the entity engine performs. #2 is a bit more entailed as it depends more on your ability to make SOAP calls from your external application. However, because you're calling the OFBiz service, it's manipulating data through the entity engine and so will maintain those checks. --- Andrew Ballantine <[EMAIL PROTECTED]> wrote: > OK I'll rephrase the question. > > How do I get data from an external application into > the OFBiz database? > > Do I get OFBiz? In principle I think I do. > > What I am I trying to achieve right now? Answers to > fundamental questions > that may or may not encourage me to commit to a 6-12 > project customising > OFBiz for a specialist client. > > Kind regards, > > Andrew Ballantine > > -----Original Message----- > From: Jacques Le Roux > [mailto:[EMAIL PROTECTED] > Sent: 11 January 2007 20:18 > To: [email protected] > Subject: Re: Sharing the OFBiz database. > > > Welcome on the new list (turing machine makes me > smile :o) > > Jacques > > ----- Original Message ----- > From: "Walter Vaughan" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, January 11, 2007 9:08 PM > Subject: Re: Sharing the OFBiz database. > > > > Andrew Ballantine wrote: > > > > > I realise that I can alter the application to > write the customer details > to > > > the DBMS, but am concerned that OFBiz might have > some problems if it has > > > been written assuming it has exclusive access to > the database. > > > > The way you ask your question makes me wonder if > you really "get" ofBiz. > Please > > don't take this wrong, and I know this is the kind > of thing that sounds > bad on a > > mailing list but would be fine face2face, but have > you really grepped > ofBiz? > > > > I say that because at the root level in my > kindergarten appreciation of > ofBiz, > > the foreign key retraints make sure you don't > create evil records or > delete > > required data, and that everything is atomic at > the service level. > > > > So adding orders to the database externally isn't > going to break it. > What'll > > break first is your mind learning the proper order > to load the data into > the > > database to avoid foreign key restraints. Once you > have that proceedure > figured > > out, then your're gold. > > > > At the end of the day ofBiz is still a turing > machine. Without getting to > deep, > > it's still just a tool. To most of the world, when > you own a hammer, the > whole > > world looks like a nail. But to 0.0079% of the > population, they see a > hammer and > > think of it as something to throw in order to win > gold metals. > > > > What drew me to the project is that the core > committers (to me) seemed to > see > > ofBiz not as a hammer for just building a house, > but a hammer that also > could > > win gold metals. > > > > -- > > Walter > > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.16.9/623 - > Release Date: 11/01/2007 > 15:33 > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.16.9/623 - > Release Date: 11/01/2007 > 15:33 > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.16.9/623 - > Release Date: 11/01/2007 > 15:33 > > > > ***************************************************************** > This email has been checked by the altohiway > Mailcontroller Service > ***************************************************************** >
