Setup of Cognos connection to datamarts using DB2.

About this task

Note: - Follow below steps when DB2 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 "DB2" from the drop down list of TYPE and set "Isolation level" to default.
  6. Click Next
  7. Enter "datamart" in DB2 Database name.(Assuming that user had created the database by name Datamart)
  8. Check all option under "Signons".
  9. Enter "db2admin" for the Username and Password.
  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