Home > IT Answers > SAP > Can 1 get data from 3 different DBs to write ...
Vitrodisc
5 pts.
0
Q:
Can 1 get data from 3 different DBs to write an SAP BO WEBi report
Business Objects, WEBi, SAP BusinessObjects, SAP BusinessObjects Web Intelligence
My company stores data in different databases in the same network. These databases have the same schema.
Can one write say 1 WEBi reports that would get data from different databases.
example
DB1 has Customer names (A-J)
DB2 has Customer names (I-O)
DB3 has Customer names (P-Z)

from the above scenario, how would one go by to create WEBi report that would display all names (A-Z)
Can one create one universe for 1 DB, and some how create WEBi reports that could be written that would get data from these 3 universes
or can one use data federator(with one universe), pointing to these 3 DBs
ASKED: Jul 2 2009  9:33 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carp
275 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
If I recall correctly, WEBI will only connect to one BO Universe and Universe can only connect to one DB. BO does have a tool - Data Federator that will connect multiple DB's together and present itself to WEBI as one Universe.
Last Answered: Aug 20 2009  6:14 PM GMT by Carp   275 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0