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

Question Posted / venkat

2 Answers
7203 Views
Zensar, I also Faced
E-Mail Answers

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

how to limit number of rows in a report in business objects using webi?

3 Answers Cap Gemini, TCS,

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers

In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers Wipro,

I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help

1 Answers

how to improve the performance of the report

3 Answers

What is the difference between master-detail and Breaks?

3 Answers

what is fantrap and chasmtrap ?

5 Answers Tech Mahindra,

what is diff between webi,deski,infoview

2 Answers

why measure objects are semantically dynamic?

1 Answers

Approximatly how many enduser can use the each bo project?