GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Objects

 Print  |  
Question:  Can a universe be connected to different databases?



December 12, 2006 19:09:07 #6
 Jay   Member Since: Visitor    Total Comments: N/A 

RE: Can a universe be connected to different databases...
 

In Xi rel 2 using data federator you can connect to multiple database.

in previous version there is work around, lets you have universe connecting to database user "A" and you are looking to add one more table from other database user "B".

What you can do give select grant  (in Oracle) to  user "A" from"B" and then create synonym in user "A".

Once you have done that open universe and change the connection to user "B" add table and then go back to connection "A".

I hope you understand.

     

 

Back To Question