In a message dated 99-02-18 11:34:45 EST, you write:
Is there way to build a universe that contains objects from different data
sources from different dbms? For example, I’m able to combine multiple
databases from Sybase in a universe, but can I add Oracle, Access,etc.
objects?
You cannot use more than one RDBMS in the same universe at this time. That is
not to imply that you eventually will be able to, but just that you definitely
can’t right now.
Can this be done through linked universes? The manuals say linked universes
need to use the same rdbms.
That is correct.
The reason for this is that BusObj does not have the capability to “talk” to
more than one database at the same time, due to different protocols,
middlewares, etc. Each database connection must be opened and closed before
another is used.
However, you can access as many different universes (each with a single
database connection) in a single document as you like. In that way a user can
combine information from more than one database in a somewhat effective
fashion. There are issues with this; do a search on “linking data providers”
or other keywords in the archive.
A different option is to have some sort of transparent gateway installed on
the database server itself. In other words, if you can connect to Oracle
through Sybase, so that your Oracle tables are mapped to a Sybase database
(and therefore appear as objects in the table browser in Designer) then you
can accomplish use multiple data sources. Sort of. Because Sybase is (in this
scenario) in charge of gathering everything in one place, and thus BusObj only
needs to have one connection to access everything.
This can, however, result in a very complex database administration chore. Not
to mention performance problems. In theory it would work, in practice I don’t
typically see it done.
Hope this sheds some light on your question!
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)