Can 1 get data from 3 different DBs to write an SAP BO WEBi report
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
Software/Hardware used:
Software/Hardware used:
ASKED:
July 2, 2009 9:33 PM
UPDATED:
August 20, 2009 6:14 PM
RELATED QUESTIONS
- SQL 2005 Security to access 2 databases on same server via Stored Procedure
- Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?
- Access Filtering
- What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?
- How can create a document with a specific form in LotusScript?
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
