Application with different data sources

[martinganserer]

Hello,

I have a question that might sound a bit strange to you.

My company wants to develop a new forecasting application.
Most of the information the forecast application needs, reside in other databases.

For example:
We want to track the forecast of our customers. But the customer data resides in our ERP system (Oracle database).
Would it be possible to create an enity bean "forecast" on the target system that references a "remote" entity bean like "customer"?

Remote means: The application uses a customer entity bean but the database table is in another database.

Thank you!!

[epbernard]

do you mean use the same entity class in several persistence unit?

[martinganserer]

Hi,

I think I would need two persistent units:
- One for the remote database with customer data
- and a second persistent unit for my forecast data