I have a question regarding creating universe from 2 databases( Oracle and DB2). Is it possible at Universe level??
raruna19 (BOB member since 2010-04-21)
Sorry, not with an out of the box universe.
V
Eric Vallo 
(BOB member since 2002-08-15)
Directly, no. A universe uses one and only one connection.
Indirectly, it’s possible, but not with a Designer solution. At the database level, you can create “links” to other database systems. For example, in Oracle you can create “links” to the DB2 tables. In your Oracle-based universe, those tables APPEAR to be in the Oracle database. Warning, usually results in TERRIBLE performance.
The BusObj solution is another product called Data Federator. Essentially a server-based solution that handles the database connections, then the Designer universe looks at Data Federator as it’s “single” connection. Currently a separate product ($$$), but I believe there is talk of integrating that functionality into Designer in a future release.
Dwayne Hoffpauir (BOB member since 2002-09-19)
Do you have the possibility of a database link (or portal) between the two? if so, then you might be able to create a synonym pointing to the other database.
The big issue that I can forsee is that business objects extracts information from the database data dictionary. Information stored on a remote database is not stored locally and would be hard to insert into your universe because of that.
digpen (BOB member since 2002-08-15)
You can also try some other EII/data federation solution like Composite.
ramaks (BOB member since 2009-03-31)