Can anyone tell me the step by step process how to connect
cognos to oracle?
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 |
How to schedule the report twice in a day?
wat is bus schema?
how you create security to cubes ?????
Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
diff b/w dimension and regular dimension
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
What are the differences between Cognos 8 and Cognos 7.x version?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
what is a Galaxy Schema?
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
What are the advantages of cognos?
im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?