can u create report to connect oracle and sqlserver at a time?
- 2 Answers
- 6762 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is diff between InfoView and Zero BOAdmin (ZABO)?
Explain about a tricky situation for which you found a very simple solution?
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
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
Explain what would you consider as your biggest achievement and why?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
What is difference between custom hierarchy and report based hierarchy?
What is mean by tuning the report?
Explain the difference between detect alias and detect context?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
What is the pivot option ? what is the need of it?
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
Teradata 
