Universe connects to Two different data sources

building semantic layer
1

Hi,

  My requirement is like this.

We have two databases ( Both are different) one in Singapore and another in USA. Both are connected to a single Universe. When a user from Singapore connects to Universe he should access only Singapore Database, And when a user from USA connects to Universe he should access only USA database. Is it possible or Not??

 As far as my Knowledge we can not connect a single universe to two different databases.

  Any help would be grateful

vijayakrishna.bos (BOB member since 2007-08-29)

2

There are limitations in terms of how and which databases you can connect to in 1 universe.

However, in your case what would help is called universe overrides. Basically, if the structures in both databases are exactly the same and 1 universe can be used on top of any of them then use universe overrides and change universe connection based on the user that uses it. So if the user that is going to use the universe is from Singapore then the default/original universe connection will be automatically changed to a connection that points the universe to the database in Singapore. If the user is from USA then either keep the default connection (that points to the database in USA) or if the default connection is dummy (or points to another database) then change it to the connection that will point the universe for the user to the DB in USA.

All of the above is done either in Supervisor (if you use BO 6.x or below) or in Designer (menu Tools -> Manage Security -> Manage Access Restrictions) if you use BO XI and above.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi Marek,

   Thanks for your reply. I am using XIR2. Can you please dscribe in detail how can we specify this in Designer (in Manage access restrictions)

vijayakrishna.bos (BOB member since 2007-08-29)

4

[quote:355429609e=“vijayakrishna.bos”]Hi Marek,

   Thanks for your reply. I am using XIR2. Can you please dscribe in detail how can we specify this in Designer (in Manage access restrictions)

[/quote]

Hi

You can go to Tools ->Manage Security → Manage Access Restrictions

You should have created two separate user groups namely USA users and Singapore users.
Now just add these user gropus to the right panel of the manage restriction window by clicking on the add gropus button

Then create two new restrictions on the left panel of the manage restriction panel.
In each of the restrictions select the appropritate database you want the user to access and then simnply assing the restrition to the groups.

See the attached picture for the guidelines

Thanks
Siddhartha
access restrictions.JPG

siddhartha.dubey :india: (BOB member since 2006-09-13)