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


Please Help Members By Posting Answers For Below Questions

What are query items?

571


what do u mean by bridge group? where we r using this one?

1545


-----------With out using DrillThrough how to do Reports?

1601


what is log in cognos?

660


What is defined as Cognos Impromptu?

635






Can we test the report other than manual testing?

1657


Can you define query studio?

565


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

1630


What is difference between informatica power mart and power center?

563


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1595


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

1966


-----------------What is Determination Model?

1689


How to deploy from one server to another server?

2015


------------ Diff b/w MemberCaption and MemberDescription?

1905


What is difference between primary key and unique key constraints?

564