Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone tell me the step by step process how to connect
cognos to oracle?
- 3 Answers
- 7756 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rashmi
Cognos connection to Oracle Datasource(JDBC Connction)
1. Go to IBM COgnos Administration
2. Go to 'Configuration' tab
3. Data Source COnnection
4. Top right cotner click on 'New data source connection'
5. Provide Name for your connection
6. Click next
7. From type select 'Oracle'
8. Select check box 'JDBC COnnction'
9. CLick Next
10. Provide connection string ***Get this detail from tnsname.ora file
11. crete signon (Provide database id & password)
12. Click next
13. In the next screen select 'Oracle Net descriptor'
14. Drive type 'thin'
15. Provide Database connction string value in the box for 'Oracle Net
Descripor'
16. Test the connection
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhavi
Cognos is a reporting tool so oracle is connected before
publishing the package in FM. Their is the connectivity to
oracle and the link is given after that the package which
is linked to oracle is published to report author then
after reports are generated which has got a link with the
oracle. Its simple.....
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / sunil
I think when during the ETL process ETL people will do the
connections to the required RDBMS in the form of ODBC
connections in taht way they can import the tables from
data source to target table (i.e in data ware house) data
warehouse acts as a data source to the BI modelers for
creating the interface.the project contains query
subjects .which contains the SQL statements.so ETL people
do the odbc connections during ETL process.
| Is This Answer Correct ? | 0 Yes | 4 No |
What is the difference between drill through, drill across?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
write a query to display to 10 max record from the employee table?
New coloums are added in database, then how you know in report level
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
difference between boxtype and visiable
1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?
Teradata 
