Hi,

I have an application which currently uses one datasource. We have a new requirement, for which we need to fetch some data from another database.

There are two options.
1. Create a view in the second database and access that view by creating another sessionfactory in the code and access it directly.

2. create a dblink from first db to the second db and use synonyms to access the data from second db.

The question is which option is better(performance and design wise)

Thanks
Deepak

option 1 is preferable