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.
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