Help: External (non OfBiz) Oracle integration/Import best practices?

[Peter Felts]

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.

[Adrian Crum]

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.
>
>
>
>

[Peter Felts]

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 <[hidden email]>
To: [hidden email]
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.
>
>
>
>

[Peter Felts]

Also: what keywords would you suggest that I Google on for this issue?





----- Original Message ----
From: Adrian Crum <[hidden email]>
To: [hidden email]
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.
>
>
>
>

[Adrian Crum]

Yes, you can have multiple databases in the entityengine.xml file.

No, I used the default delegator. I just added the external database to
it by using the <group-map> element.

-Adrian

Peter Felts wrote:

> 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 <[hidden email]>
> To: [hidden email]
> 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.
>>
>>
>>
>>
>
>
>
>

[Adrian Crum]

ofbiz entity engine delegator


Peter Felts wrote:

> Also: what keywords would you suggest that I Google on for this issue?
>
>
>
>
>
> ----- Original Message ----
> From: Adrian Crum <[hidden email]>
> To: [hidden email]
> 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.
>>
>>
>>
>>
>
>
>
>