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
Why are meta service important then other services?
Can you define dimension?
What are the different types of reports present in cognos?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Can you define set to be cardinality?
-----------Diff b/w OLAP and RDBMS?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
how to perform single sign in cognos by using url?
Define query items?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is metric store database?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Can you define transformer?
Can you define report item?
What is dtm?