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
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
what are the filters in framework manager and report studio?
What are the components used in web tier?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
what is the difference between filter and condition?
Define olap designer?
What is drill down and slicing and dicing whats the difference between them?
what is model and say about process how to create model and how to test model?
What you mean by drill across?
Can you define transformer?
What is a Folder?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is defined as Cognos Impromptu?
how to create measures and dimensions?