Can anyone tell me the step by step process how to connect
cognos to oracle?
Answer Posted / 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 |
Post New Answer View All Answers
what is stitch query in reportnet?
Please explain the different stages in creating a report in cognos report net?
Explain what is the difference between native sql and cognos sql?
What is the model filter?
What is the difference between the content store and content manager?
What are the types of catalogs in cognos?
What is a Framework manager?
What is difference between primary key and unique key constraints?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
what are slowly changing dimensions? Why we are used scd?
Can you define drill down and drill up?
what is the difference between querystudio in reportnet and cognos8
How to apply securities for reports in cognos connection?
How can create users and permissions in cognos?
What are all the types of gateway used in Cognos?