We are creating a Data Mart for the marketing department. Some people may need access to some data from the EDW and the Data Mart to create their reports.
Is there any way to access both of these sources in the same Universe since they are both Oracle?
johndawg 
(BOB member since 2004-07-09)
If they are in the same database, then yes. A universe uses one and only one connection. They can be in two different schemas (owners), but must be in the same database. If they are not in the same database, I think Oracle has a linked tables concept that can make it “appear” to be in the same database, although performance may be an issue.
Dwayne Hoffpauir (BOB member since 2002-09-19)
I believe it is called DBLink (making one Oracle database available to another Oracle database).
Andreas 
(BOB member since 2002-06-20)
Thank you…
johndawg (BOB member since 2004-07-09)