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.
