Interesting... So can you have multiple databases in the entityengine.xml file? Did you create a different delegator and name it something besides "main?"
----- Original Message ---- From: Adrian Crum <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, March 13, 2008 9:24:34 AM Subject: Re: Help: External (non OfBiz) Oracle integration/Import best practices? I've done something similar to that here where I work. We don't use Oracle however. We have legacy applications whose data needs to be accessed from OFBiz. The approach I took was to use the entity engine to access the external data. I created entity definitions for the external database, then added the external database to entityengine.xml. A Google search should provide additional details. One detail that must be mentioned though - put no-auto-stamp="true" in the external table entity definitions. -Adrian Peter Felts wrote: > 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. > > > >
