Setup of Cognos connection to datamarts using Oracle.

About this task

Note: - Follow below steps when Oracle and Cognos are installed in the same machine.

Procedure

  1. Open web browser and type "http://computername/cognos10".If the Welcome screen opens then click the link to "Administer IBM Cognos Content" from the Administration section.
  2. Select Configuration tab and "Data Source Connection" from the left hand pane.
  3. Select "New Data Source" icon.
  4. Mention the datasource name as 'curamreporting' (do not change the datasource name), and let the location be default one. If the datasource name already exists then click on 'curamreporting' and select the "Connection" Icon and enter the Connection Name and click Next.
  5. Select "ORACLE" from the drop down list of TYPE and set "Isolation level" to default.
  6. Click Next
  7. Enter the Sql * Net connect String as (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=system name)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
  8. Check all option under "Signons".
  9. Enter the Userid and password. e.g., datamart and p.(Assuming user by name 'Datamart' is already created with password "p")
  10. Click on "Test the connection" link.
  11. Click Test. Should be able to see the test succeeded, else go back to previous page and check the Login details.
  12. Click Close, will take you to the previous page.
  13. Click Next.
  14. Set the Commands page to default.
  15. Click Finish.
Parent topic: Deploying BIA Reporting to Cognos