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.
