Universe accessing multiple databases

[Former Member]

<p>Hi,</p><p>Here is the problem I am facing:</p><p>1. we have 20 databases. The structure of these databases is same, data is different. </p><p>2. we need to create an XI environment, where people can query on these databases using web intelligence.</p><p>How can I create 1 universe that can read from 20 different databases?</p><p>Thanks.</p>

[Former Member]

You could look into using the BusinessObjects Data Federator product, that allows 1 universe to connect to multiple databases.

[Former Member]

A stupid method:

- Duplicate the universe 20 times and create 20 connections to 20 DB

- one universe connect to one DB

- In webi, u add query for the DB you want

 any better methods ?Â