can u create report to connect oracle and sqlserver at a time?

Answers were Sorted based on User's Feedback



can u create report to connect oracle and sqlserver at a time?..

Answer / praveen

Yes we can create a single report on two different db's

Open the Rich client and create a query on the universe
connected to Oracle db and then click on new query option,
then select the 2nd universe which is connected to
Sqlserver, create the 2nd query and run the queries.

I hope this will help.

Is This Answer Correct ?    11 Yes 2 No

can u create report to connect oracle and sqlserver at a time?..

Answer / gs2kumar@gmail.com

No We cannot connect to multiple databases at a time by
using single datasourse only we can create the report

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Business Objects Interview Questions

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers   iFlex, Pfizer,


What is the pivot option ? what is the need of it?

1 Answers   Infotech,


What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  


please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers   Wipro,


Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers   HCL,






What are the steps to be taken to schedule the report?

0 Answers  


what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,


What is the difference between business requirement document and use case document.

0 Answers  


generally how do we get information for creating universes and reports

1 Answers   Satyam,


what is difference between global filter an query filter in web intelligence?

3 Answers  


How to fix the order of Prompts? How to assign the default value in prompt?

2 Answers   Mind Tree,


Categories