I have actually been having very good luck so far with what Adrian Crum suggested earlier today in this thread.I created another group-map for my legacy Oracle database which is offsite. I'm going to have to create entities for each element of my legacy database that I want to interact with of course, but that is OK with me as long as I can get OfBiz to communicate with my legacy system.
----- Original Message ---- From: Jacques Le Roux <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, March 13, 2008 3:07:16 PM Subject: Re: Oracle integration/Import best practices If I understand you well, you don't have the opportunity to use ESB tools like Apache ServiceMix or Mule ? I you only have access to the Oracle DB, I will tend to say that you should avoid importing and should rather use queries. But that's not really an advice just my opinion, my 2 cents if you like. Jacques From: "Peter Felts" <[EMAIL PROTECTED]> > OfBiz community: > > I want to ask you all a best-practices question: putting aside my > knowledge limitations of OfBiz and Oracle, what would be the > best way to integrate my OfBiz applications with a separate Oracle > data warehouse? Let me provide a little background: I am > developing my own OfBiz application that handles customer orders. > This application will serve as a tool to address the limitations > of our current CRM software. The CRM we use is not extensible > nor is it open, so the ability to add my own module is out of > the > question. The good news is that I have access to a data > warehouse through Oracle which gives me access to all my company's > data. > > What I want to do is create an application what will query my > company's customer database and product database. Do you think that > I should run direct queries against the data warehouse, or should > I create some type of automated import to import the data > warehouse data into custom OfBiz entities daily? > > Any advise you can provide as to the direction I should look > will be very appreciated.
