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

Question Posted / venkat

2 Answers
6534 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

what is stacked chart , Bar chart, Column chart?

1 Answers Tech Mahindra,

1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?

2 Answers Mphasis,

Explain in detail about type 2(scd),

0 Answers

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers

What are the difference between merge,auto merge and extended merge ?

1 Answers Cap Gemini,

Can any one say me wat does"maintanence of universe" means wit?

2 Answers Business Intelligence Analytics, NAL, TCS,

Differences between business objects and web intelligence reports?

0 Answers

2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?